« Xojo Meeting in Berli… | Home | SQL Plugin option to … »

Microsoft Access?

Does MBS Plugin allow to connect to a Microsoft Access database?

Yes, it does.
Use our SQL functions to connect to the database via ODBC on Windows. The Connection string looks like this: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Users\Christian\Desktop\test.mdb". As you see we specify to use the Microsoft Access driver and include the file path to the database file. You can include an user name and a password if needed.

Once connected you can use SELECT SQL command to query tables for values. You can run DELETE, INSERT or UPDATE commands to modify data.

Works in Real Studio, FileMaker and Xojo in my testing here with 32-bit Windows.
06 06 15 - 00:55