G
Greg Bond
I used a script you posted for opening an Access db and lowering the security
(below). It works just fine, however now my database will open ONLY when
using the script. Double click the shortcut and a very brief hourglass
appears then disappears and nothing else happens. Same thing when double
clicking the db itself. I saved the script as a vbs file and now when I
double click the file it will run and open the database (with lowered
security) just fine.
Any idea why? Or better yet, how to undo whatever's been done?
Thanks much.
--Greg Bond
~~~~~~the script ~~~~~~
dim o
set o=createobject ("Access.Application")
o.runcommand 10
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "\\dataserver\Admission Status Report\Admission Status
Report (new-colleague id-finished).mdb"
o.usercontrol=true
set o=nothing
~~~~~end the script~~~~~~~
(below). It works just fine, however now my database will open ONLY when
using the script. Double click the shortcut and a very brief hourglass
appears then disappears and nothing else happens. Same thing when double
clicking the db itself. I saved the script as a vbs file and now when I
double click the file it will run and open the database (with lowered
security) just fine.
Any idea why? Or better yet, how to undo whatever's been done?
Thanks much.
--Greg Bond
~~~~~~the script ~~~~~~
dim o
set o=createobject ("Access.Application")
o.runcommand 10
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "\\dataserver\Admission Status Report\Admission Status
Report (new-colleague id-finished).mdb"
o.usercontrol=true
set o=nothing
~~~~~end the script~~~~~~~