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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert query from MDB to ADP

Status
Not open for further replies.
MBorofsky

MBorofsky

Programmer
Nov 24, 2004
47
US
For some reason the upsizing wizard does not convert 99% of our queries from MDB to ADP. Is there anyway to automate this process so I don't have to go through each query individually and rebuild it in ADP/SQL-Server?
 
Sort by date Sort by votes
We just decided to stick with MDB faced with too short a deadline to convert for speedier runtime. From what I remember it would not convert totals queries (GROUP BY, Sum, ect) but I could be wrong.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
402
breezett93
breezett93
techstudent01
  • Locked
  • Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
359
techstudent01
techstudent01
batteam
  • Locked
  • Question
Need help with .adp report recordsource
Replies
1
Views
194
genomon
genomon
batteam
  • Locked
  • Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
369
lameid
lameid
batteam
  • Locked
  • Question
MS Access 2007 .adp use with SQL 2012
Replies
1
Views
211
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top