Requerying OBDC databases

[N. Farr]

Hello all,

I imported external data via an ODBC database with no problems. Access is
displaying the data fine, but I am now trying to refresh the data (or rather
requery the database) to show newly added/deleted records but nothing's
happening.

I was first doing a Records -> Refresh, but that didn't work, so a little
bit of searching showed that I should requery with Shift + F9, but that's not
working either. I personally added records to the database and I see them
added in phpmyadmin, but Access is not getting them.

Any ideas?

Thanks

PS: I posted this in the import/export data newsgroup but it hasn't had any
posts since 2004 so I'm posting it here also =)

 

[Pat Hartman\(MVP\)]

Does your form have a filter or where clause that is preventing the new
records from showing?

 

[N. Farr]

No it doesn't. I added a linked table instead of a just imprting data and the
updating is working fine. I guess that's what I should have done to start
with, but is there anyway I can make the linked table read-only? (i.e. linked
only way)

Thanks.

 

[Pat Hartman\(MVP\)]

You would need to use Access security to make the table read only. Before
you attempt anything with security, make sure you have several backups and
have read the Security FAQ available from the knowledgebase or MSDN library.