Re: MS Access and Delphi?



On client-side cursor (default in VCL ADO) find and filter are implemented
by ADO and do not depend on provider. There should be no problems with NULL
and MS Access too.

//------------------------------------------
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)

"Fred Hebert" <fhebert@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:Xns9646A814795fheberthotmailcom@xxxxxxxxxxxxxxxx
>I am trying to create a small stand alone application for my son that
> stores it's data in a MS Access Database. Usually I am developing client
> server applications that connect to a SQL server, but I this case it's
> back
> to basics. Years back I would have used BDE for this kind of thing, but
> in
> this instance I would prefer to use MS Access.
>
> I tried using the basic ADO components that came with Delphi. It seemed
> to
> be fairly strait forward but it doesn't work as well as I would like.
> First it doesn't like NULL fields and several of the find and filter
> functions are not supported.
>
> Does anyone know of a good reference/tutorial for using MS Access in
> Delphi? Perhaps I don't have some of the options set up correctly?
>
> I am not really interested in buying another DB engine because this is a
> one shot deal, that I am doing for free for my son.


.



Relevant Pages

  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access and processor usage
    ... "increased bandwidth" using ADO. ... bottleneck - need to step up to Sql Server. ... If the data fits into a 2 GB database file, ...
    (comp.databases.ms-access)