Anyone out there know much about the compatibility of FMP 4.x with Access? I just started working with a company that is using a Microsoft Office 2000 Network (PC of course) to keep track of their daily activities and I want to know if I can link/relate my database up to theirs as mine is so much more developed for what I do than theirs is. Just how much of a problem is my Mac going to cause (the one obvious reason that I started using FMP in the first place is that it works cross platform)? It would save all a lot of time and keep the flow moving nicely if I could make this work out. Thanks for any info..

HI,

I think I've heard that FMP 4.x is ODBC compliant. I think it's better though for 5. I haven't actually done this myself, but I have been reading about it, so theoretically (from the way folks have described it) it's quite easy and good.

Thanks for the reply Louisa, but I unfortunately don't know what ODBC stands for. Can you enlighten me? Much appreciated...

ODBC = Open database connectivity

What it does is it takes information from one database and translates it into a form that can be read by another database and sends it to that database. It makes a conduit from Access to Filemaker so that a user in Access can search and retrieve information from the FileMaker database but manipulate it in Access and vice versa. Does this kinda sound like what you want to happen??

Honestly though, I have no idea how good the connectivity is for older versions of FileMaker like 4.x. It's a relatively new integration into FileMaker, so you might want to look into this carefully before doing it.

[This message has been edited by Louisa (edited July 21, 2000).]