How do I move an access database to a different share drive

[Guest]

Hello:

I am trying to move my Access database (in its entirety, not just tables) to
another shared drive at work for other employees to get to. How can I do this?

Thank you

 

[John Vinson]

Hello:

I am trying to move my Access database (in its entirety, not just tables) to
another shared drive at work for other employees to get to. How can I do this?

Thank you

Ummm...

copy the .mdb file.

All of the Forms, Reports, Queries, code, tables, etc. are in one .mdb
file, *unless* you have Split the database. For a multiuser
application you should certainly do so! See

http://www.granite.ab.ca/access/splitapp

for details. Each user should have THEIR OWN copy of the "frontend"
containing the forms, queries, etc., linked to a shared "backend"
containing the tables.

John W. Vinson[MVP]

 

[Joseph Meehan]

Hello:

I am trying to move my Access database (in its entirety, not just
tables) to another shared drive at work for other employees to get
to. How can I do this?

Thank you

If it is split you will need to re-link all the tables on the user's
machines. There are some tools available to help with this before the fact,
I don't think there are any for after the fact.

If it is not split, you should split it so each user has their own front
end and essentially only the tables are on the server.