By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,680 Members | 1,578 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,680 IT Pros & Developers. It's quick & easy.

FoxPro, Access, and ODBC linking question

P: n/a
My operating system is WinXP Pro. I have 1 gig of memory and the chip
is an Intel Pentium 4.

I am using Access97. A table has been supplied to me from an external
source createdc from Visual FoxPro file, version 6.0.

If I connect to it using File/GetExternalData/Link and select FoxPro as
the file type and it links OK. I press Open and the table opens just
like an Access table...quickly. There are 557 records. The problem is
that I can't change the data in the table. The status bar displays the
message "Recordset not updateable."

So I tried ODBC. I selected the FoxPro driver, set Fetch Data In
Background off (doesn't matter if it's on) and it links OK but is
S-L-O-W!!!! I mean, 2 minutes to open up 557 records. Takes at least 2
minutes to get to the last record. Takes nearly a minute to close the
datasheet window once it has been displayed.

The driver I am using is located in the System32 directory and is called
VFPODBC.DLL. The version number is 6.1.8629.1 The file data is
12/7/1999 at 4am and the size is 955kb.

Am I missing something with this DLL? Does it have to be registered (it
appears once in Regedit with the status bar displaying
MyComputer\Hkey_users\"string"\Software\ODBC\ODBCI NI\VisualFoxTables)
Does this sound right? If you personally link to VisualFox files, is
the ODBC version correct?

Is it possible that having 1 gig of memorty overwhelms Visual FoxPro?

I had Office 2000 on my computer but I removed it. That did not solve
the problem.

Any suggestions? If you require more info, let me know.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.