Using MSSQL 2000 database in MS Access?

From: Bob Dalton (bob.dalton_at_removeme_digitallogistics.com)
Date: 07/10/04

  • Next message: Bob Dalton: "Sample project to demonstrate connecting via ADO" 
    Date: Sat, 10 Jul 2004 13:53:59 -0500

    I have a commercial product that works well under MSSQL 2000. The user
    simply "attaches" the databases from my product to MSSQL 2000 and my Delphi
    7.0 Pro client using ADO and MDAC 2.0 then connects and works with those
    databases.

    Is is possible for someone who has only MS Access 2000 or later, which uses
    the MSDE, to be able to use these same databases as well? If so what would
    be the procedure for them to install and use the product MSSQL 2000
    databases with MS Access 2000 or later? I assume the ADO side would be the
    same. Any negative things I need to be aware of here?

    Regards;

    Bob Dalton

  • Next message: Bob Dalton: "Sample project to demonstrate connecting via ADO"

    Relevant Pages

    • Re: ADO and BLOB
      ... >I migrating from FoxPro to MSSQL, to reach each of them I use ADO ... >can anybody tell me an example for using the two databases and copy one ...
      (borland.public.delphi.database.ado)
    • Re: mssql lacks
      ... > access has IIFwhereas mssql hase case when (this already means ... > queries in programs just to enable users to choose between databases. ... VBA functions that you've created. ...
      (comp.databases.ms-sqlserver)
    • Re: Using MSSQL 2000 database in MS Access?
      ... While I have experience with MSSQL via the developer ... Can databases developed for use by MSSQL 2000 be used by MS Access 2000 ... process for use of my MS SQL databases by MS Access 2000 or later users. ... > server you should have a license to redistribute MSDE. ...
      (borland.public.delphi.database.ado)
    • Re: mssql lacks
      ... > mssql databases instead of access. ... > queries in programs just to enable users to choose between databases. ... recall that SQL Server has its origins at Sybase, ...
      (comp.databases.ms-sqlserver)
    • Re: Delphi bugs and "moving" to Visual Studio debate
      ... greater impact on IDE of choice in relation to databases is what kind of database support the IDE's data engines and components offer. ... presentation to demonstrate or teach a feature, it should be using Interbase and not MSSQL and Northwind as has frequently appeared lately, especially the ECO folks. ... Sure, you can use BDP, but then you could use BDP for MSSQL. ...
      (borland.public.delphi.non-technical)