How do I open Access database from Excel

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

Guest

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
 
Look in help at the usercontrol property of the application (Access) object.

I believe if you set this to true, it will stay open.
 
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 How to Fix Damaged Excel File That Won't Open? 3
close excel; leave access open 1
Excel Unlink open excel files 2
Access Command to run access, open to specific form and specific record 1
Excell 2021 0
Open Excel workbook from Access 4
Access how to open existing database from another database using Access - VBA 0
Reading From & Writing To an Excel Database 4

Back
Top