I have an access database that i upsized a few weeks ago and i need to add another table form that database, however when i use the DTS import wizard to get the particular table i wish i get as far as picking the table but i cant preview or do the import, i get the following error message on it!
Error Source: Microsoft Jet Database, Error Description: record(s) cannot be read; No permission on the table 'InternetBilling', Context: error calling openrowset on the provider.
Ive working on a copy of the access database and given all user groups read persmission and im still getting this, how do i get around it?
With much thanks for any help,
Amit
Is the file workgoup file secured ? Then you have to use name the workgroup file in the properties of the data source, otherwise the server can′t authenticate at access.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment