Re: Acess to a MSACCESS2000-File

Article View: borland.public.cppbuilder.database.ado

Article #3881

Back to borland.public.cppbuilder.database.ado Previous Next

#3881

From: Jerry Irons
Date: Wed, 12 Jun 2002 13:51

21 lines
1665 bytes

Hello,

Drop ADODataset component on your form.

Set the ConnectionString to "use connection string" and build.  Select
MS Jet 4.0 as Provider.  For the connection tab, under 1 select
database, browse to your folder and select the mdb database.  Test
your connection to make sure it works.  (test button)  
Finally, under advanced tab, make sure that read/write is only box
checked.

Back to dataset component.  Change cursorlocation to "UseServer".
Much faster.

If you are just accessing fields in a table, change commandtype to
tabledirect.  Otherwise, build your sql string in commandtext.

Lastly, change the dataset component active to true to verify
everything opens ok.  

-Jerry

Technical Details

Message-ID: <k6kegug915a7if3noiofb1c2iilifuo0uf@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-08!supernews.com!216.227.56.88.MISMATCH!DirecTVinternet!DirecTV-DSL!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!news-xfer.siscom.net!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3d04a582$1_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,73c432c3e8102bb5
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-12 07:00:51 PST
From: Jerry Irons <JIrons@compuserve.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Acess to a MSACCESS2000-File
Date: Wed, 12 Jun 2002 09:51:51 -0400
Message-ID: <k6kegug915a7if3noiofb1c2iilifuo0uf@4ax.com>
References: <3d04a582$1_1@dnews>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.54.9.179
X-Trace: dnews 1023889962 24.54.9.179 (12 Jun 2002 06:52:42 -0700)
Lines: 27
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-08!supernews.com!216.227.56.88.MISMATCH!DirecTVinternet!DirecTV-DSL!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!news-xfer.siscom.net!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message