General discussion

Locked

Moving an access database

By mteal ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Moving an access database

by mbarker734 In reply to Moving an access database

To point the database program to the new table location open the DB and use:

Tools>Add-Ins>Linked Table Manager

Select the tables needing to be relinked (you can use the select all if you need them all). Locate the table.mdb at it new location and select open. The table(s) will then be relinked and the database program will function normally. You will only have to perform this once if all users use the same DB program. But if the DB program is individually installed on machines it will have to be performed on each machine.

Good luck,

Mark

Collapse -

Moving an access database

by mteal In reply to Moving an access database

Thank you very much for your help. I followed those steps and everything seems to have gone smoothly.

Collapse -

Moving an access database

by mteal In reply to Moving an access database

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums