Not so new anymore but not used to do complex access stuff (1 Viewer)

[WiWo]

I've over 40years IT experience but very little Access experience. Just simple queries, forms, reports, ... and always on a local DB.

Now, I have to use Access to make queries, reports, forms on an external (MariaDB) database and therefore, I'm looking for some help.

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[theDBguy]

Hi. Welcome to AWF!

 

[The_Doc_Man]

Hello and welcome to the forums.

Let's clarify something to make your life simpler. Making reports and queries is EXACTLY THE SAME for local tables and remote tables. It is making the table definitions point to the right place that is the trick. So focus on getting the table linkage right and then (for the most part) forget that it is an external database.