Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Access Database with VBA Keith Excel Discussion (Misc queries) 1 June 1st 05 07:18 PM
Open Access Database under and Excel window using a Macro BMSpell Excel Worksheet Functions 1 January 8th 05 05:32 PM
Can't re-open Access database from Excel VBA Helge V. Larsen[_3_] Excel Programming 0 November 4th 04 09:03 AM
checking if an access database is open from excel macro Keyur Excel Programming 0 April 16th 04 04:03 PM
Open Ms Access database with excel macro Sani Excel Programming 2 November 19th 03 06:06 AM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"