Re: DAO-ADO question

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

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 06:34:01 +0100

Hi Sirocco,

As I understand it, a basic "upsizing" simply leaves you with linked
tables connected to the SQL Server database rather than to the mdb back
end, with little if any code changes required. On the other hand
extensive re-working will be needed to take full advantage of SQL
Server. Tony Toews has links to upsizing information at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

On Thu, 23 Sep 2004 13:51:32 -0400, "Sirocco" <NB2002@arczip.com> wrote:

>I have an mdb front end and back end. Will the same DAO code work if I link
>my mdb front end to a SQL Server, or do I have to make my code ADO-compliant
>as if I were converting my front end to an access project (i.e., ADP)?
>
>With that in mind, is "Forms!Formname.Form.RecordsetClone.RecordCount <> )"
>ADO compliant?
>
>Many thanks in advance.
> 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.

Relevant Pages

  • Re: Access 2002 Upsizing Wizard does not copy forms
    ... Upsizing *.mdb to SQL Server, using Upsizing Wizard, ONLY transfer data from ... Jet database to a SQL Server database (either new or existing, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Access limitations/suitablity
    ... Sorry for my delayed response. ... I think Tony has some great thoughts on upsizing as to when and how. ... Dave Hargis, Microsoft Access MVP ... performance they had to convert to something like SQL Server? ...
    (microsoft.public.access.gettingstarted)
  • Re: Field lookup in SQLS tables
    ... You can't do it using SQL Server (and you'll find that there are a large ... Doug Steele, Microsoft Access MVP ... "Rajat" wrote in message ... > I have just ported my app from MDB to ADP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: .MDB local to .MDB with linked SQL
    ... try just upsizing that table, without data first, if that works then do it ... >> Hi Ryan, ... >>>local .mdb to a .mdb with linked tables on SQL Server). ...
    (microsoft.public.access.conversion)
  • Re: From .mdb to .adp database
    ... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
    (microsoft.public.access.adp.sqlserver)