Microsoft Access database

[cyprus106]

OK, I work for a big database company doing all this client server technology junk and then I get into Builder to connect to a Microsoft Access database, I'm in over my head. Ironic, huh? Borderline embarassing (don't tell my boss)

So there's the question. How do I get access to tables in a Microsoft Access Database? I checked the Server components and they didn't seem to work. Working with databases has been somewhat ominimus to me with Borland so I've always tried to avoid them but now for a huge job I have to work with them and don't know how. Does anybody else? I know it's pretty straightforeward but I just don't know which buttons to push... Cyprus

 

[hnd]

Install the ODBC (or Native) Driver Connect the program to the Database, Use the class TTable and that is it.

But one thing: If you are working in a networked environment, don't use Access. It is very slow under that conditions.

hnd
hasso55@yahoo.com

 

[cyprus106]

no network for this, just a database. So say I've got the ODBC driver, which I think I do... Whats the line(s) of code necessary to connect to the dbase? Cyprus

 

[hennep]

hi Cyprus,

did you see the FAQ from wimvanherp:

http://www.tek-tips.com/faqs.cfm?spid=101&sfid=536

Hennep

 

[Wings]

As long as its installed on the ODBC drivers, the ttable component should be able to see it, simply select the database from the drop down list in the object inspector - DatabaseName, and then TableName.

 

[cyprus106]

OK, I seriously need more help. I tried making a driver and it didn't work. I don't knwo what I'm doing wrong and I tried following the FAQ but it didnt work and I'm in serious need of help here. What driver do I have to set an Access Database as? Is there detailed instructions somewhere that anyone knows of?? I've tried everything I know. I've got all the components and stuff, but I just can't seem to make the Driver work. my database is at c:\db1.mdb and when I put it on a driver like MSACCESS or Microsoft Access Database it keeps giving me these errors... Cyprus

 

[Wings]

You don't need to make your own driver, simply use the wizard in the control panel -> Administrative tools -> Data Sources (ODBC).

Several things must be done.

1.Create the database (obviousley)

2.Have yo added the database to your odbc drivers through the control panel? - if you have not, nothing will work.

3. Add a TTable component to the form, follow the advice from my previous posting on this topic.

 

[cyprus106]

thanks. I added it through the (ODBC) thing that you suggested above just minutes before I was able to read this. Thanks!

Cyprus Cyprus