Re: Access 2000 - Realtime Development - Should i stick with Access97

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 06/23/04 

Date: Thu, 24 Jun 2004 00:50:38 +0800

A2000 and later support the ADP, to facilate linking to SQL Server, with the
ADO library.

No reason why you can't just link the SQL Server tables in A97 though, and
continue to use DAO as you have done. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jado" <ploxly@hotmail.com> wrote in message
news:%23dh%23e4QWEHA.1356@TK2MSFTNGP09.phx.gbl...
> Thanks Allen
>
> I'll be sticking with Access 97
>
> just one last thing though...
>
> if I needed to start using SQL Server to store Tables of an Access 97
front
> end,  would this force the need to upgrade.
>
> if not, are there many major benefits of using A2000 appose to A97 in
> conjunction with SQL Server 2000
>
> I'll let you go now  :)
>
> Your comments have proved invaluable in helping me make the right decision
>
> Many Thanks
>
> Jado
>

Relevant Pages

  • Re: Acceess 97 Upsized to SQL 2000 - Memo Field errors
    ... Jado ... > SQL server, then access will proper handle them ... >> an ODBC error. ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL server and ASP
    ... I used A95 and A97 for years before I started with SQL Server. ... The JetSQL syntax for multiple table delete and update statements is ... >> Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: A97 to SQL?
    ... >>> 2) Is it possible to have an SQL server backend ... A97 not so bad, ... Is it possible to have an SQL server backend linked to a A97 frontend - and so have the advantages of big-time backend while still being able to keep refining the frontend myself) ...
    (microsoft.public.access.conversion)
  • Re: Multiple Record Copy Transaction...
    ... Access assigns the autonum *before* the update; SQL Server does not. ... Allen Browne - Microsoft MVP. ... > for a full time job ?, ...
    (comp.databases.ms-access)
  • Re: How to queryvery many conditions in VBA
    ... But is that because Jet is putting those values into a temp table behind ... I've been told that SQL Server does this ... Allen Browne - Microsoft MVP. ... IN to a series of OR criteria. ...
    (microsoft.public.access.queries)