Read access denied errors converting to SQL Server 2000

[Rob]

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

[MGFoster]

-----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:

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.

[Rob]

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 <[e-mail]> wrote:

-----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.