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