Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 7939 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Oh I can almost guarantee that this post will yield replies all asking why you don't move all of your .mdb records over to FM (which is understandable). I used to work with Access - used to.

If I remember correctly, both FM and Access are compatible with SQL or ODBC. Maybe setting up a Data Source through the Admistrative Tools (Win2k) might create the link you want.

Let me know how it turns out.

Posted

Looks like I'm going to be in the same spot. My organization is purchasing a product which I believe uses Access databases as a base, and we will need to interface our existing system with this new one. I would be interested in hearing if you found a solution - any insight you can provide would be appreciated!

Thanks!

Posted

The best advice I can offer is to look at chapter 15 in the FM user's guide- "Using ODBC with FileMaker Pro."

It specifically says you can "construct SQL queries in FileMaker Pro to import data from other ODBC data sources like MS Access or Oracle databases."

I have never done it before, so I wouldn't be able to tell you exactly, but I guess you would have to:

1. Enable the Data Access Companion

2. Create a data source name in the ODBC control panel

3. Make SQL queries in FM.

Ken

This topic is 7939 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.