I am brand new to access and I've been asked to look at a database.
My problem is that when I copy it from a networked area to my hard drive the links between the 2 are retained. I only discovered this after deleteting 100k+ records....!
It's likely that I've created a shortcut to the original but all the obvious checks suggest that I havent (database properties give the location of c:\) and it also took several minutes to copy the database from the networked drive to my c:\ drive.
I know they are linked not only because the 2 files update no matter which drive I modify, but also because if I unplug my LAN connection I can't open the database from my c:\ - it gives an 'object variable or with block variable not set' error.
This is probably something very simple but like I say I've never used access in anything other than a user capacity up until now. All help gratefully received.
My problem is that when I copy it from a networked area to my hard drive the links between the 2 are retained. I only discovered this after deleteting 100k+ records....!
It's likely that I've created a shortcut to the original but all the obvious checks suggest that I havent (database properties give the location of c:\) and it also took several minutes to copy the database from the networked drive to my c:\ drive.
I know they are linked not only because the 2 files update no matter which drive I modify, but also because if I unplug my LAN connection I can't open the database from my c:\ - it gives an 'object variable or with block variable not set' error.
This is probably something very simple but like I say I've never used access in anything other than a user capacity up until now. All help gratefully received.