Workgroup Information File

[andoryuu]

I know this is probably quite stupid, but I'm trying to perform a DTS between my access database and my SQL server 2000 database. However, when I drop the Access Connection into my DTS work area and input the password for the Access DB that I am trying to connect to, I get the following error:

"Cannot Start Your Application. The Workgroup Information File is Missing or Opened Exclusively by Another User."

I don't use a workgroup information file, I just have a database password set on this database. I can't take the password off of the DB, because it has to be secure the whole time it's up on our server. I can't create a workgroup information file, because there are other databases that would relate to this same copy of access that would be effected. (Even if there is a way, it's just too much work right now to go through that access permissions crapola.)

Any help would be greatly appreciated.

-=Andrew=-
Database Support Specialist
"Shinakya ikenai koto ga takusan aru shi . . ." -Utada Hikaru

 

[Glowworm27]

Did you also check to make sure the DB is not in use by another user?

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[andoryuu]

It was not in use by any other person. It is on the network, but I have administrative priveledges on the server.

-=Andrew=-
Database Support Specialist
"Shinakya ikenai koto ga takusan aru shi . . ." -Utada Hikaru