Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a database from excel
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a database from excel
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. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "junior C" <junior wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Closing VB triggers closing Excel | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |