How to handle network interruptions

[Chad Access]

Hello,



I have the "your network access has been interrupted" issue occurring on our network, but I have no control over the network.

My question is how I can handle the situation when it happens. Specifically, I would like Access to restart itself when it encounters this type of error. After all, that is what is required to recover from the issue anyways.

Any help would be greatly appreciated!

Chad

[aytee111]

Take lots of backups! I worked at a company like that and had automated backups three times a day. This type of problem so easily corrupts the database and makes it an "unrecognizable" file.

[ranman256]

no. if you have code in the app, then the app closes, then so does the code.

Just click the close button (top right corner)
then start access, your db is #1 in the prev list. (or a shortcut)
thats like 2 to 3 clicks.

[Chad Access]

no. if you have code in the app, then the app closes, then so does the code.

Just click the close button (top right corner)
then start access, your db is #1 in the prev list. (or a shortcut)
thats like 2 to 3 clicks.

I am not sure I understand what you are suggesting. Are you saying there is no way to capture this event using form events / vba to tell Access to restart?

I know we can manually restart it, but that is not what I'm after. Thanks.

[CJ_London]

only way I can think you might be able to get it to work is before each and every insert/update/delete it to try to update a dummy table with a value. If it updates then go ahead and do your transaction otherwise abort. - but if the network interrupts during your transaction you will risk corruption.

Would be better to move the backend to sql server (or express which is free) which manages interruptions much better.

Also check out the begintrans and committrans vba functions, they may help.