Re: Link Visual Fox Pro 8.1 to Access 2003
From: Cheval (NoSpam.Ask_at_ForEmail.com)
Date: 03/16/05
- Next message: George Nicholson: "Re: Importing/exporting Tables From/To Txt/xls"
- Previous message: Bob: "RE: Missing File Types"
- In reply to: Cindy Winegarden: "Re: Link Visual Fox Pro 8.1 to Access 2003"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Mar 2005 21:30:08 GMT
We tried to create the ODBC data source as System but error always pops up
as well. Yeah, we thought of that, even logged the user out and back in with
the Administrator account, but still no luck. The weird thing is that every
machine outside this one site I've looked has the drivers are installed and
working properly. I jump into MS Access, get external data, select the
Visual FoxPro driver, select the folder with the data files and access
everything fine. It's only at this site where every computer, even the
server has the problem with the error. Someone suggested that the network
administrator had possibly over done some gpedit.msi settings which is
possibly not allowing the driver to fully install (even though it says it
had). He says no, the Administrator account has full everything, locked
nothing. I don't know...
I've gone though the machines here (off the problem site) trying to work out
what application installed the FoxPro drivers as none have FoxPro installed.
Do you know which app does? Even the WinXP laptop with Office 2003 as the
only app has it installed and working perfectly, yet their machines have
WinXP and Office 2003 and nothing.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>
"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:%23wo6KzkKFHA.2640@TK2MSFTNGP09.phx.gbl...
Hi Cheval,
Later versions of MDAC don't have the VFP ODBC driver.
Over the years, new features have been added to Fox data tables. The ODBC
driver is only compatible with features used in VFP6 and under, although
tables created with VFP7, 8, or 9 that don't use any of the new features
will still be compatible with ODBC. Since you've connected on other machines
then your tables must not have any of the new data features.
Stabs in the dark - Any chance your ODBC data source was set up as a User
data source rather than a System data source? Do you have administrator
rights to the data?
-- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com "Cheval" <Cheval@discussions.microsoft.com> wrote in message news:B0FF1B13-3AE2-40F5-ABC7-01DFBABC06E9@microsoft.com... > We are trying to create an ODBC connection to a Visual FoxPro database, > but > keep getting the error "You must first install the current version of the > Visual FoxPro ODBC Drive. Go to > http://msdn.microsoft.com/vfoxpro/downloads. > Select Product Updates, then Visual FoxPro ODBC Driver." > > We did that and it still comes up with that error. > > So, some background information: > OS: Windows XP Professional SP2 > Office 2003 Professional > Visual FoxPro database v8.1 > > We've also installed the latest versions of MDAC 2.5 (failed saying that > XP > already has it installed). MDAC 2.6, 2.7 & 2.8 (also failed saying that it > is > for a different version of windows). > > We can get access to the data via Excel (The connection created a .odc > file > and we can get the data fine) so it's like that driver is only half > installed. > > The wierd thing is that external to this site (at this site no machine can > get it to connect) there are two other machines which also *don't* have > Visual FoxPro installed connects perfectly. > > Does anyone have any ideas? >
- Next message: George Nicholson: "Re: Importing/exporting Tables From/To Txt/xls"
- Previous message: Bob: "RE: Missing File Types"
- In reply to: Cindy Winegarden: "Re: Link Visual Fox Pro 8.1 to Access 2003"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
