uploading queries from Access 2000 to SQL Server 2000

J

judith.l.robert

I know that there is an upsizing tool in Access to upsize
from Access to SQL 7.0. I'm trying to upsize to SQL 2000
and haven't gotten it to work.

The database I'm trying to upsize is mainly tables, and
links to tables with a number of queries. I can import
the tables, but I'm trying, unsuccessfully, to upload the
queries so I don't have to recreate them.

When I use the upsizing wizard I get an overflow error,
without any details or helps. I'm not sure what is
causing this or how to correct it.

If I try and pull the queries up to SQL, I just get the
result of the query instead of the query itself. Any help
is appreciated.

judy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with queries and linked SQL Tables 2
MS Access Query criteria Problem 2
Update pass through query of report recordsource 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
"Data Has Been Changed" error with MSSQL 2005 backend using left j 1
Queries missing in ADP and SQL after upsizing 4
SQL upsize 2 databases 2
SQL Server Queries 5

Top