Topics Search

Opened exclusively error on split database?

Opened exclusively error on split database?
Views: 35
I have a multi-user database. I've split it into a front-end and back-end. Distributed copies of the front end to each user.

However if I try to open, in any view, it comes up with the 'Opened exclusively by another user' error.
Sponsored Links:

More topics

 

Open the database exclusively

Preview
In Access 2003/XP/2000/97, I tried modifying some of the objects in my Access database and I received an error message stating that I needed to open the database exclusively. What does this mean and how do I open a database exclusively?
 

MSAccess 2003 File in Network - Exclusive Open

Preview
I have an access file in the shared folder in the intranet, some guy opened and I think he tried to design something, so that, the file is exclusively opened somewhere in the office, there are a lot of computers, so I don't know who is this guy, but the file is like that since yesterday. every time that I try to do a modification it shows a message:

"you don't have exclusively access to the database at this time ."

Is there any way to exclusively hard open the file as I need to design something and it is
 

Is it possible to check whether the current database is opened exclusively?

Preview
I'm happy if there is a property here instead raising an error and trapping it. Kindly share the solution whatever it is please
 

cannot opend db exclusively

Preview
I'm getting the following error when trying to open my database exclusively.

"You can't open 'db' for exclusive use because another user has the database open or because you do not have permissions to open exclusively."

I'm about 99.9% sure no one else has this database open and about 97.9% sure that my permissions haven't changed since last friday when I was able to open the database exclusively.

Does anyone have any idea why this would be happening?
 

Open the database exclusively in Access 2007

Preview
In Access 2007, I tried modifying some of the objects in my Access database and I received an error message stating that I needed to open the database exclusively. What does this mean and how do I open a database exclusively?
 

Back End Database Locking

Preview
Here is my situation. I have a split database with an ACCDE Fronte end and a ACCDB back end. Through the whole development process I have been able to access the database with no issues.

I sent a copy of the FE databases to the trainer so she could create training content. She also had no issues. Now we have been putting the FE onto users desktops and they keep getting error messages. The message they receive is below.

The Microsoft Office Access database engine cannot open or write to the file S:\.File location. It is already opened exclusively by another user, or you need permission to view and write its data.

What am I missing. Is this something that I can give permission to? I did nothing special with the trainer and it worked fine.
 

Back End Database Locking

Preview
I have a split database with an ACCDE Fronte end and a ACCDB back end. All users have access 2007. Through the whole development process I have been able to access the database with no issues. I sent a copy of the FE databases to the trainer so she could create training content. She also had no issues. Now we have been putting the FE onto users desktops and they keep getting error messages. The message they receive is below.

The Microsoft Office Access database engine cannot open or write to the file S:\.File location. It is already opened exclusively by another user, or you need permission to view and write its data.

What am I missing. Is this something that I can give permission to? I did nothing special with the trainer and it worked fine
 

update db connection

Preview
Just moved several access dbs to a new location. When I opened one of them, which contains queries, I cannot run them. I get an error message stating the Microsoft Access database engine cannot open or write to the file "x".

It is already opened exclusively by another user, or you need permission to view and write its data. I noticed the file path is pointing to the original location and not the new location.
 

Access 2007 Already opened exclusively by another user

Preview
When 2 or more people are trying to open a report they get " . . Access Database cannot open or write to the file. it is already opened exclusively by another user". The file is setup as "shared" and "read only".

I am using and ODBC engine. The act of opening the report does not create, modify or destroy any file. How do I set it up so 2 or more people can open the report? .
 

Howto trap " Cannot open the file"?

Preview
How can I trap the error "The Microsoft Database Engine cannot open the file 'MyDb.mdb'. It is already opened exclusively by another user, or you need permission to view its data".

I have an error handler in my routine, but it does not get called at all when this happens. Instead, I get a msgbox with the text shown above, which of course just hangs up everything until I click