Results 1 to 3 of 3

Thread: Trying to convert a sql server query to an Access 2007 query

Threaded View

  1. Jan 10th, 2013, 04:28 PM #2
    gibra
    Guest

    Re: Trying to convert a sql server query to an Access 2007 query

    Sorry, but the Access database:

    1. doesn't support CASE WHEN ...
    So you replace CASE WHEN using Iif/Then ...


    2. some internal Access functions not works in each scenario.
    i.e. You own Access 2007 (and this is ok, no problems), but if you deploy your application to customers which own Access 2010 then the REPLACE (and many other functions) no longer work.
    They work only when used internally in MSAccess environment.

    Thank to Microsoft

    Last edited by gibra; Jan 10th, 2013 at 04:31 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width