A
AlanP
Just thought I'd drop a note to the Group on a solution I found to Access VB
routines being denied authority to change / update folders.
Step: Assuming you have a Database of the F Drive in folder "My Data"
called Database Name.mdb"
1 Create a Shortcut to MSAccess something like "C:\Program
Files\Microsoft Office\Office10\MSACCESS.EXE"
Note: The Office folder will change with versions, so you need to go and
find it! (use the browse feature offered by the shortcut wizard)
2) Change the name of the Shortcut to "Database Name"
3) Click Finish
4) Right Click the created shortcut icon
5) Select Properties
6) Put the Target within double quotes
7) Add a single space, then another double quote then add the
pathname+filename to the database e.g. "F:\My data\Database Name.mdb"
8) Click the Advances tab
9) check the box "Run as administrator"
10 Click OK and on the next screen click Apply.
Your Database now will have Full Administrator Privileges and all VB Scripts
should now have the authority to modify files & folders.
You can then place the shortcut (or copies of it) wherever it pleases you.
Note: There is a downside to this! With User Account Control on, you will
get the warning message before you will be allowed to run it unless you have
UAC switched off or just the Warning Message switched off.
routines being denied authority to change / update folders.
Step: Assuming you have a Database of the F Drive in folder "My Data"
called Database Name.mdb"
1 Create a Shortcut to MSAccess something like "C:\Program
Files\Microsoft Office\Office10\MSACCESS.EXE"
Note: The Office folder will change with versions, so you need to go and
find it! (use the browse feature offered by the shortcut wizard)
2) Change the name of the Shortcut to "Database Name"
3) Click Finish
4) Right Click the created shortcut icon
5) Select Properties
6) Put the Target within double quotes
7) Add a single space, then another double quote then add the
pathname+filename to the database e.g. "F:\My data\Database Name.mdb"
8) Click the Advances tab
9) check the box "Run as administrator"
10 Click OK and on the next screen click Apply.
Your Database now will have Full Administrator Privileges and all VB Scripts
should now have the authority to modify files & folders.
You can then place the shortcut (or copies of it) wherever it pleases you.
Note: There is a downside to this! With User Account Control on, you will
get the warning message before you will be allowed to run it unless you have
UAC switched off or just the Warning Message switched off.