User Access Error

[clloftus]

I have a DB that I created in my home directory. I moved it to a location so that other users can access. However, since I moved it, no one can access it, they get errors that the DB is already in use or they do not have the permissions. The permissions on the directory is read/write/execute for everyone. I can still access it.

Not sure if it matters, but I split the DB prior to moving. The _be file is still in my home directory. When I moved it to the same location, then I coudln't access the DB and it created a locked file; so I moved it back and it works fine for me; but no one else.

I am useing Access 2007.

Any assistance you can provide is greatly appreciated.

 

[MSAccessRookie]

I have a DB that I created in my home directory. I moved it to a location so that other users can access. However, since I moved it, no one can access it, they get errors that the DB is already in use or they do not have the permissions. The permissions on the directory is read/write/execute for everyone. I can still access it.

Not sure if it matters, but I split the DB prior to moving. The _be file is still in my home directory. When I moved it to the same location, then I coudln't access the DB and it created a locked file; so I moved it back and it works fine for me; but no one else.

I am useing Access 2007.

Any assistance you can provide is greatly appreciated.

Not knowing anything about your network, I can only provide general advice. You will need to determine what (if any of it) applies in your situation.

Problem #1 - Your users cannot access the Back End in your work area.

Some System Admins consider personal work areas to be private space. As such other users are not allowed to access information there.
​

• Allowing access to the other users could resolve this (NOT A GOOD IDEA)
• Moving the Back End to a more Public area is a better idea, which leads us to

Problem #2 - When you move the Back End you cannot access it.

• Verify that you have Access to the Public Area
• Verify that the Tables have been re-linked to the the Back End Database that is in the Public Area

There are probably other things to consider, but this could be a good start

 

[clloftus]

Thank you for your response. How do I relink the tables to the database? This is the first time I've ever done this, so I apologize if it seems I should already know this answer.

I really do appreciate your assistance.

 

[MSAccessRookie]

Thank you for your response. How do I relink the tables to the database? This is the first time I've ever done this, so I apologize if it seems I should already know this answer.

I really do appreciate your assistance.

Open up the database window and show the linked Tables. Right clicking on any table provides a menu of choices that includes "Linked Table Manager". This will open up a Wizard that is fairly easy to follow. Get back with any questions.

 

[clloftus]

Thank you for your response. I'm not having any luck with this. I right clicked on each of the tables, but I do not see "Linked Table Management". I have the book Using Microsoft Office Access 2007 by Roger Jennings; and in the book it states to open each table in sequence and navigate to the last record to ensure the tables are updatable.

I did that and all tables are updatabale; but when I go back to the .accdb file I continue to get the error "Could not find the filename_be.aacdb file".

The _be.aacdb file resides in a different folder as the .aacdb file, but they are on the same share drive.

Thank you again for your time.

 

[MSAccessRookie]

The original information that I provided is valid for MS Access 2000-2003. I do not have a copy of MS Access 2007 or 2010 available, so I am unable to provide an alternative explanation. Perhaps another of the Forum experts can walk you through relinking your Tables.

 

[Kiwiman]

Howzit

I use Access 2010 - I have just tried Rookies suggestion and it does show linked table manager in the list of options when you rght click a table. This is of course on the basis that you have at least one linked table. If you have a db with no linked tables, then this option does show but is disabled.

The manager itself can be found in the Exteranl Data tab. This will be disabled if there are no linked tables

 

[clloftus]

Ok, so I figured out that I was selecting the tables in the wrong .aacdb file; I was selecting them in the _be.aacdb file, that's why I couldn't see the Link Table Management". So I have that, when I do the link, do I link each table to the _be file?

This is so confusing. Thank you again for your assistance.

 

[clloftus]

Thank you everyone for your assistance; I got it to work. I had to make a copy of the _be.aacdb file and place it in the new directory. Otherwise, it wouldn't work. After I copied it, I was able to make the change in the Link Table Manager. Then I deleted the _be.aacdb from the original location. It worked.

One last question though, if I want several users to access the db at the same time, how do I set this up? Right now if more than one person tries to access, it doesn't allow a second person to open the .aacdb file?

Again, a million thank you's for your assistance.

 

[Kiwiman]

Howzit

Each user will need to have their own copy of the front end on their desktop. Then they can go mad playing with it. You may want to do a search for Front End Updater so that any changes you make to the master will be picked up by the users.

 

[clloftus]

Wow, it's that simple; they just make a copy of the .aacdb and place it on their desktop and they are good to go. Who would have thought

Thank you.

 

[clloftus]

Not as simple; users are getting permission errors. Permissions set on both directories are read/write/execute. Any other suggestions?

Again, THANK YOU !

 

[Kiwiman]

Howzit

Get the users to create a new txt file in the back end location to determine if it is a permissions issue or not. If they can cereate one then one can assume that it is not a permissions issue.

Did they get the correct copy of the front end when the took a copy?

 

[clloftus]

Ok, I will have them try to create a document and put it in there. The .aacdb is the only file there, so they copied the correct one. I will let you know if it is a permissions issue or what ... standby.

Thank you,

 

[MSAccessRookie]

I am glad that Kiwiman was able to get you straightened out. The only thing that I might want to add is that copying a file from one directory to another does not always use all of the permissions that are required to create one there. I await the results of your tests.

 

[clloftus]

I don't think it is a permissions issue on the directory, because my co-worker was able to open a document in that directory, make a change and save.

The directory that I had her do this was the directory that the _be.aacdb file exists. She copied the .aacdb from another directory onto her desktop.

Again, any assistance is greatly appreciated.

Thank you,