🚀 go-pugleaf

There are some differences in MS SQL Server and MS Jet (Access). So just
changing connection string may be not enough.

You can use MSDE (MS SQL Server Desktop Edition - that ships with MS Office,
MS Visual Studio etc.) - it MS SQL Server will slow down if there are more
than 5 concurent connections (really this means that usually you can have
even 100 users) and limit databases to 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)

"Simon Elliott" <Simon at ctsn.co.uk> ???????/???????? ? ???????? ?????????:
news:40b3af1d$1@newsgroups.borland.com...
> I need to quickly put together a program which will work with MS SQL
> Server 2000. The only problem is, SQL Server is not currently running
> here and I don't currently possess a copy of it.
>
> If I use ADO (TADOConnection etc) and create the relevant tables in MS
> Access, and develop and test the application, would it only be a matter
> of changing the connection string to get the app to work with SQL
> Server?
>
> Are there any risks in proceeding on this basis?
>
> I'm not familiar with the cut down version of SQL Server which is
> supplied with MS Office 2000 Pro. Can I cerate and populate tables
> using this version?
>
> Thanks in advance for any advice or information!
> -- 
> Simon Elliott    http://www.ctsn.co.uk