database source file location

[Jason]

I am working on a database for a customer of mine, and
the person who wrote the database has it set were the
dataabase folders have to be on C: I would like to
change this to another drive letter, so I can move the
database to the server and map a drive for the clients so
they can all connect and make changes to one central
database....as it stands only one person can use the
database.....help would be greatly appriecated

Jason

 

[Jeff Boyce]

Jason

Two considerations to keep in mind...

First, you need to "split" the database if it is not already. Conceptually,
you'll be placing the data (only) on your server, and giving each user a
copy of the "front-end" (forms, reports, etc.). While it is not absolutely
required to do it this way, the only thing you'd get from putting the entire
database on the server is a raging headache, due to the regular corruption
caused by multiple users trying to use the same front-end features.

Second, you can "link" from a front-end to a back-end table (tables). To
avoid an issue with different users having different share letters/names for
a server, you can create your links with a UNC designation, of the form:
\\servername\folderpath\...\filename

Good luck!

Jeff Boyce
<Access MVP>