Error connecting to ODBC File Data Source

Error connecting to ODBC File Data Source

Post by Bill W » Thu, 19 Jul 2001 21:50:44



I am using Access 2002.  I have a File Data Source ODBC connection set up on
my server that points to a directory containing Foxpro free tables.  I try
to link to external data using this ODBC connection in Access 2002 and get
the following error message: "Reseved Error (-7778) There Is No Message For
This Error".  This connection works when I attempt to get to it from Excel.
I can also get to the tables using a system type Machine Data Source ODBC
connection.  Can someone help me get around this?  I want to use the File
Data Source feature so I don't have to set up each individual computer with
an ODBC connection.  Maybe some code in the startup of my database
application?