MSAccess 2003 File in Network - Exclusive Open

[ennrike]

Hello,

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 urgent?

 

[GinaWhipp]

That indicates the database is not split and used among multiple Users. A big no-no, see...

Their front ends should be installed on their local drive and the back-end on a network drive. http://www.members.shaw.ca/AlbertKallal/Articles/split/
http://allenbrowne.com/ser-01.html

You may also want to take a look at MVP Tom Wickerath's article...
http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm

To handle the update of multiple front ends see...
http://www.autofeupdater.com/

If each user needs Access you can install the Runtime…
Access 2007
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
Access 2010
http://www.microsoft.com/downloads/...cd-5250-4df6-bfd1-6ced700a6715&displaylang=en

 

[ennrike]

Thanks for the info Gina,

But I am using a C# application that uses that database, but occasionally I need to enter to the file and made modifications like adding a new column to a certain table, actually I am suppose to be the only person authorized to do that, however, someone may opened it accidentally.

I just want to close the other file and made the modification, I am planning to migrate later on to SQL Server 2008 ...

Thanks,

 

[GinaWhipp]

Oh, well then yep that is a problem...

Perhas you can use this...

Have a look at the LDBView utility from Microsoft...
http://support.microsoft.com/kb/176670

...on the .LDB file to see which Users are in the file and then shoot them a message you want to make a change.