Click here to Skip to main content
15,068,645 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi friends
when convert ms access database into sql server database using sqlserver importdata the following error is occured.

The Workgroup information file is missing or opened exclusively by another user.

but i did not open MsAccess file any where in the system while converting.
To open a file in msaccess2007 I am using a password "library".
In sql server import and expord wizard i just only given Password "libarary".and no need for username in msacces so i did not given username in that field.
My system is windows 8 and x64 processor. but i am using msaccess2007 that is 32 bit.and i am using sql server 2008. how can solve the problem?

Thanks in advance
mahmoodof 13-May-13 15:41pm
hi -
try to do it in administerator mode?test it.
Maciej Los 13-May-13 15:46pm
Please, post complete error message.
RedDk 13-May-13 17:57pm
Now we're getting somewhere. Why not skip MSAccess altogether? Spider senses are tingling here. Open MSAccess? (2007)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900