Hi, I need to import data from Access table to SQL Server table. When I
choose the Access file I got this message:
Error Source: Microsoft JET Database Engine
Error Description: Cannot start your application. The workgroup information
file is missing or opened exclusively by another user.

I am sure no one is using the file because it is in my PC. When I use the
same userid and password I can open the file in Access.
Anyone can help?
Thanks

Hello Ava,

Have a look at this article

How can I dynamically set the Access System Database
(http://www.sqldts.com/default.aspx?241)

You are missing the system.mdw reference by the sounds of it.





--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]