Re: Porting access database into SQL server 2000 opportunity

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 07:35:42 -0500

If you pay attention to details, writing an app that can connect to either MSAccess or MSSQL is rather straight forward. This
includes the use of views and stored procedures. Just about everything that can be done ( in fact, everything I have tried) with an
access database can be done in MSSQL 2000. If you encapsulate your data access routines into an ActiveX DLL, you can ship with a
different version of that DLL and can handle any database.

In short, It is very easy to develop an app that will work against both MSAccess and MSSQL. If you have specific questions, I will
attempt to answer them. 

--
Al Reid
"It ain't what you don't know that gets you into trouble. It's what you know
for sure that just ain't so."  --- Mark Twain
"Tony. K" <ex2003@hotmail.com> wrote in message news:a5fdadcb.0403020425.411b28e7@posting.google.com...
> Hi all,
>
> We're currently using VB with an access Db through ADO to store
> something like 30-40 tables for our application.
>
> We need to use SQL Server 2000 for some customers. Is it a big deal to
> create all our tables to SQL instead of Access? This needs to be
> generic, i.e. if a customer decides to use Access or SQL Server they
> choose the right option and voila.
>
> Chances are we might pay for someone to do us the code for it, but
> need to get an appreciation of the work involved. I'm sure we could
> even manage ourselves with some help on this.
>
> Kind Regards
>
>
> T.Brown

Relevant Pages

  • Re: Getting Started with DB Programming?
    ... Winforms, console apps, or services) then I highly recommend WebMatrix from ... This app was initially developed for inhouse use at MS and then a whole ... a DB engine (SQL Server Data Engine) ... Do I have to buy MSSQL 2000 and install it on ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADO/MSSQL and Connect-Permission problem
    ... Delphi 2006 going against an MSSQL2000 database using ADO-Components. ... Security in MSSQL Server is set ... The users of the app login to the microsoft network using their accounts. ... DBACCESS --> connection error ...
    (borland.public.delphi.database.ado)
  • Re: When Do I Need a Server Back End?
    ... each app. ... much about MSSQL), but MSSQL is supposed to be pretty good about not ... someone who knows how to read dbfs. ... Converting to another back end is not a trivial undertaking. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Performance Issue with Database Connection
    ... I think you mix up with stored procedures. ... handeled by MSSQL. ... the upsize wizzard in MSAccess. ... size limit for MSAccess and MSDE is 2GB. ...
    (microsoft.public.excel.programming)
  • Re: AnyDAC 1.6.0 - freeware Oracle, MySQL, MSSQL, MSAccess, Sybase ASA, ADS data access framewor
    ... AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase ...
    (borland.public.delphi.thirdpartytools.general)