Opening DB error

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi all,

all of a sudden when opening an A2K database by double-
clicking the file itself, I receive the following error
message: Microsoft can't find the database file
DB_PATH_AND_NAME. Make sure you entered the correct path
and name.

If I attempt to open it from with A2K by going thru File |
Open menu, I receive this error: The Microsoft Jet
database engine cannot open the following file
DB_PATH_AND_NAME. It is already opened exclusively by
another user, or you need permission to view this data.

I checked the folder and there is no LDB file present.

I recently made some change to the folder's permission. It
used to have FULL CONTROL to Authenticated Users group. I
changed to FULL CONTROL to Adminstrators and Users group.
However now I have changed it back and it still didn't
work.

Can anyone shed some light on this? TIA.
 
When you changed the folders permissions back did you tell it to propagate those
permissions to child objects in the folder? If you move the file to another folder can you
open it? Can you open other files?
 
Wayne,

thanks for your reply. Yes I did specify to propagate. I
have a few other files in the same folder. They can all be
opened by MS Word, WinZip, etc all right. A second mdb
file in the same folder has the same problem.

Any idea? TIA.

-----Original Message-----
When you changed the folders permissions back did you tell it to propagate those
permissions to child objects in the folder? If you move
Click to expand...
the file to another folder can you
 
Right off hand I would try giving Everyone full control just for testing purposes. If this
works, then it is a permission problem. Since you can open files, I'm guessing that you
are having trouble creating the lock file (database.ldb). It is created in the same folder
as the mdb file when you open the database. Is this a local folder or are you accessing it
across the network? If it is a network share, have you verified both the Share Permissions
AND the NTFS Permissions? Has a Deny permission been set? Deny permissions take precedence
over Allow permissions.
 
Hi George,

Wayne provided good suggestions to this question; I just want to let you
know that I have replied to your same post at:

From: "George" <[email protected]>
Subject: Opening database error msg
Date: Wed, 27 Aug 2003 05:59:15 -0700
Newsgroups: microsoft.public.access.modulesdaovba

*******
I have some suggestions for this issue:

1. Copy and paste the database file to some other folder you have full
control (full permissions) and then try to open it by double clicking it.

2. It is possible the database file is corrupt, we can try the methods to
recover it.

A. Try to import all objects into a new blank database. Here are the
detailed steps for your reference:

1) Create a new, blank database and call it: Test
2) Open this database and from the File menu option choose Get External
Data, then select Import.
3) Browse to your existing database that is causing the problem, highlight
it and click Import.
4) You should now see a small "database window" that displays all the
objects from your existing database. On each tab (tables, queries, forms,
etc.) there is a
Select All button - click on each tab and click this button.

5) If you have any custom tool/menu bars, click the "Options" button and in
the
bottom left corner you will see check boxes to allow the importing of these
items -
please make sure these are checked if needed.

6) Once all tabs are completed, and step #5 has been verified, click OK.

7) Once the import process has completed (assuming there were no errors)
you will
be in this new "Test" database. What is the result?

B. Try to use JetComp to recover it by referring to the following articles:

Q273956 ACC2000: Jet Compact Utility Available in Download Center
http://support.microsoft.com/support/kb/articles/q273/9/56.asp

Q209137 ACC2000: How to Repair a Damaged Database
http://support.microsoft.com/support/kb/articles/q209/1/37.asp

**********
Please feel free to reply to the threads if you have any


Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



--------------------
| Content-Class: urn:content-classes:message
| From: "George" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| Hi all,
|
| all of a sudden when opening an A2K database by double-
| clicking the file itself, I receive the following error
| message: Microsoft can't find the database file
| DB_PATH_AND_NAME. Make sure you entered the correct path
| and name.
|
| If I attempt to open it from with A2K by going thru File |
| Open menu, I receive this error: The Microsoft Jet
| database engine cannot open the following file
| DB_PATH_AND_NAME. It is already opened exclusively by
| another user, or you need permission to view this data.
|
| I checked the folder and there is no LDB file present.
|
| I recently made some change to the folder's permission. It
| used to have FULL CONTROL to Authenticated Users group. I
| changed to FULL CONTROL to Adminstrators and Users group.
| However now I have changed it back and it still didn't
| work.
|
| Can anyone shed some light on this? TIA.
|
|
 
Back
Top