Linking Multiple Front-end Database Files

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I am having a problem with Access that I can not figure out. I hope someone
can help. I have three database files, two front-end and one back-end.
Front-end1 has two different users. Front-end2 has three different users.
Both front-end databases are linked to the back-end.

Person1 using Front-end1 could not open the forms because the linked tables
could not be found. They were correct but I relinked them anyway. Person2
using Front-end1 also had this problem so I relinked Person2. This caused
Person1's links to be bad again. This same problem is also happening with
Front-end2 and all three people. Each new relink only turns off the other
two people.

To make this problem even odder I asked two completely different people to
log in and test out this scenario and they are fine. They can both open it
at the same time or separately and the path to the tables is not an issue.

I know there are different ways to set up a database and I would prefer only
two front-end files to five (one for each person) so I was hoping to get this
resolved without having to go the individual front-end route. Any ideas???
Could this be network rights? I'm not using Access security at all. Thanks
for any help in advance.
 
Sounds like you have the front ends on a server. That's a non-no, leading to
the type of problem you describe, or worse, data corruption in the back end.
Put a copy of FE1 or FE2, as appropriate, on EACH user's system. Link each
copy to the back end using UNC, not mapped drive letters, i.e.
\\servername\folder\backend.mdb
-TedMi
 
Ann,

If you have not distributed a "front-end" file to each of the user then you
are defeating the very purpose of splitting the databse in the first place.

Place a copy of the front-end file on a users machine, link it to the
backend file that is located on a shared network drive. Do this for each
user, placing the correct fron-end file on their machine and linking to the
backend file.

There should be no confustion as to the line to the backend.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
I did what everyone kept saying and I have five front-end database and one
back-end database. Each front-end is in a separate folder and not on the
hard drive of the individuals PC because they move around a lot and I don't
want to confuse them with which one they are supposed to use. They all link
to the same back-end that is a different folder then the front-end databases
and I am still getting the same error. Only one of the five can use the
database at one time. If I re-link a user that can't access the database
then his works and the other four don't. Now what do I do??? Please help!!!
 
Back
Top