Error after uploading DB to shared drive

[mmmk]

I recently uploaded my database to a shared drive on the server. Once I had the files uploaded, I went to linked table manager and set up the file pathes. I set the path up as "z:\....dbname_be.mdb" I know this is wrong but now that it is set I cant change it. When I select the tables and click OK, I get the message, " Application-defined or object-defined error". when I try to open a form or report in the db I get the message, " There was an error executing command". Thanks for any suggestions.

 

[Jeanette Cunningham]

You can use the linked table manager to change the path to the tables.
Alternatively you can just deleted the linked tables from each front end and use the linked table manager to link to the backend.
For a shared backend on a network, use My Network Places instead of Explorer to link each frontend to the shared backedn.
Only the backend is stored on the server, every user needs a copy of the front end on their desktop computer.

 

[ghudson]

IMO: I use the UNC \\server\partition\directory\backend.mdb when linking tables to avoid mixed user drive letter mapping problems.

 

[mmmk]

When i try to change the path using the linked table manager i get the error: "application defined or object defined error". How do i deleted the linked tables from each front end to relink them to the correct file path using the servername\\partition\...

 

[DCrake]

Have you tried looking at your references to see if you have any missing yet?

 

[mmmk]

Have you tried looking at your references to see if you have any missing yet?

Could you explain this? Im not sure what you mean.

 

[mmmk]

new problem, somehow I do not have administrator permission on my own db. When I go into user and group permisssions, it says the current user is Admin, but when i try to set Administer DB permissions an error message pops up saying I dont have permission to change permissions.

 

[mmmk]

any ideas?

 

[pegsus]

Can you tell us which version of Access are you using?
It seems like you are using earlier version of access if you are working with mdb. If you are using Access 2007, you should convert your file to the new format accdb.

Also, it seems like the problem might be your Access setting (I recall having this problem before as well). Is the macro enabled?

http://office.microsoft.com/en-us/h...ros-in-office-documents-HA010031071.aspx#BM11

Let us know.

 

[mmmk]

i am using access 2003. Do you have any suggestions on how to get back administer permissions on my db?

 

[pegsus]

I think we need to take a step back, so why are you trying to change the permission?

What happened to linking your FE to you BE on the shared drive?

Some1 else might be able to better assist you with this.