Gary Kjos
garykjos at gmail.com
Mon Jan 3 17:14:52 CST 2005
Crud....how about this stuff. Might give you some clues anyway. http://support.microsoft.com/kb/q200393/ http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx http://www.experts-exchange.com/Databases/FoxPro/Q_20924251.html http://www.experts-exchange.com/Databases/FoxPro/Q_21046680.html http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm On Mon, 3 Jan 2005 14:43:59 -0800, Rocky Smolin - Beach Access Software <bchacc at san.rr.com> wrote: > Gary: > > Failed. It tells me to download the latest version of MDAC. SO I download > 2.8 and it tells me that it's incompatible with my current OS. > > So I go to the instructions to create the data source in the Control Panel. > But I get an error when I select the Visual FoxPro driver - tells me I must > install the current version of the visual FoxPro driver and directs me to a > page that no longer exists to get the update. > > Microsoft...gotta love 'em. > > Rocky > > ----- Original Message ----- > From: "Gary Kjos" <garykjos at gmail.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Monday, January 03, 2005 10:19 AM > Subject: Re: [AccessD] Reading FoxPro Tables > > > Didja look at this in the KB? > > > > "HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000" > > > > http://support.microsoft.com/?kbid=197893 > > > > > > On Mon, 3 Jan 2005 09:02:04 -0800, Rocky Smolin - Beach Access > > Software <bchacc at san.rr.com> wrote: > >> Drew: > >> > >> The first problem is that when I try to link tables, in the combo box > >> 'Files > >> of Type' there's no Fox Pro option, unlike my A97 install. There is ODBC > >> Databases. > >> > >> When I select that I get the Select Data Source dialog box. In the File > >> Data Source I have Microsoft FoxPro VFP Driver.dsn which I added but I'm > >> not > >> sure I did it correctly. Anyway, when I select it I get a fatal error > >> ODBC--call failed, Driver does not support this function (#0). > >> > >> And that's where I'm currently stuck. > >> > >> Rocky > >> > >> > >> ----- Original Message ----- > >> From: <DWUTKA at marlow.com> > >> To: <accessd at databaseadvisors.com> > >> Sent: Monday, January 03, 2005 7:05 AM > >> Subject: RE: [AccessD] Reading FoxPro Tables > >> > >> > What error message are you getting from Access when trying to import or > >> > link > >> > the data from the .dbf files? Do the .dbf files have coinciding .inf > >> > files? > >> > That's a file that Jet likes to put in there for Access to 'know' where > >> > the > >> > .cdx files are for the .dbf files. If there is a mapped drive letter > >> > in > >> > there, Access get's flaky, and doesn't ask for the location of the > >> > index > >> > files, it just assumes the worse and says it can't find them. > >> > > >> > Drew > >> > > >> > -----Original Message----- > >> > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > >> > Sent: Saturday, January 01, 2005 10:03 AM > >> > To: AccessD at databaseadvisors.com > >> > Subject: [AccessD] Reading FoxPro Tables > >> > > >> > > >> > Dear List: > >> > > >> > I have a requirement to get data from an application written in FoxPro. > >> > I > >> > tried linking the tables to an Access database but apparently I can't > >> > do > >> > that. I tried to set up the ODBC thingy in the ODBC manager but got > >> > stuck > >> > on the DSN field. Don't know what to put there. > >> > > >> > Can someone get me pointed in the right direction? > >> > > >> > Many Thanks In Advance and a Happy New Year To All, > >> > > >> > Rocky Smolin > >> > Beach Access Software > >> > http://www.e-z-mrp.com > >> > 858-259-4334 > >> > -- > >> > AccessD mailing list > >> > AccessD at databaseadvisors.com > >> > http://databaseadvisors.com/mailman/listinfo/accessd > >> > Website: http://www.databaseadvisors.com > >> > -- > >> > AccessD mailing list > >> > AccessD at databaseadvisors.com > >> > http://databaseadvisors.com/mailman/listinfo/accessd > >> > Website: http://www.databaseadvisors.com > >> > > >> > >> -- > >> AccessD mailing list > >> AccessD at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/accessd > >> Website: http://www.databaseadvisors.com > >> > > > > > > -- > > Gary Kjos > > garykjos at gmail.com > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com