exclusive access

[blackcat]

i am getting the message ' you do not have exclusvie access' even though
nobody else is using the database, in fact when i look at the .ldb file i am
the one locking it, hense i cannot make any amendments. it wont allow me to
delete the .ldb file or rename or repair the .mdb file. i've rebooted several
times but still no joy. any suggestions please

 

[Jerry Whittle]

Firs thing is to make sure that you have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

Then try opening up the database with the following in a shortcut. Make sure
that the path, version of Office, and database name are right:

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /excl

You can also open up Access by itself; go to File, Open; select your
database in the Open dialog box; then go to the lower right of the dialog box
and change Open to Exclusive.

 

[blackcat]

i have full privileges to this folder but it still will not allow me to
delete the .ldb file and therefore i cannot make changes to the .mdb file. i
need a way of getting rid of the .ldb lock file, even opening the database as
you suggested it will not allow me to make changes because of the lock file.

 

[Todos Menos [MSFT]]

Acess MDB is unreliabe

you should move to a real database like SQL Server

MDB is too unreliable for real world use.. and it has been obsolete
for a decade

 

[Todos Menos [MSFT]]

you need to reboot the FILE SERVER not your desktop

but for real-- MDB sucks move to SQL Server

 

[Tony Toews [MVP]]

Acess MDB is unreliabe

you should move to a real database like SQL Server

MDB is too unreliable for real world use.. and it has been obsolete
for a decade

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Todos Menos [MSFT]]

note that tony is neither

MOST
VALUABLE
or a
PROFESSIONAL


anyone with a clue would have started using SQL Server a decade ago;
it is a completely superior platform in all regards-- with no
negatives

only a retard that can't learn a real database would ever use Access
MDB
I mean get real-- move to ADP or real VB-- either way, Access MDB is
dead and it has been for a decade