Opening database error msg

  • 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.
 
Hi George,

I have some suggestions for this issue:

1. Copy and paste the database file to some other folder 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 concerns or
questions.



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]>
|
| 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