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 |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2004-06-01 : 11:34:38
|
| Hi Reader!I have an access database and I want to import it into a new sql database. I have had a go but I get the below error:---------------------------DTS Import/Export Wizard Error---------------------------Error Source: Microsoft JET Database EngineError Description: Record(s) cannot be read; no read permission on 'Code'.Context: Error calling OpenRowset on the provider.---------------------------OK ---------------------------Any ideas?ThanksLeah |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-01 : 11:38:14
|
| Yeah...you're access db is secured and they removed admin from the admin group...Good design actually...You're going to need the admin account and password...then go to the advanced tab and add the location of the mdw file....with the login and password....Brett8-) |
 |
|
|
leahsmart
Posting Yak Master
133 Posts |
Posted - 2004-06-01 : 11:42:03
|
| Thanks Brett I have got it to import now:) |
|
|
|
|
|
|
Importing into sql from access