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
Keith McElroyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What error are you getting?
Keith McElroyAuthor Commented:
The Microsoft Access database engine cannot open
or write to the file ‘C:\Users\myname\py_reporter04012016.mdb. It
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
Keith McElroyAuthor Commented:
The Report Designer tool is accessed via Citrix.
Jeffrey CoachmanMIS LiasonCommented:
Did this Proprietary Report Tool ever work?
Is this an off-the shelf system, ...or was it developed in-house?
Is this an issue for all users?
In any event, ...try contacting the makers of this tool for help...

Not sure what the ultimate issue is,...but most reporting tools do not make the leap and actually have the need to "Create" MDB files.
What typically happens is that these tools will link to the Access "Data" (tables), then make there own reports from that data.

In any event, ...a lot of times your error means that the "creator" (your proprietary tool?), ...may not have the appropriate permissions on the drive (or user's folder) to create files.
(or the Path is invalid)
So check these things also...

FWIW, ...code like this (in Access VBA) works fine to Create new Access database:

Dim wrkspc      As Workspace
Dim dbs         As Database
Dim strFileName As String

   Set wrkspc = DBEngine.Workspaces(0)

   strFileName = "c:\YourFolder\NewAccessMDB.mdb"

   Set dbs = wrkspc.CreateDatabase(strFileName, dbLangGeneral)

Open in new window



JeffCoachman

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.