Closing a database from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to close a database from excel, it won't let me open the database
until I hit the reset button on the debug toolbar. This is the statment I am
using to close it.

Access.Application.CloseCurrentDatabase

What am I doing wrong?
 
Junior

It could be that you have some database objects still open that's screwing
it up. Make sure you close all the tables, queries, etc. before you close
the database.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Providing user message when RED X clicked & properly closing application. 2
Macros problem closing another file 0
close excel; leave access open 1
Access How Current page of a form Read Only 2
Reading From & Writing To an Excel Database 4
Operation is not allowed when the object is closed 1
Excel VBA - Problem with Closing Print Preview 0
ADO retrieval from close workbook-data type issue 2

Back
Top