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