Close a database

[Harb9]

When I attemp to delete a quiry, I get a message that says that the database
is still open. Do I have to close it at this time?

 

[a a r o n . k e m p f]

Jet is too buggy-- what you need to do is move to a more reliable
database like SQL Server

Honestly.

Any error message like this-- means that you're pushing jet past it's
practical limit, and you should just move to SQL Server

 

[Tony Toews [MVP]]

When I attemp to delete a quiry, I get a message that says that the database
is still open.

What is the exact message? Try opening the database and immediately
deleting the query. Also it's possible that Access is still running
although it's hidden. Run Task Manager and see if msaccess.exe is
still in the process list. If so end it.

Please ignore Aaron's reply.

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/

 

[Larry Linson]

When I attemp to delete a quiry, I get a message
that says that the database is still open. Do I have
to close it at this time?

What version of Access are you using?

I understand that you have created a query, that it is in the Queries tab of
the Database window, and you want to eliminate it from your Database. Is
this correct?

How are you trying to delete it? Are you just clicking to highlight it and
pressing the Delete key?

What is the exact error message that you are receiving -- number and text?

Have you Cosed, and Opened the Database with the Shift key pressed, so that
no VBA code nor Macros will have been executed, and tried to delete the
Query? Try that _first_.

Mr. Kempf's comments are (1) inaccurate... nothing about what you describe
is due to the circumstances he quotes, and (2) although, in many instances,
SQL Server can be a useful back-end data store for an Access client,
following his advice would more than likely cost you quite a lot of time and
effort, and have no effect at all on the problem you have encountered.

Larry Linson
Microsoft Office Access MVP

 

[GenlAccess]

Jet is <and a lot of nonsense>

Engage brain before fingering keyboard, kempf.

Gen'l Access

 

[a a r o n . k e m p f]

SQL Server is actually easier to develop with than Jet.
So sorry that you're stuck with an obsolete database.

Maybe you should listen to knowledgeable people, instead of gray-
haired ****tards.

-Aaron