By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Database Close abmormally

P: 10
Hello all,

Is there a way to run a function that will prevent backend database corruption when user exit database abnormally.

I have hid all menus and title bar. STILL they are closing it.
Mar 1 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello all,

Is there a way to run a function that will prevent backend database corruption when user exit database abnormally.

I have hid all menus and title bar. STILL they are closing it.
The easiest thing to do is to create an invisible form that opens with the database and create a proper exit application procedure in the unload event of the form. Then no matter how the application is closed the unload procedure of the invisible form will run.

Mary
Mar 1 '07 #2

P: 10
[quote=mmccarthy]The easiest thing to do is to create an invisible form that opens with the database and create a proper exit application procedure in the unload event of the form. Then no matter how the application is closed the unload procedure of the invisible form will run.

Mary

Thanks a million.

One question on unload event "Application.Quit acQuitSaveAll" will save data and close all connection to the backend. Correct?

Once again Thanks a lot.
Mar 1 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534

Thanks a million.

One question on unload event "Application.Quit acQuitSaveAll" will save data and close all connection to the backend. Correct?

Once again Thanks a lot.
You're welcome and yes that code should take care of it.

Mary
Mar 1 '07 #4

Post your reply

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