It's Open Exclusively

[Guest]

I have a 2 computer network. The BE resides on one computer and each computer
has a FE. The BE is opened shared as are both FE. In Options only Admins
and Users with full rights, except "Open Exclusively" is not checked.
One of two users did something that made the remote computer need a repair.
After I repaired and compacted it, I get the message, on the remote computer
that the db is "Opened Exclusively by another user". I checked the
propertoes and Options on the BE and everything is as it was. I checked the
FE on the remote computer and all options & Properties are the same. If I
shutdown the db on the main computer I still get the same message on the
remote computer. The db runs fine on the main computer.
Can any one help?
Thanks in advance

 

[TC]

I'm not sure that I understand your description.

Exactly what happens when you double-click the BE directly?

Exactly what do you have to do, to get the error in question?

TC

 

[Guest]

On the Remote Computer,to get the error I go to Linked Table Manager and try
to link the tables(BE) with the Forms, Queries and Reports(FE). If I Double
Click on the Tables (BE) from the Remote Computer I get the same error also

 

[TC]

It sounds to me like the BE file might be corrupt.

Focus on the BE for the moment. Do not use the FE for these steps.

1. Close all databases & Access itself;
2. See if the BE has a corresponding .LDB file n the same folder - if
so, delete that file;
3. Check that all relevant users have full
open/read/write/create/delete permissions to the folder containing the
BE;
4. Double-click the BE directly.

If you still get the same error:

1. Create a new blank database;
2. Import all the objects from the BE database;
3. See if you can browse the content of the (imported) objects in the
new database.
4. If you /can/, then, RENAME the old BE (don't delete it!), and
replace it with the new db, then try again.

If all that fails, restore the BE from your last backup. (You do take
backups, yes?)

If you don't have a backup, send a copy of the bad BE to an Access data
recovery service to see what they can do with it.

HTH,
TC

 

[Guest]

Here it goesL
1. From the local computer could open and manipulate data.
2. From the remote computer got error message that it could not find the
database.

 

[TC]

Ron, I can't help you unless you follow each instruction & tell me what
happened.

TC

 

[TC]

Are you saying this:

- you followed the first steps 1. to 4.;
- those all worked ok;
- then you tried to open the database from the remote PC by
double-clicking it;
- then you got a different error (to the one yo menioned before)?

Is that it? If so, what was that new error /exactly/ ?

You have to say these things explicitly. I can't look over your
shoulder, or guess what you're doing.

HTH,
TC

 

[Guest]

Sorry for the delay, its been a rough day.
1. Steps 1 - 4 performed on local computer satisfactorily.
2. Double clicked on the database, from the remote computer and got the
following error:
Microsoft access can't find the database file "\\(Path to
db)\KWR2KTables.mdb".
Make sure you entered the correct path and filename.
The computer opened Access without a database.

3. While Access was opened, without a database, I clicked OPEN, navigated
to the database, clicked Open again and got the following error:
Microsoft jet database engine cannot open the file"\\(Path to
db)\KWR2KTables.mdb".
It is already opened exclusively by another user or you need
permission to view its data.

I never touched the FE during these steps

 

[TC]

Sorry for the delay, its been a rough day.

Likewise. I've just clobbered my new laptop, & probably lost all the
work I've done on it for the past 3 weeks! :-((

1. Steps 1 - 4 performed on local computer satisfactorily.

So, you /can/ open the db if you double-click it directly from the
central PC, and you /do not/ get any errors when you do that. Right?

2. Double clicked on the database, from the remote computer and got the
following error:
Microsoft access can't find the database file "\\(Path to
db)\KWR2KTables.mdb".
Make sure you entered the correct path and filename.
The computer opened Access without a database.

If you can open it ok when you double-click it directly on the central
PC, but you /can't/ open it when you double-click it directly from the
remote PC, this suggests to me that there is something wrong with the
remote PC's abilty to see the files on the central PC. IOW, perhaps not
an Access error, at all.

I'm not sure what to suggest next. Does anyone else have any
suggestions?

TC

 

[Guest]

I have another db that is shared like the first one. Right now I have no
problem opening the second db on the remote computer.

Any ideas any other part of the access section of this forum I could go to?

I want to thank you for your help and please anyone else with ideas please
send them.

 

[Mikal via AccessMonster.com]

Do you suppose you could have a left over lock file on the backend database?
If so, deleting that might free things up.
Mike

 

[TC]

The only other thing that I can think of, is this. Presumeaby you are
starting these databases by means of a shortcut. Perhaps the shortcut
is wrong for the database that does not work. Try carefully & precisely
comparing the database pathfilename in the target, to the actual
pathfilename on disk.

HTH,
TC