Importing Access Database to SQL -- "no read permission" on user-level secured DB
Posted on 2003-12-04
I have an old Microsoft Access database that I want to import into MS SQL Server 2000. I get the following error when I try to run the import:
Error Source: Microsoft JET Database Engine
Error Description: Record(s) cannot be read; no read permission on [xxx] (table in old db)
I know the admin user's login and password, but when I enter that information in, I get another error:
Description: Cannot start your application. The workgroup information file is missing or is opened exclusively by another user.
I am assuming system.mdw is the "workgroup information file" and have put this everywhere I can think of so that SQL Server could find it. No such luck so far.
This is urgent... any help is greatly appreciated.