Re: Using MSSQL 2000 database in MS Access?
From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 07/10/04
- Next message: Brian Bushay TeamB: "Re: multi-tier app with TADOQuery dataset"
- Previous message: Viatcheslav V. Vassiliev: "Re: fastest way to insert one record into a table"
- In reply to: Bob Dalton: "Using MSSQL 2000 database in MS Access?"
- Next in thread: Brian Bushay TeamB: "Re: Using MSSQL 2000 database in MS Access?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 10 Jul 2004 23:50:05 +0400
Your users should install MSDE - there is setup.exe on CD, as I remember it
is not installed by default. When MSDE is installed, you work with it the
same way as with MS SQL Server 2000. Really, MS Access or MS Office at all
could not be installed, it is enough to run just MSDE installation from CD.
MSDE has limit for 5 concurent connection that should be enough for local
usage and limit for database size - 2 GB.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Bob Dalton" <bob.dalton@removeme_digitallogistics.com> сообщил/сообщила в
новостях следующее: news:40f03b49@newsgroups.borland.com...
> 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: Brian Bushay TeamB: "Re: multi-tier app with TADOQuery dataset"
- Previous message: Viatcheslav V. Vassiliev: "Re: fastest way to insert one record into a table"
- In reply to: Bob Dalton: "Using MSSQL 2000 database in MS Access?"
- Next in thread: Brian Bushay TeamB: "Re: Using MSSQL 2000 database in MS Access?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
