Read access denied errors converting to SQL Server 2000

Apologies if this is a frequently asked question but i haven't been
able to find a satsifactory answer anywhere else at the moment.

My problem is that i'm trying to convert an Access97 database to sql
Server 2000 using the Import and Export Data wizard. I can see the
list of tables but get read access errors when trying to convert them.
I guess this is a security problem, because i can't see reports,forms,
tables, etc. when opening the Access file using Access ( ican run the
Access aplication though).

The original developers of the system no longer support the original
database and (as you can probably tell!)my Access knowledge is pretty
basic (although i have used SQL Server for many years).

So does anyone know how i may be able to convert this file ? Is it a
an acess rights issue and is there anyway i can by-pass these ?

This is quite urgent so any help or pointers in the right direction
would be greatly appreciated.

Thanks
Rob

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You might try using the Access upsize wizard. If that isn't installed
try Add/Delete components install & select Advanced Wizards.

Or, try importing the data from Access to SQL using the SQL'r DTS
functions.


--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIbv1oechKqOuFEgEQKi9gCgt1I0uqr64hfmSyL+VV2PAh h3ZfcAoJxl
uwwLnWPLerphJnNqFyus12dp
=CZBT
-----END PGP SIGNATURE-----


Rob wrote:
[color=blue]
> Apologies if this is a frequently asked question but i haven't been
> able to find a satsifactory answer anywhere else at the moment.
>
> My problem is that i'm trying to convert an Access97 database to sql
> Server 2000 using the Import and Export Data wizard. I can see the
> list of tables but get read access errors when trying to convert them.
> I guess this is a security problem, because i can't see reports,forms,
> tables, etc. when opening the Access file using Access ( ican run the
> Access aplication though).
>
> The original developers of the system no longer support the original
> database and (as you can probably tell!)my Access knowledge is pretty
> basic (although i have used SQL Server for many years).
>
> So does anyone know how i may be able to convert this file ? Is it a
> an acess rights issue and is there anyway i can by-pass these ?
>
> This is quite urgent so any help or pointers in the right direction
> would be greatly appreciated.[/color]

Thanks very much. After re-nstalling Access97, SQL Server 7 and the
upsizing tools - your suggestion worked !!

On Wed, 21 Apr 2004 22:04:13 GMT, MGFoster <me@privacy.com> wrote:
[color=blue]
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>You might try using the Access upsize wizard. If that isn't installed
>try Add/Delete components install & select Advanced Wizards.
>
>Or, try importing the data from Access to SQL using the SQL'r DTS
>functions.[/color]