Accessing MS Access Tables

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Accessing MS Access Tables

Post by customaware »

Does anyone know if it is possible or even better know how to access MS Access tables from Aware please?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
rbross
Posts: 441
Joined: Wed Nov 19, 2014 4:13 am
Location: Coventry, Connecticut USA

Re: Accessing MS Access Tables

Post by rbross »

Have you tried to set up a Custom database connection, using OCDB to Access?
In theory, you should be able to use ODCB or JDBC to connect to any database.
Just like you would if you connected to a pervasive database.
Roger Ross
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Accessing MS Access Tables

Post by tford »

Yes, via ODBC as Roger mentioned. Back when I started using Aware in 2007, our company had an Access DB that I needed to expose to the web for our customer to see. Aware worked well. Sorry I can't begin to give you specifics as that's been a LONG time ago.
Tom - V8.8 build 3137 - MySql / PostGres
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Accessing MS Access Tables

Post by customaware »

Thanx guys.

Good to know it is doable.

Means my time working out how will not be wasted. 🤣
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Post Reply