This is about using DTS to run a report in Microsoft Access... so it's not a SQL database that you would access in Enterprise Manager. I'm just using a DTS package as shown above. I have made sure that the MS Access database file permissions give access to Sql to no avail.
Thank you for this suggestion. It didn't work but I've got more information. From the job log, there are more details about why the procedure failed. It's a vbscript runtime error - permission denied on 'CreateObject' (see below): Any idea what to do about this? Thanks very much!
Error...
Do you mean close Enterprise Manager and then reopen it. Otherwise, how can I run package unless I do it from Enterprise Manager? I've tried using another database that is a mdb file with definetely no other users connected and the same problem occured. Could the issue be related to the fact...
I've been trying to use the following VB script as ActiveX DTS package to print a report in Access ADP. When I run this, I get an error "Microsoft Access can't open the database because it is missing or opened exclusively by another user." The path indicated for the db is from the same...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.