ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I open Access database from Excel (https://www.excelbanter.com/excel-programming/318940-how-do-i-open-access-database-excel.html)

Nico

How do I open Access database from Excel
 
I found example code that opens the database, but it is automatically closed
directly after that.
I just want to open an Access database (that starts a form as startup when
you open it) from an Excel form.
But the database must be still open, even when the program code from excel
is finished or Excel is closed.

Thanks

Tom Ogilvy

How do I open Access database from Excel
 
Look in help at the usercontrol property of the application (Access) object.

I believe if you set this to true, it will stay open.

--
Regards,
Tom Ogilvy

"Nico" wrote in message
...
I found example code that opens the database, but it is automatically

closed
directly after that.
I just want to open an Access database (that starts a form as startup when
you open it) from an Excel form.
But the database must be still open, even when the program code from excel
is finished or Excel is closed.

Thanks





All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com