471,109 Members | 1,478 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Access file closes when program ends...why?

175 100+
I'm having a problem when I work with Access using VB6. I don't have a problem controlling Access, but I want the Access file to stay open when the program ends...but it always closes itself, and I don't know why. I stepped through my program, and it stays open literally until the second the program stops running. How can I get it to stay open and visible on the desktop...is there some trick to it?

it's really strange, I know I'm opening it correctly because I do other things with the file, and I've never had this problem when working with Excel or Powerpoint.
May 17 '07 #1
3 1122
Dököll
2,364 Expert 2GB
I'm having a problem when I work with Access using VB6. I don't have a problem controlling Access, but I want the Access file to stay open when the program ends...but it always closes itself, and I don't know why. I stepped through my program, and it stays open literally until the second the program stops running. How can I get it to stay open and visible on the desktop...is there some trick to it?

it's really strange, I know I'm opening it correctly because I do other things with the file, and I've never had this problem when working with Excel or Powerpoint.
Greetings and salutations, manontheedge!

Access is a whole different animal. When VB interacts with your Access back-end, that MS Access file (your Access database) must be closed. What you are seeing is completely normal. Additional calls to your back-end will reopen your MS Access database.

Have a good week-end!

Dököll
May 19 '07 #2
manontheedge
175 100+
I actually discovered a temporary solution. If I open a specific table before the program ends, then that Access file will stay open when the program ends, with that table being open. The only problem that presents is that once that table is closed the whole file is closed. Though, editing, viewing, whatever else can be done.
May 21 '07 #3
Dököll
2,364 Expert 2GB
I actually discovered a temporary solution. If I open a specific table before the program ends, then that Access file will stay open when the program ends, with that table being open. The only problem that presents is that once that table is closed the whole file is closed. Though, editing, viewing, whatever else can be done.
Hey thanks for sharing, I hadn't tried that...
May 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Kenneth Courville | 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.