Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Jan 4 09:57:19 CST 2005
I get two terse responses from the linker depending on which table I try to link: 1) The Microsoft Jet database engine could not find the object 'hreceived.DBF'. Make sure the object exists and that you spell its name and path name correctly. (Although I picked it off the list of tables, so I know it's there and spelled correctly), and 2) External table is not in the specified format. (Deep sigh). Well, it may be moot anyway. Client has discovered a third party query and reporting tool for FoxPro, looks kind of like Crystal reports from the web site, and they can use that to extract data to shoot over to an Access-based business analysis and reporting module which they want me to write. Still, I'd like to figure this one out. They told me that the guy who wrote the system is a one-man band, and very hard to get ahold of. Rocky ----- Original Message ----- From: "William Hindman" <dejpolsys at hotmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, January 03, 2005 11:18 PM Subject: Re: [AccessD] Reading FoxPro Tables > ..did you select dbIII as the file type? ...some pre VFP dbfs will not > show unless you ask to see the dbIII ones. > > William Hindman > > > ----- Original Message ----- > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Monday, January 03, 2005 9:48 PM > Subject: Re: [AccessD] Reading FoxPro Tables > > >> 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 >>> >> >> -- >> 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 >