?
Solved

FileMaker 12 connection to a series of Access db tables

Posted on 2013-01-05
6
Medium Priority
?
962 Views
Last Modified: 2013-01-06
(very, very) new at this with no experience in Filemaker pro (but hey, i bought it because its advertised as so easy.)

To start the project, I need to connect FileMaker to a series of existing Acccess tables that were split back end and front end.  The best outcome is to connect Filemaker to the production Acccess tables in a read only mode, so that users can continue to use access front end reports & data entry, while new fancy web enabled reports can be developed in Filemaker (intent is Filemaker will not do data entry, just reporting.)

Been stymied by the ODBC connections for Filemaker to Access, right out of the gate.  The development machine with Filemaker is win7 64 bit and the Access  is 2010 32 bit.  Have uncovered the weirdness of where MS chose to put the OBDC console for 32 bit office on Win7 and have seemingly created an ODBC driver for the Access tables, but Filemaker balks with the simple statement "The ODBC data source you have selected is not supported", so clearly I don’t know what I'm doing (new, newbie.)


Short version?  Anyone offer a step by step advice on connection Filemaker (Read Only?) to Access tables to get me to the next newbie level?
0
Comment
Question by:VirtualKansas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 58
ID: 38747119
Is Filemaker 32 bit or 64?  If 64, you'll have some hoops to jump through.

If it's 32 bit, make sure that your setting up a DSN for Access with the correct ODBC manager, which is:

c:\windows\SysWOW64\odbcad32.exe

and setting up the DSN as a system DSN.

If your trying to connect directly to Access in FileMaker without a DSN, post the connection string your trying to use.

Jim.
0
 

Author Comment

by:VirtualKansas
ID: 38747211
Hi Jim; serious newb again.  I see nowhere to tell me if 32 or 64 in help->about or on install cd or unistall info.  Version is 12.0.1v Advanced and install directory is in the Program files x86 path so leads me to believe its 32bit.

I believe I did set ODBC in the correct path (there are notes in the world about 64 win7 and 32 bit office that helped.)  The setup was a system DSN and driver I chose is MS Access driver .mdb/.accdb.)

The error occurs when i attempt to use file-> manage database-> add tables.  Is the ODBC connection a culprit or my inexpexperience in next step of adding access data?  TY
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 38747408
<<Program files x86 path so leads me to believe its 32bit.>>

 I would guess that it is as well.

<<I believe I did set ODBC in the correct path (there are notes in the world about 64 win7 and 32 bit office that helped.)  The setup was a system DSN and driver I chose is MS Access driver .mdb/.accdb.)>>

 What's nice about a setting up a DSN is that you can use another tool (i.e. Excel) to check the connection if not right in the ODBC manager itself.  That helps pin down problems.

<<The error occurs when i attempt to use file-> manage database-> add tables.  Is the ODBC connection a culprit or my inexpexperience in next step of adding access data?  TY >>

 Can't help you there as  I 've never used Filemaker.  If you have Excel handy, create a data query on the DSN and see if you can get some data out of the DB.  If so, then the issue lies in Filemaker.

Jim.
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 

Author Closing Comment

by:VirtualKansas
ID: 38747476
Well, that helped.  Excel connected as expected.  It's a filemaker thing; so the school of hard knocks continues.  Thank you...
0
 
LVL 58
ID: 38748782
OK did a little digging and you should take a look at this:

http://www.filemaker.com/support/product/docs/12/fmp/fm12_odbc_jdbc_guide_en.pdf

 Take a look at Chapter two.  While not quite the step by step you asked for, it does talk about how you import and connect to ODBC sources in File Maker.

 Let me know if that was helpfull or not.

 Also, I do have remote connectivity software here.  If you really get stuck, we could work on it over the phone (always willing to learn something new - have never worked with Filemaker and am curious).

Jim.
0
 
LVL 58
ID: 38748790
Looks like you need to use the "repleationships graph" in Filemaker to get at the data.

It's not clear to me though if Access is supported or not even with ODBC.  Everything I've found talks about importing Access data, but not working directly with it.

Jim.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question