471,075 Members | 737 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Opening MSAccess from VB.net 2003 VERY SLOW??

I need to enable users to run MSAccess 97 macros from my VB.Net 2003
application. Here is a code snippet:

Dim app As New Access.Application
app.OpenCurrentDatabase(MyMacroPath)
.......
.......
app.Quit(Access.AcQuitOption.acQuitSaveNone)
app = Nothing
GC.Collect()

It takes 1 to 2 minutes to execute the first line of code (Dim app as
new Access.Application)! However, if the VB.net application and
Access97 run simoultaniously (with Access having been opened directly
by the user, not by VB), no performance problems are experienced. Is
their anything I can do to speed up the Access automation?

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
Nov 21 '05 #1
0 861

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jawahar Rajan | last post: by
15 posts views Thread by (Pete Cresswell) | last post: by
3 posts views Thread by Giuseppe D'Elia | last post: by
4 posts views Thread by Annick Van Hoof | last post: by
10 posts views Thread by John | last post: by
2 posts views Thread by reidarT | last post: by
reply views Thread by bbrewder | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.