By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Read access denied errors converting to SQL Server 2000

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----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.


Nov 12 '05 #2

P: n/a
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 <me@privacy.com> 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.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.