Access file closes when program ends...why?

[manontheedge]

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.

[Dököll]

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

[manontheedge]

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.

[Dököll]

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...