"Todd C" wrote:

> Hello NevilleT:
>
> With Access, even though you open the file and do not supply a username and
> password, if you are using the default Workgroup file, then it defaults to
> "admin" as the username with a blank password. Try setting admin as the
> username but leave the password blank.
>
> HTH
> --
> Todd C
>
> [If this response was helpful, please indicate by clicking the appropriate
> answer at the bottom]
>
>
> "NevilleT" wrote:
>
> > I am just learning about SQL Server so please excuse what may be a silly
> > question. I am importing the data from an Access 2000 back end database into
> > SQL Server 2000 using the DTS Wizard.
> >
> > The SQL Server database I created through the Access Upsizing Wizard is fine
> > in that I can see all the tables and columns as they should be. I can load
> > data manually into the tables.
> >
> > The Access database I want to import from has no password, or is not
> > associated with any special workgroup file.
> >
> > When I try to import data, I am using Windows Authentication and leave the
> > Username and Password of the Access database blank. If I try and preview the
> > data, even on just one table, I get an error:
> >
> > "Record(s) cannot be read; no read permission on 'Whatever the table name
> > happens to be I am testing at the time'.
> > Context: Error calling RowSet on the provider."
> >
> > I tried a compact and repair on the Access database but no difference. Any