Moving the database
March 30, 2010 1:38 PM Subscribe
How can I move an MS Access file to another PC?
posted by MrMulan to computers & internet (3 answers total)
At my job somebody set up an Access 2003 database back in 2003 using the MSDE database engine for an .adp(access database project) file on an XP machine. Nobody knows who the somebody is.
I know the .adp file is the front end/metadata file and it works in conjuction with a .dat file. I assume that all the user input is stored here.
What I have done
1. Copied the .adp file and opened on another PC and got a [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied error.
2. Installed MSDE engine on new PC, did a backup of the database on the old PC(which created the .dat file), did a restore on the new PC, opened the .adp file on got the following:
FILENAME could not find the database on the server. Verify that the database name is correct.
I feel like I have all the pieces, but don't know how to put them together. Step 2 was accomplished after doing the Google.
The account opening the file is a local admin, so permissioning should not be the issue(?).
Any help is appreciated!