Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2000 ans Access 2000

Status
Not open for further replies.
alan2624

alan2624

Programmer
Mar 26, 2002
16
US
I recently used the Data Transformation Services / Import Wizard to import my Access 2000 database to an SQL 2000 database. The problem is that now some of the queries that worked fine in Access are giving me a host of errors is SQL.
It is connecting fine to the SQL database.

Does anyone know an article or website I can try to get the changes in syntax that are needed between the two databases.

Thank you
 
Status
Not open for further replies.

Similar threads

bslintx2021
  • Locked
  • Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
1K
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
1K
leifoet
leifoet
DiDYRO_
  • Locked
  • Question
How do I make a VBS file that can collect dialog-type answers in a local .log file?
Replies
0
Views
512
DiDYRO_
DiDYRO_
leifoet
  • Locked
  • Question
Classic ASP multiple record update with Access
Replies
7
Views
687
dhookom
dhookom
sdagger2
  • Locked
  • Question
Classic asp: Insert new record to access database from successful PayPal payment
Replies
2
Views
373
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top