Board index » delphi » Need some elementary help on delphi and ms access database

Need some elementary help on delphi and ms access database

i normally use paradox or dbase databases in my applications but now i have
to utilize ms access 7.0 database and i don't have a clue on how to open and
operate the database such as update fields etc.

hope someone can give me some assistance

 

Re:Need some elementary help on delphi and ms access database


Quote
Mahendra <ma...@sapura.com.my> wrote in message

news:7ho35o$8ju4@forums.borland.com...

Quote
> i normally use paradox or dbase databases in my applications but now i
have
> to utilize ms access 7.0 database and i don't have a clue on how to open
and
> operate the database such as update fields etc.

> hope someone can give me some assistance

Hi Mahendra,

You first need to install DAO3.5 on the machine if u dont have it.
Then in the BDE (use 5.01) .
choose configuration->Drivers->Native-Dll32 and change it to IDDA3532.dll.
the try closing and reopening BDE admin. Then create a mdb and try to open
it.

If yuo still get any BDE errors check if this ket is ther in you registry
else create it
check this link http://www.borland.com/devsupport/bde/qanda/FAQ84B.html

Also if have Blobs in your table and you plan to run that on NT SP4 and
above you will get access violations in NTDLL.dll
This is a known problem.

Also try searching at Deja.com on this topic

Good luck

--

Best Regards,
Raghavendra Rao.

Re:Need some elementary help on delphi and ms access database


Quote
>i normally use paradox or dbase databases in my applications but now i have
>to utilize ms access 7.0 database and i don't have a clue on how to open and
>operate the database such as update fields etc.

You connect an Alias or Tdatabase component to the .mdb file of the Access
database you want to use.  Once you have done that you can connect Delphi Ttable
and Tquery  to your Alias or Tdatabase and use it pretty much like you would
with Paradox tables.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads