Back End error

[mcupito]

Hello all,

I have 3 databases and a backend database. The 3 databases are front end files which users will be entering data and using forms/queries etc. All of these tables are linked with the backend database which consists of only the tables, which appears to be the correct way to do it from my research.

However, when users are attempting to run the databases, they are getting an error regarding the BackEnd db "could not be found."


What are possible solutions for this?

Thanks.

[BikeToWork]

In the linked table manager check that the correct path for the back end database tables is listed and use the full UNC path as opposed to a mapped drive. All users of your database may not have exactly the same drive mapping. If you've already done this step and still get the same error message, check to make sure that the back end database opens properly. It is possible the back end is corrupt and won't open.

[mcupito]

Thanks for your response. I've exhausted every option that comes to my mind (I am no expert). I can open the databases as is and they all work fine for me, however not for a specific group of people. I made a copy of the backend and placed it in their folder, and it was working, however that defeats the purpose of the database, as all of the records need to be in 1 backend database.

I've refreshed the file paths in the linked table manager. Still receiving the same error. I mean I don't see how the backend could be corrupt if it works for me and a handful of other users.

Let me know what you think. Thanks.

[BikeToWork]

You're using the full UNC path for all db users? Is it possible that it is a drive mapping issue? This could be the case if you use a mapped drive as the path in the linked table manager and some users have different drive mappings.

[NeoPa]

The first test is to go to a pc of one of your problem users, logged on as that user, and see if you can even see the BE file in Windows Explorer (where files are managed).

If the file's there see if it can be opened in Access. I doubt it will pass both of these tests. If not then you may need to speak to your network people in IT.

Let us know what you find.

[ADezii]

From the problematic PCs, DELETE all of the Table Links and manually ReLink the Tables. Is this feasible given your scenario?

[NeoPa]

Be careful of relinking from different PCs. If the FE is supposed to be a standard one then it should work from any PC. If it doesn't then relinking from a different PC only moves the lump in the carpet.

On the other hand, it is an alternative way of determining where the problem lies as long as you determine the results in that light.

[mcupito]

I've gone to the non-functioning user's PC and logged on. If I store a copy of the BE in the same folder, it works fine, however if the BE is not there then I receive the error.

I am weary about deleting the table links from their PC's because sometimes I can't open it and other times I can.

As far as Network/IT within my company, all users have full access rights to the folders in which these databases belong. I thought that was the issue to begin with, however, upon further investigation that isn't the case.

I will attempt the deletion and re-linking of tables from the end users PC and give an update.

[mcupito]

On one user's PC, when I opened the BE folder it was not there, and the other user it was. Both gave the same FE error though - "Cannot find file."

When I tried to access the BE file from the user whose it did show up for, it also threw the error "Cannot find db"

[NeoPa]

So, on at least one PC, you could find the BE file in the correct relative network position, yet you were unable to access this via your Front End? is that right?

It may be the time to share what that position is. Name and folder exactly how it's specified in the link if you can.

Another test, from that same PC, would be to see if you can open the BE file directly. IE. From File | Open rather than by opening the FE and trying to access it as a BE.

[mcupito]

Sure, NeoPa.

I had separate folders created on a network drive. I placed each database in a separate folder, and those specific users who were to be using that db were granted access. I checked, they all have full access.

All of the FE dbs are linked in the linked table manager to the BE, which is in a folder of it's own, and everyone also has access to that.

To answer your first question, yes. The BE was there on one computer, however I was unable to access it via their FE.

Are you suggesting copy the BE to their desktop or something of similar fashion?

[NeoPa]

Are you suggesting copy the BE to their desktop or something of similar fashion?

No. Indeed not.

I'm asking you to specify clearly and accurately exactly where the file is. The name and the folder please - exactly as you have in the linked table. If a drive letter is used then please include also the network resource in UNC format (\\Server\Share ) that the letter refers to. This is important because the way you describe what you're dealing with makes little sense to me. You say various things which don't appear to me to be consistent. This isn't uncommon when people are dealing with things that they don't fully comprehend - such as when things aren't working and they need help. Once I understand what you're actually dealing with I will be in a better position to help.

I'm also still interested in hearing the results of the test I suggested in paragraph three of my previous post. I'm not sure if that's what your question (quoted above) was about. I'm not sure how I can explain that more clearly. Try like this :
Open Access.
Open the BE file directly.

[mcupito]

NeoPa, sorry for the confusion. It says the file path cannot be found. The only other solution to prove your test would to be to copy it to the desktop. On some of the person's computers it works, and I can open it, but not all.

The file path is defined as: Unde a folder titled Sub Billing M:\SubBilling BackEnd\NameofD atabase.mdb

[Rabbit]

Try using the full UNC path as BikeToWork suggested in the second post. You should try to avoid using relative paths when possible.

[mcupito]

Can you elaborate on what you mean as "full UNC path" ?