Can separate database files interact with each other?

[Matt020]

Hi, i'd grealty appreciate advice on the following.

I'm developing an access 2007 database (all self contained in one file on my desktop at work), and i'm worried that changes i'm making are not restricted to this one file. For example, when I change a field name in a table, the change also occurs automatically in a serpate backup file that I keep. Also, my computer has been crashing other split multi-user database's when I load them up, and this only occurs on the computer i'm using.

Is there a simple way of ensuring that the database i'm developing is not going to interact with other exisiting database files and cause an awful catastrophe? Many thanks.

 

[apr pillai]

Your files are on a Network and working from your PC. Assume that the Network Folder is configured to Work Offline also. For some reason if the Network temporarily fails you can work with your files uninterupted (on the copy the system maintains on your local drive) and you will not know that you are working on the copy on your PC.

When the LAN is up the backup copy of the files on your PC are Synchronized with the Original on the Server, which will reflect all the changes that you have made offline.

Check whether you are in such a situation or not. Right-Click on your Network Folder to bring up the shortcut menu and check for clues.

 

[Matt020]

Thanks for the info - but I'm not sure I understand. Can you tell me specifically what I need to check for in the network folder?

Thanks