Don Leverton wrote:
Hi "Salad",
These are just random thoughts, as I have never personally encountered this.
Have you looked in the OBDC / OBDC32 section of the Control Panel?
That may provide you with some insight as to what you're missing, or don't
have configured perhaps?
Don
Hi Don: Let me tell you how I do this. I could easily be doing
something wrong. Opening my links on my development machine are
atrociously slow. I have a 2.6 gz machine, 1 gig memory, lots of disk
space, Access2000 has sp3 installed.
I get the ODBC administrator open. I click System DSN. I click Add. I
then select the VFP driver and click Finish. I enter Test for both
Data Services name and description. I select FreeTable, not DBC (VFP
can be a DBC or use dbf tables) and enter the path C:\Test as the path.
I click Options; machine collate. The Null, Deleted, and Fetch data
in background (defaults) are checked. I click Finish. This is real quick.
I have a customer table with 167 records. I open up Access2000, click
File/GetExternalData/Link, select ODBC, select Test dsn. After about 5
seconds (slow) the tables in that directory appear. I select Customer.
After 5-10 seconds it presents me with a list of fields that make the
unique index key. I select CustomerID and OK. I now have a link.
When I click on the customer table and press Open in A2K it takes about
1 minutes 15 seconds to open it. I have AutoCorrect set off.
I'm wondering at this point if I can even work on this application. On
my clients machine it is not as slow as mine. It takes about 1-3
seconds to open the customer file and maybe 5-10 to open the orderlog
file. I have not even attemped to open it on my machine as it has 58K
records.
If I open up the customer table the primary key is type decimal. What I
find intriguing is that ALL text fields are set to Required = Yes, Allow
zero length = Yes.
I imported the data instead of linked to it and pulling up the records
is instantaneous....as expected. I'm pulling my hair out on this
on...what little hair I have. If I use A97 and the ISAM driver, pulling
up the tables is instantaneous.
Can you see anything that I am doing wrong?