MartyConnelly
martyconnelly at shaw.ca
Mon Jan 3 21:48:42 CST 2005
Just a guess maybe a missing cdx file from directory FoxPro tables can consist of several files. The table itself is MyTable.dbf. If it has a memo field there will be a MyTable.fpt file present. If it has an index there will be a MyTable.cdx file present. Rocky Smolin - Beach Access Software wrote: > Marty: > > There is a .dbc file which I pointed to at the request of the Connect > dialog box. Seemed to work except that not all of the .dbf table > showed up for linking. > > Rocky > > ----- Original Message ----- From: "MartyConnelly" > <martyconnelly at shaw.ca> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Monday, January 03, 2005 6:09 PM > Subject: Re: [AccessD] Reading FoxPro Tables > > >> Check if you have a .dbc file (metatable file) that incorporates the >> free table directory. >> Try linking to that. It's existance is dependant on version of Foxpro. >> the OLE DB Provider may not work without it. >> >> I haven't tried it not sure of syntax but just point to dbf table >> directory >> >> oConn.Open "Provider=vfpoledb;" & _ >> "Data Source=C:\vfp8\Samples\DatadbfDir;" & _ >> "SourceType=DBF;" & _ >> "Mode=ReadWrite|Share Deny None;" & _ >> "Collating Sequence=MACHINE;" & _ >> "Password=''" >> >> Rocky Smolin - Beach Access Software wrote: >> >>> Marty: >>> >>> I was hoping to link to these table inthe database container and >>> avoid the coding. >>> >>> But if I hafta, I hafta. >>> >>> Rocky >>> >>> ----- Original Message ----- From: "MartyConnelly" >>> <martyconnelly at shaw.ca> >>> To: "Access Developers discussion and problem solving" >>> <accessd at databaseadvisors.com> >>> Sent: Monday, January 03, 2005 4:42 PM >>> Subject: Re: [AccessD] Reading FoxPro Tables >>> >>> >>>> Instead of using the ODBC how about "Microsoft OLE DB Provider for >>>> Visual FoxPro 8.0" , the ODBC is good only up to Visual FoxPro 6.0 >>>> 9.0 is out in Beta. >>>> >>>> Microsoft OLE DB Provider for Visual FoxPro 8.0 >>>> It should be backward compatible. How far back I dunno. >>>> The Visual FoxPro OLE DB Provider is supported by OLE DB System >>>> Components as provided by MDAC 2.6 or later >>>> Mdac 2.6 is installable by Win98 SE + >>>> However MDAC 2.7 is Win2000+ >>>> >>>> http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en >>>> >>>> >>>> Sample connection string >>>> >>>> OLE DB Provider for Visual FoxPro >>>> oConn.Open "Provider=vfpoledb;" & _ >>>> "Data Source=C:\vfp8\Samples\Data\myVFPDB.dbc;" & _ >>>> "Mode=ReadWrite|Share Deny None;" & _ >>>> "Collating Sequence=MACHINE;" & _ >>>> "Password=''" >>>> >>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp >>>> >>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/foorivisualfoxprodataaccessusingoledbprovider.asp >>>> >>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgtskaccessingvisualfoxprodatainmicrosoftofficexp.asp >>>> >>>> >>>> Visual FoxPro 9.0 Beta >>>> Download for Microsoft Visual FoxPro 9.0 public beta. Good until >>>> March 31 2005 >>>> >>>> http://www.microsoft.com/downloads/details.aspx?familyid=23fbc57b-93b0-4cb7-b376-53ca04fca159&displaylang=en >>>> >>>> >>>> Rocky Smolin - Beach Access Software wrote: >>>> >>>>> Making some progress. I downloaded from: >>>>> >>>>> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx >>>>> >>>>> Now I can link some of the tables by selecting ODBC databases, >>>>> then in Select Data Source select Visual FoxPro Database, in the >>>>> Configure Connection dialog select Free Table Directory, browse to >>>>> the directory containing the free tables, clock OK then I get a >>>>> list of tables but not all of the .dbf tables are in the link list >>>>> that are in the directory. >>>>> >>>>> So I'm getting closer. >>>>> >>>>> Do you know of some reason why all of the tables wouldn't appear >>>>> in the link tables list? >>>>> >>>>> Regards, >>>>> >>>>> Rocky Smolin >>>>> Beach Access Software >>>>> http://www.e-z-mrp.com >>>>> 858-259-4334 >>>>> >>>>> >>>>> ----- 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 3:14 PM >>>>> Subject: Re: [AccessD] Reading FoxPro Tables >>>>> >>>>> >>>>>> 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 >>>>>> -- >>>>>> AccessD mailing list >>>>>> AccessD at databaseadvisors.com >>>>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>>>> Website: http://www.databaseadvisors.com >>>>>> >>>>> >>>> >>>> -- >>>> Marty Connelly >>>> Victoria, B.C. >>>> Canada >>>> >>>> >>>> >>>> -- >>>> AccessD mailing list >>>> AccessD at databaseadvisors.com >>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>> Website: http://www.databaseadvisors.com >>>> >>> >> >> -- >> Marty Connelly >> Victoria, B.C. >> Canada >> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > -- Marty Connelly Victoria, B.C. Canada