Re: Using MSSQL 2000 database in MS Access?

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

Date: Mon, 12 Jul 2004 09:55:37 -0500

Thank you for your reply.

MS Access 2000 or later installs the MSDE. That version, as several have
noted, in limted to 2GB etc, and does not install the Enterprise Manager
which I am used to working with. With the Enterprise Manager you would
simply "attach" the database and make the connection string and that is
pretty much that. Without an Enterprise Manager I am not not sure how you
would "attach" your database to the MSDE, as you do with MSSQL. You
mentioned that this could be done form the commandline. Can you point me to
somewhere that has more information on this method?

When installing the MSSQL server on my machines it automatically overrides
the MS Access installation and replaces it with its own files. This makes it
a bit hard to discern what is going on here and I do not have the luxery of
dedicating a machine specifically to MS Access here at our offices and
keeping MSSQL off of it.

I do not use MS Access and only keep it around to test the occasional MDB
file I see from activities which I do which are not related to my commercial
work. This makes my knowledge of MS Access less then stellar here.

There are however many MS Access users out there and it would be nice to be
able to allow them to use my MSSQL based product, if that is possible but
still retain the easy ability to move up to MSSQL when required. I do not
want to make a MDB version of the MSSQL databases ot use the Jet Engine side
of things.

Regards;

Bob Dalton

"Jeremy Collins" <jd.collins@ntlworld-not.com> wrote in message
news:40f25088$1@newsgroups.borland.com...
> Bob Dalton wrote:
><snip>
> No, they are separate database systems. Your users could install
> MSDE (which has nothing to do with Access), and attach your SQL
> database via the command line.
> process for use of my MS SQL databases by MS Access 2000 or later users.
>
> Alternatively, you can use DTS to create an Access (mdb) version
> of your SQL database, which may or may not work with your application -
> it depends on whether you've used SQL statements compatible with both
> products. It's normally simple to test this - just change your ADO
> connection object's connection string to point to the Access file
> and test.

Relevant Pages

  • Problems getting EM running on a fresh 10g Windows 2k3 install
    ... having getting the web based enterprise manager running on a new 10g ... install. ... SEVERE: Error starting Database Control ... I've tried uninstalling and reinstalling enterprise manager, ...
    (comp.databases.oracle.server)
  • Using Enterprise Manager 9.2 with a 10g database?
    ... Is there any way to get version 9.2.0.1.0 of Enterprise Manager ... running in standalone mode to talk to a 10g database? ... I did download and attempt to install the 10g EM, ... database and loads of services, and my poor little laptop (1.8GHz CPU, ...
    (comp.databases.oracle.server)
  • Re: 1 server 2 SQL apps
    ... >clients lke query analyzer, Enterprise manager. ... >Best option for you might be, Install a default installation of SQL server ... >1 database each for application. ...
    (microsoft.public.sqlserver.server)
  • Copy SQL Server 2005 Express database to SQL Server 2000
    ... I have a copy of a SQL Server 2005 Express database - the mdf and .ldf ... If I copy to my machine and in the Enterprise manager try to attach ... What would I need to install on my machine to achieve ...
    (microsoft.public.sqlserver.tools)
  • Copy SQL Server 2005 Express database to SQL Server 2000
    ... I have a copy of a SQL Server 2005 Express database - the mdf and .ldf ... If I copy to my machine and in the Enterprise manager try to attach ... What would I need to install on my machine to achieve ...
    (microsoft.public.sqlserver.dts)