Filemaker Pro 9: "Connect to a MS Access DB"

Expand Post »

OS: Win XP Pro
Apps: FMPro 9 and MS ACCESS 2007
Database Types: both are Local to my machine

Good afternoon everyone!!!

--------"Connect to a MS Access DB"----------

I am new at using FMPro 9 (very new after a year of using VBA to manipulate and control MSACCESS db's)...

I see that I can connect to an external source (ODBC), but I am running into obstacles actually attempting to connect to my access db:

I have followed the instructions in the help files on "Configuring an ODBC client driver"
and even chose the Access DB I want to connect to....

I was able to choose this external source under File>Manage>External Data Sources...

Now, when I choose to edit the relationships in my FMP database and attempt to select the "MS ACCESS" source, I get an error stating that the ODBC source is not supported...

So, is there something I am missing, or am I just plain limited to not being able to grab data from a table in an access database?

Thanks for your help and suggestions in advanced!!!

Carmen

PCJIMENEZ

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2008

Permalink

Jul 7th, 2008

Re: Filemaker Pro 9: "Connect to a MS Access DB"

Hi Carmen,

External Data Sources currently support only certain SQL major databases (MySQL, Oracle and a few more), not Access.

If you want to connect to an Access database, you can therefore not have this kind of live connection. You have to make do with some kind of synchronization.

Try using a script with "Import records > ODBC Data Source" to get data and "Execute SQL" to write data.

dwikstrom

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: Making design changes in Access 2003

Next Thread in MS Access and FileMaker Pro Forum Timeline: Filemaker Pro 9: "What about runtime environments?"

DaniWeb Message

Cancel Changes

User Name
Password