Approach queries VS Access queries

  • Thread starter Thread starter Nuti
  • Start date Start date
N

Nuti

Hi,

We are migrating from approach to access.

My basic understanding of the procedure is that the data has to be
migrated and all the other features like forms and reports have to be
recreated.

Is 'Approach query' different from MS Access query? Can this be assumed
to be replaced by Access query?

cheers,
Nuti
 
Queries which conform to ANSI 92 syntax will work. Access (and all other
database engines) also has its own unique commands. Any of those will need
to be written in Access. You'll find that the Access/Jet query engine is the
most powerful one in existance, since it can use all VBA functions in its
Expression Service.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 

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

Gathering approach file properties(inventory) 1
Urgent - how to disable user from making new queries 2
Access 2007 query (large IN statement), alternate approaches 8
how to pass a parameter to a query base of a query that is the base of a report 0
Form datasource from sql server backend 1
DBF linked on ACCESS Query 1
Access #Error & Excel Pivot 0
Access Upgrade? 3

Back
Top