🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Export failing and deleting access database

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

I have a job that will export a report to a .MDB

I was training a new user on how to run specific reports. When they clicked "Run exports" we received an error in the export results "CreateDataSource Failed"

 

When I went back to my computer the export ran fine.
I created some dummy export jobs to see if monarchy would export to excel and that worked fine on the new users computer, but anytime I would export to any type of access database it would fail and delete the access database in the folder.

 

The user can open the access databases and edit them just fine.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "Altair Forum User"
    Altair Employee
    OP
    Updated by Altair Forum User

    My guess is user's rights.  To test this, have the user go to the export location via File Explorer and see if they are able to create a new folder.  If not, then security is the issue.  If a folder can be created, then I would involve someone from technical support.