Access 2003 - Network/Workgroup Environment
Posted on 2007-11-18
A bit of background to my problem:
I have a Access 2003 DB, which I have split, and my a MDE file of.
So in actual, I have 3 files now?
It is currently working only for one user. I would like to set it up so I can have multiple users (max 3) accessing the DB at the same time. Is this even possible?
I tried and tested it; how I went about it was; I put the DB on one PC and that user worked 100%. The second PC I just made a short cut of the DB (the DB.MDE file) and put in onto the second PC's desktop. Upon opening the DB, it keeps on asking saying that the file is not in the following directory. (example: C/DB/DB.mde)
It is obviously looking for the directory on the first PC.
Any help would be greatly appreciated.