Can't find the database file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help! I've been spending days trying to figure out this problem.

Have a db called abctest which has been just updated. The file is located
on a main PC and the folder is shared. Copied over the .mde shortcut to
other PCs within the workgroup. When logging onto a PC with admin rights the
application opens fine. When logging onto the PC with limited permission and
open the DB, receive the following message: "Can't find the database file
'C:\abctest\abctest.mde'."

All PCs are running Windows XP Pro. Here is the curious part. If I put
the old .mde shortcut back, you can access the db with admin or limited
rights. It's just occurred that you can't with limited rights from an
upgrade.

I've checked paths to ensure they are correct. I've checked sharing
permissions for accuracy. Any thoughts?
 
Gwynn said:
Help! I've been spending days trying to figure out this problem.

Have a db called abctest which has been just updated. The file is located
on a main PC and the folder is shared. Copied over the .mde shortcut to
other PCs within the workgroup. When logging onto a PC with admin rights
the
application opens fine. When logging onto the PC with limited permission
and
open the DB, receive the following message: "Can't find the database file
'C:\abctest\abctest.mde'."
Click to expand...

You said the mde was copied to a share. But your message indicates that it
is looking for abctest.mde on C: - i.e. the local hard drive. You need to
modify the shortcut on the other PCs so that it points to the mde in its new
location.

By the way, you should actually split the mdb and put just the backend on
the share. Each PC should have its own copy of the frontend (in which case
the shortcut would not need to be changed).
 
Correct, the data is located on drive H: (Main PC). The mde is copied to
each of the other PCs. When logged on with admin rights the application
works perfectly. When logged on with limited rights the application won't
even load. I have confirmed that the shortcut is properly set.

The frustrating part is when the older version is put back the application
works fine no matter what user account is being utilized. Add to the fact
that we've done 3 updates in the past 6 months and have had no such issues.
 
Users do not have sufficient permissions on the c:\abctest folder. Check
their windows permissions for this folder; you may have to reset the
permissions on the mde as well.
 
HOLA ESTE ES UN MENSAGE DE PRUEBA
Joan Wild said:
You said the mde was copied to a share. But your message indicates that
it is looking for abctest.mde on C: - i.e. the local hard drive. You need
to modify the shortcut on the other PCs so that it points to the mde in
its new location.

By the way, you should actually split the mdb and put just the backend on
the share. Each PC should have its own copy of the frontend (in which
case the shortcut would not need to be changed).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wise to set up user level security for a multi FE MDB ?? 9
Any advantage to using MDE over groups/passwords/hide db window/allowbypasskey? 1
Access, shares, med, read only. 14
Accessing a database on a server 4
Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
copies of an Access database does not include latest data - Vista? 1
Database Locked 2
Record Locking 2

Back
Top