Hi Polpe,
If your filemaker server has an ODBC driver then you can create a dsn to
the server in
Control Panel/Administrative Tools/Data Sources (ODBC)
if you go to
Control Panel/Administrative Tools/Data Sources (ODBC)
select the System DSN tab. Then click the Add button. This will bring
up a list of ODBC drivers on your computer. I don't know what the
Filemaker ODBC driver is called, but you might look for any driver that
contains the name Filemaker -- or if there is no driver that contains
that name, then look at the file extensions of the ODBC drivers. The
drivers for Access end with .mdb. The drivers for DB2 databases end
with Dbf.
If you don't see any drivers then try searching the web for Filemaker
ODBC driver
Once you have the odbc driver installed go back to the control
panel/admin..tools/data sources...System Dsn tab, Add, select your
driver, click on finish, then name your data source (any name you want)
select the server from the dropdown - note: if the server name does not
appear in the dropdown, you can type the name in. Then select the
database you want to connect to. Click the Test button to make sure
that you have a good odbc connection. The test will say something like
Successfully connencted to the server or something like that.
Then, in access, go to Link Tables from the File menu, in the dialog box
that comes up, go to the dropdown box at the bottom of the dialog
window. Scroll to the bottom of the dropdown and select ODBC
datasources. When the ODBC datasource dialog comes up, select System
DSN. You will see the Dsn you created in the control panel. Select
that and then select a table you want to connect you.
Rich
*** Sent via Developersdex
http://www.developersdex.com ***