-
Secure Access database access
Ok, I need to give some details. I have a secure Access Database using WorkGroup Security logon. It is an Access 97 database (yes I know it is "old").
I tried to create a DTS package in SQL Server 2000 to connect to it, but I keep getting the same error that I got before I "joined" the workgroup. I have changed the logon identites to mimic me, and still I can't get it to connect.
It seems like nothing is working and I am all out of ideas. Does anyone have any recommendations? Has anyone done anything like this successfully?
PS: I can manually extract the data 1 table at a time from within Access, but I don't want to export 40 tables each time I have to load this data.
Frank
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|