asked on
Create mdb from report tool - error
Scenario: Using a Proprietary Report Tool that uses vb script as its internal macro language
Attempting to create an mdb file
Computer: 64 Bit Win 7
Issue: Error appears at point script creates mdb file
Works on 32 bit machines
Screenshot of err:
http://www.screencast.com/t/DeI3s8nSapWe
Screenshot of code:
http://www.screencast.com/t/LccpejavV
Attempting to create an mdb file
Computer: 64 Bit Win 7
Issue: Error appears at point script creates mdb file
Works on 32 bit machines
Screenshot of err:
http://www.screencast.com/t/DeI3s8nSapWe
Screenshot of code:
http://www.screencast.com/t/LccpejavV
Microsoft AccessVB Script
Last Comment
Scott McDaniel (EE MVE )
What error are you getting?
ASKER
The Microsoft Access database engine cannot open
or write to the file ‘C:\Users\myname\py_report
is already opened exclusively by another user, or you need permission
to vew and write its data
Src: Microsoft Access Database Engine
Line 25 Error: 0 Scode 8004005
or write to the file ‘C:\Users\myname\py_report
is already opened exclusively by another user, or you need permission
to vew and write its data
Src: Microsoft Access Database Engine
Line 25 Error: 0 Scode 8004005
ASKER
The Report Designer tool is accessed via Citrix.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Looks like the code is trying to create a table in the database. If so, then as Jeff indicates, this may be a permissions issue. Your user will need to have Read Write Create Destroy permissions on the folder hosting the database file.