Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS connection to Access app w/ workgroup security Expand / Collapse
Author
Message
Posted Monday, November 10, 2003 2:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 31, 2013 2:08 PM
Points: 23, Visits: 39
I need to export data from an Access 2000 (SP1) app which uses workgroup security. I open a new Access connection in DTS (SQL Server 2000 SP3a). No one is logged into the Access app.

I enter the file path and name, the login name and password, hit the OK button and get an error message stating:
"Error Source: Microsoft JET database engine.
Error Description: Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

Any suggestions?

thanks much

k2




Post #18083
Posted Monday, November 10, 2003 6:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:38 PM
Points: 327, Visits: 987
k2,

Since you are using workgroup security, this info may be wrong, but give it a try. I think the username and password in the connection properties is for the the login for Access, not the file sysyem where the Access db is located. Try leaving username and password field blank (or "Admin" as the username and a blank password). Alternatively, you can play with the Assess login information located under /Tools/Security. This is guess at this point. I will try to recreate this tomorrow.

-JR




Post #86540
Posted Monday, November 10, 2003 6:27 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:38 PM
Points: 327, Visits: 987
..Oops. I meant Access, not Assess.




Post #86541
Posted Tuesday, November 11, 2003 8:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 31, 2013 2:08 PM
Points: 23, Visits: 39
Thanks for your reply, JR. I've tried using the default "Admin" login with a blank password, as well as leaving both blank. No luck.

Unfortunately the Access app is compiled and does not permit the user to manipulate much in the security area - its all hardwired. This application has been a headache for a number of reasons, including the fact that because it uses workgroup security the way it does it interferes with other secure Access applications.

k2




Post #86542
Posted Wednesday, August 15, 2012 8:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 4:37 PM
Points: 1, Visits: 6
you'll have to enter the name and path to your "system" database
Post #1345636
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse