Updating Linked Tables to Back End Problem

[gheyman]

I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to refresh the Links. Once the Links are refreshed it works fine until its closed. Once we reopen the FE the same problem happens. What's really confuses me is that if I am the only user getting in and out of the front end all day, there are no problems. I never have to refresh the table links.

Any ideas what's happening?

 

[tambadal]

Relink access database

I am having a problem with access linked table database. When my manager and I access the database. we have relink the tables every time. But when I don't access to the database, my manage can go using it all day without having to relink the tables. do you know what could possibly go wrong I really appreciate for your input of what to do to correct the problem. There are more users that will be using the database so it'd be great if we can find out what's the problem is. Thank you in advance.

 

[Joe4]

Re: Relink access database

tambadal,

Is your database split into separate front-end and back-end?
Does each user have their own copy of the front-end, which they are using?

 

[Joe4]

gheyman,

Are you and this other user using the same front-end?
Each user should have their own copy of the front-end.

 

[tambadal]

Re: Relink access database

Yes, the data is split into front end and back end, we all have access to same front end file.

 

[Joe4]

I merged these two threads together, as they are asking the same question, and I checked and I see that you are both posting from the same IP address, so I see that it looks like you two are working on the same issue.

 

[tambadal]

If each user have their own copy of the front end, will it fix the problem with us having relinking the tables?

 

[Joe4]

Yes, the data is split into front end and back end, we all have access to same front end file.

No, that is not the proper way of doing it, and really defeats the purpose of splitting the database.
Each user needs to have their own, separate copy of the front-end database.

 

[xenou]

Have you looked at the links? Are there differences in mapped drives (E:\MyDb.accdb or F:\MyAccdb or \\mynetwork\MyDb.accdb and so on). Is everyone on the same local network?

 

[gheyman]

Joe;

your correct, we ended up working the same issue. Same problem, same database

We all use the same FE. No one has their own copy of the FE