Re: Using MSSQL 2000 database in MS Access?

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

Date: Sun, 11 Jul 2004 12:48:38 -0500

Thanks to all who replied!

Currently my SQL based product does not offer MSSQL but simply requires that
it be available and then you attach the pre-made databases as part of the
installation process. While I have experience with MSSQL via the developer
kit from Micrososft my experience with just MS Access (2000 or later) is not
all that great.

I guess my question was not clear enough here. Let me try it again:

1. Can databases developed for use by MSSQL 2000 be used by MS Access 2000
or later users as is?

2. If so, do these MSSQL databases use a similar attachment method for the
databases in order to use them? Basically what I want to know the the
process for use of my MS SQL databases by MS Access 2000 or later users.

Regards;

><snip>
> MSDE is just one of the variations of SQL server that are available so you
don't
> have to do anything different when using it. If you have a license for
SQL
> server you should have a license to redistribute MSDE. There should be an
> install for it on one of your disks you don't need Access although Access
also
> comes with an Install for MSDE.
> Microsoft also has a program for distributing MSDE that you can sign up
for
> online. http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • Re: MSDE - list databases, describe tables, migrate from Access?
    ... Go into SQL prompt using ... > I am new to SQL Server but have been using Access for a while. ... > installed MSDE to evaluate it for use in small business ... > I can't see how to get the list of databases, tables, and columns that I ...
    (microsoft.public.sqlserver.server)
  • GUI utility for MSDE with DTS
    ... I know there's plenty of MSDE managment utilities out there to help us with ... a nice GUI for MSDE. ... What I like about using Enterprise Manager which comes with the SQL Server ... I need to import data from other databases on my workstation via non-SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: Logging to MSDE
    ... > MSDE is a performance limited version of MS-SQL. ... You will need to use something else to setup the databases. ... > So with that in mind setting up ISA for MSDE should be identical to ... setting it up for SQL 2000. ...
    (microsoft.public.isa.configuration)
  • Re: Q: Named pipes and Windows (integrated) authentication
    ... By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>his windows authentication to connect to the server. ... >>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • Re: Using MSSQL 2000 database in MS Access?
    ... > MS Access 2000 or later installs the MSDE. ... does not install MSDE; you have to download it from Microsoft. ... These machines would also have MSSQL and DATA directories (the ... > want to make a MDB version of the MSSQL databases ot use the Jet Engine side ...
    (borland.public.delphi.database.ado)
Loading