N J
asked on
MS Access database file protection
Hi,
I have an issue I would like someone to help me to solve it.
I was searching how can I protect my Access Database file not to be used on another PC, so I find a way to create a dummy file and to call this file the first thing in my welcome form page.
I did face 2 errors after running it attached are the screenshots for both of them.
And the VBA code you can see it below:
Application.FollowHyperlin
For the Security notice I did try many solutions to turn it off, but non of them did work.
And for the run time error I have no idea from where most probably from the VBA code.
Thanks for your help,
security-notice.png
run-time-error.png
I have an issue I would like someone to help me to solve it.
I was searching how can I protect my Access Database file not to be used on another PC, so I find a way to create a dummy file and to call this file the first thing in my welcome form page.
I did face 2 errors after running it attached are the screenshots for both of them.
And the VBA code you can see it below:
Application.FollowHyperlin
For the Security notice I did try many solutions to turn it off, but non of them did work.
And for the run time error I have no idea from where most probably from the VBA code.
Thanks for your help,
security-notice.png
run-time-error.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jason clark
The file may not exist at the specified location, then this type of error. Discussed well here: https://stackoverflow.com/questions/20933433/how-to-deal-with-error-490
ASKER
thank gustav the script you provide did the check i need