I have an access database residing on a server. I want to share
(mycompany.database) so that all users can input and see the data.

When I click on, say contractors, it says that the database couldn't be
opened cause it's looking for the folder on the C: drive. I have the folder
on the E: drive. How do I change the path to reflect this?

If you have split the database so that the tables are in another MDB file, go
to Tools, Database Utilitite, Linked Table Manager and relink to the file on
your network server.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"FrankF" wrote:

> I have an access database residing on a server. I want to share
> (mycompany.database) so that all users can input and see the data.
>
> When I click on, say contractors, it says that the database couldn't be
> opened cause it's looking for the folder on the C: drive. I have the folder
> on the E: drive. How do I change the path to reflect this?