I have to convert an Access (JetEngine) database to SQL 7.0. Most of my select Queries, I have converted to Views, with good results, however, I have some Querys that referance forms with in the access project, that will not not convert. Is there a conversion tool or some tips that I can use, or am I looking a rewriting these queries in the code of the forms themselves?
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!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Query conversion to SQL 7.0
- Thread starter BluNozr
- Start date
hi there.
as far as i know, you won't be able to convert those queries which reference access forms. that is an access specific query option and is not available in sql. if you are planning on keeping your access front end, however, you may want to consider 'linking' your new sql tables to your access database. you should then be able to use all of your old access forms and queries (although you might have to modify some of the table names in your code).
as far as i know, you won't be able to convert those queries which reference access forms. that is an access specific query option and is not available in sql. if you are planning on keeping your access front end, however, you may want to consider 'linking' your new sql tables to your access database. you should then be able to use all of your old access forms and queries (although you might have to modify some of the table names in your code).
- Status
Similar threads
- Locked
- Question
- Locked
- Question