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