If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Multiple Front-end Database Files
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. |
#2
|
|||
|
|||
Linking Multiple Front-end Database Files
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" wrote in message ... 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. |
#3
|
|||
|
|||
Linking Multiple Front-end Database Files
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 "Ann" wrote: 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. |
#4
|
|||
|
|||
Linking Multiple Front-end Database Files
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!!! "Ann" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|