Re: Ridiculous problem : getting FM to talk to Access

Thanks for your reply, Michael.

In an ideal world, we would have FM (v9) directly connected ("live")
to the Access mdb (v2). All of the data would remain in Access, but FM
would provide a "front end" for a number of important reports that
Access is too clumsy. Part of the problem is that we need to keep the
data "live" -- not import it (though I'm curious about that too)

The ultimate goal, of course, is to persuade the client to re-develop
the whole thing in FM.

But this is a hurdle we have to overcome before we can proceed with
FM.

Any thoughts?

Cheers,

Ken



Ken

FileMaker can import Access data via ODBC. It has had this functionality
for several versions. What version are you using? Can you be more
specific about what your trying to accomplish?

M Myett

.

Relevant Pages

  • Re: Access mdb file
    ... I would use ODBC after creating a System DSN to the access MDB directory. ... There is a topic in the VFP help files called "How to: Set Up an ODBC Data ... > I have a small app that does some reporting from legacy dbf files. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: finding location of ODBC source in Access
    ... ODBC link in an Access DB? ... An Access MDB was backed-up before a computer was re-imaged ... Registry that was done before the computer was re-imaged. ...
    (microsoft.public.access.queries)
  • Re: localhost access to Access DB denied!
    ... Access MDB is not a viable database, you need to move to SQL Server ... mdb file, which has been defined in ODBC, I get the following message: ... Microsoft OLE DB Provider for ODBC Drivers ... permissions to use the '' object. ...
    (microsoft.public.access.security)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... The reference table is maintained in a nice little Access MDB on my local ... machine here with an ODBC connection set up and, yes, I use Front Page ... little Windows desktop applications it's pretty tough to beat the ... ODBC is not optimal for ISAM data stores, ie. mdb files. ...
    (microsoft.public.vb.general.discussion)