How to write a ThinBasic program that works with Microsoft Access

[EricE]

Hello ThinBasic Forum.

I have a project that would require a ThinBasic program to work with a Microsoft Access database.
Writing a program in any language that interfaces with Access would be new to me.

Perhaps someone here could provide a few hints as to how to start to learn to write such a program?

Thanks,

Eric

[Michael Hartlef]

Hi Eric,

I never tried it myself, but in the Samplescripts folder, there is a sub folder called ODBC.

Most of the scripts there open a connection via an Microsoft Access Driver.
Maybe these can be of help to you.

Good luck
Michael

[Kinsonye]

Use CreateObject("ADODB.Connection") to set up the connection. You'll need a proper connection string and then you can run SQL queries. Check out some ADODB and OLE DB examples for details.

[etermark]

When I started with ThinBasic and Access, I found ADO commands super helpful. Try opening a connection and running a simple query to begin. The ThinBasic docs have great examples to guide you.