When I copy an Access database to either a new location on the same Vista PC or a folder on another networked PC, the data in the DB is not copied. When I open the copied database all tables are empty. This happens even if I change the extension and copy it. If I try to transfer the file using several different utilities, like LogMeIn or TeamViewer or attach it in an email and send it, the database is empty when opened at the remote location.



I have added the Everyone Group to the Security to the folder the databases are in as well as changed the Owner to the folder to Everyone Group.

What is causing this? I have no problem on XP machines but I do have it also under Windows 7. I have several clients running Vista and Windows 7 and I can not copy or transfer the data so I can fix data entry problem or use their data to trace a problem in another folder.

Thanks for the tip but it deals with a different problem.

My problem is not with copying or moving the database, it is that all the data does not copy or move with it. Somehow Vista is stripping the data from the database when it copies or moves it.

The database is self contained. There is one database containing all the data and all the objects like tables and queries. When I copy this database to any new location either local or remote, all the data is lost. Only the data is lost while every object is copied.

This only happens with Vista and not XP. There is something in the Vista environment that causes this. Maybe a permissions thing or right on the file?

This sounds very like the problem I have. Installed Office 2007 after trying out Windows7 and the only Access file (.mdb) I have now is empty on viewing. It states I must open using IE or Access 2003. IE does nothing so have to try to find a copy of Access 2003. In Windows 7 it states that some content has been disabled by a security alert. Allowing the content though still produces nothing.
The only PC I have with XP hasn't got 2003 on it!!!

Originally Posted by Lottiemansion

Hi,

Do a "Save as to the new drive location or just try to save it to public etc. on the networked PC.

This will transfer the data & software file in a normal way & that could get around the permissions stuff you suspect is causing the problem.

Worth a try?

I've tried that with my similar problem, no joy. Everything looks ok until you open up the file and it is empty even though says has 1MB of data in it.