Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Jan 3 16:43:59 CST 2005
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 >