PC Review


Reply
Thread Tools Rate Thread

Approach queries VS Access queries

 
 
Nuti
Guest
Posts: n/a
 
      18th May 2006
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

 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      18th May 2006
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

"Nuti" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correct approach for clearing memory with repeated Database queries simonboland@gmail.com Microsoft Excel Programming 5 21st Nov 2007 09:35 PM
Conversion of MS Access queries to SQL queries raonhassan Microsoft Access Queries 1 8th Jun 2007 12:11 AM
Help: Convert these Access queries to Microsoft SQL 2000 queries: admlangford@gmail.com Microsoft Access 5 16th Mar 2007 04:45 AM
Access Queries to Sql Queries Scott Elgram Microsoft Access 0 24th May 2005 07:03 PM
Access: Documenting use of tables/queries in queries =?Utf-8?B?QXVja2xhbmQgQWNjZXNzIFJhdGVy?= Microsoft Access 0 3rd Aug 2004 11:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:41 PM.