Please forgive my complete naievity when it comes to Access. As a fairly new helpdesk operator, I’ve really not dealt with Access or other databases.
My question is about how to move an access database from one location on a network to another.
The situation, as was explained to me is this.
The user starts the database by double-clicking an icon on their desktop. This points to c:\databases\dbase.mde
In turn, this is linked (sorry again – no idea how this occurs or how it was set up) to a database on the network g:\blah\dbase.mdb
I need to move the database from g:\blah to g:\xyz. I also need to allow another user to access the database.
I assume that I move the .mdb file to the new folder on G drive. However, I have no idea if/how I configure the dbase.mde file on the users’ local directory. I don’t know about ODBC settings or if I need to change these.
Also, does the new user simply need a copy of the existing .mde file or do I somehow create one for them?