View Single Post
Join Date: Jul 2008
Posts: 2
Reputation: PCJIMENEZ is an unknown quantity at this point 
Solved Threads: 0
PCJIMENEZ PCJIMENEZ is offline Offline
Newbie Poster

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

 
0
  #1
Jul 3rd, 2008
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
Reply With Quote