bwill2000 Posted April 30, 2003 Posted April 30, 2003 Dear All, Is there anyway of linking a filemaker database to fields within a MS Access Database? Thanks BW
kenneth2k1 Posted April 30, 2003 Posted April 30, 2003 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.
MeltDown Posted May 5, 2003 Posted May 5, 2003 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!
kenneth2k1 Posted May 8, 2003 Posted May 8, 2003 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now