Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fourier
Starting Member
7 Posts |
 Posted - 2002-06-12 : 05:23:52
|
| I have an Access 2000 database needded to be converted to sql 7.0.When I used the Import and Export data option in SQL server,it gives the following error msg.Cannot start your application.Workgroup information file is missing or open exclusively by another user.But I can separately start the app.Also no other user is using it. |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-12 : 05:46:18
|
| Do you use Access security on your database? If so, SQL Server probably doesn't have access unless it knows about the mdw file. I've never done this, but there may be a way in SQL to specify a security file for access. Alternatively, you can export the data out of Access into csv or other file types and import it into SQL. |
 |
|
|
fourier
Starting Member
7 Posts |
Posted - 2002-06-12 : 07:29:26
|
quote:
Do you use Access security on your database? If so, SQL Server probably doesn't have access unless it knows about the mdw file. I've never done this, but there may be a way in SQL to specify a security file for access. Alternatively, you can export the data out of Access into csv or other file types and import it into SQL.
I don't use Access security on the DB.Can you pl. elaborate a bit more about exporting to CSV file type. Thnx in advance |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-06-12 : 09:05:25
|
quote:
Do you use Access security on your database? If so, SQL Server probably doesn't have access unless it knows about the mdw file. I've never done this, but there may be a way in SQL to specify a security file for access.
There is. In the DTS wizard, select Microsoft Access and click Advanced. Put the pathname of the mdw file in the "Jet OLEDB:System database" field. |
|
|
|
|
|
|
Import to MS SQL7.0 From Access