468,720 Members | 1,572 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,720 developers. It's quick & easy.

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 1064
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
1 post views Thread by CARIGAR | last post: by
9 posts views Thread by bryonone | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.