Access database locked up

[i.sobha]

I have an ASP application which Queries to an Access Database.

From the front end(Asp page) a query was executed.The system got stuck

up as the access database was locked up.

Now the entire system is stuck up and I cannot go to any page in my
application.

Please suggest some methods to unlock the database.

The issue occured yesterday ,Still the database is locked.I can see
an .ldb of the database created

 

[Arvin Meyer [MVP]]

Try deleting the LDB file then compacting a copy of the database file. If
you cannot delete the LDB file, you'll need an administrator to kick
everyone out of the file. If that doesn't work, you may need to reboot to
release the filelock. Here's some general advice on corruption:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[dbahooker]

MDB should not be used by anyone.

Microsoft admits that it has been obsolete for 10 years



use SQL Server if you have an application that uses the internet at
all

downtime is not acceptable; real databases you won't need to bounce
the webserver in order to release a lock

 

[Tony Toews [MVP]]

A a r o n K e m p f wrote.

Microsoft admits that it has been obsolete for 10 years

Wrong.

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

 

[dbahooker]

I already posted the link, KID

argue with the FACTS

anyone using MDB in the year 2007 should be fired and then spit upon


Tony Toews should not be trusted; he believes that the only
appropriate use of Access is to use MDB / MDE files.

I mean.. that cry baby needs to lose the training wheels