Clever Geek Handbook

Access will prevent me from seeing the changes I made to the database

I have an MS-Access database stored in a folder (yes, I have Edit permissions for the folder) on a Vista machine.

From my .NET application (VB2008) I can just query the database and add records to the tables. New entries are added when the application is restarted.

However, if I started Access (2000) and opened the database, the table I had just changed to did not add any new records to it.

Is there any incompatibility with Vista and Access 2000?

EDIT: When I open the same database in Access 2003 on an XP machine, the new records show up just fine.

+2


source to share


4 answers


Sounds very similar to experiencing Vista's virtualization feature. Vista won't let you write to the folder C:\Program Files

(and a few others), and instead of throwing an error at you, it writes a shadow copy to your Users folder.

To check, open the .EXE properties and check XP mode + Run as administrator. Also see if you can find the shadow in the C: \ Users \ User_name \ AppData \ Local \ VirtualStore folder



To fix the error, try to find your data elsewhere.

+7


source


See if the number of entries is increasing?
If so, the records may get there and due to indexing, it may not appear until the end.



0


source


Can you use a data type in your Access table that is not compatible with Access 2000?

[I know this is highly unlikely, but as they (more or less) say, "Desperate questions require desperate answers")

0


source


I know you seem to be sure that you are hitting the same DB from your answer to gbn's answer, but to be absolutely sure, how about this test?

Use Access to insert new records into Access and see if they appear in the app.

Another possibility is that it is in the DB, but you are using the application to read / write from a different table than you think. This explains the inconsistency that you also see.

0


source






More articles:


All Articles