Dear all
I'm totally lost and confused and need some help.
I send a db out once a month to over 200 users (it has to be a local copy). Because of the size of the file (and that outlook will not send .mdb files as attachments), I have to zip it up.
If the user doesn't unzip the file and he/she launches it directly from the zip file, they get the following error:-
"The database 'xxx' is read-only.
You wont be able to save changes made to data or object definitions in this database"
I've done some research and this is error number 8400
What I want to happen is this:-
If.... database is opened as read only
Then.... give a message "Please detach database from zip file before opening" and then quit
Else.... run the autoexec macro
I've tried numerous permutations of error trapping but I can't for the life of me get it to work. Probably because this is my first attempt at error trapping!
Any help and guidance would be greatly appreciated
Cheers
p.s. Using MS Access 2003
I'm totally lost and confused and need some help.
I send a db out once a month to over 200 users (it has to be a local copy). Because of the size of the file (and that outlook will not send .mdb files as attachments), I have to zip it up.
If the user doesn't unzip the file and he/she launches it directly from the zip file, they get the following error:-
"The database 'xxx' is read-only.
You wont be able to save changes made to data or object definitions in this database"
I've done some research and this is error number 8400
What I want to happen is this:-
If.... database is opened as read only
Then.... give a message "Please detach database from zip file before opening" and then quit
Else.... run the autoexec macro
I've tried numerous permutations of error trapping but I can't for the life of me get it to work. Probably because this is my first attempt at error trapping!
Any help and guidance would be greatly appreciated
Cheers
p.s. Using MS Access 2003