I am importing data from FoxPro 8 tables into SQL Server 2005, using the
   Microsoft OLEDB driver for Visual FoxPro 8. The development
environment is VS2005, but that does not matter, it is the OLEDB
component behaviour I need to understand.

Occasionally I get a message "memo file invalid or missing" . In 7 it mostly
was easy to fix by
Use mytable
copy to temp

I am getting a number of these error messages thrown up by my application
which runs across our corporate LAN and has a dozen or so users online at
any one time.
Generally I buffer all the updates (mode 4) and rlock() whereever possible.

I have a table that I open in buffer mode 4.
I switch from my form to another form (changing to the parent forms
DataSessionID - don't know if this is technicallly correct).
I then append a new record to my table....I don't use TABLEUPDATE at this

first of all thanks every body for the past answers to my questions.
here is another question.(ASP -FoxPro 8)
I will change  foxpro ODBBC.dll  to OLEDB. the reason is ODBC dll is not
thread safe and causes IIS down. my point is "Is there any problem with

I am using VFP 7.0.  I would like to reorganize tables used in
point-of-sale database.  I want to simply move a record with all its
data within the same table. ie move record 3 to record 2.  I am sure at
this point I am doing the hard way be coping the dbf 3 time deleting

Wanting to know if it possible to set initial value typeN of a field in
record 1 and then increment each record of that field by 5.
exp
field

I have had a first go at using GenDBC (with
VFP9), supposedly as per help instructions.  
I have also had a search through archive newsgroup
stuff (I keep tons of stuff like this, sad isn't

Nov 10, 2005
Hi
I need to fill a cursor adapter on demand, maybe by clicking a command
button on the form.

I have received what I believe to be a backup of a FoxPro database.  I have
never worked with FoxPro but I'm pretty sure that this is what I received
because in Windows Explorer it says the file type is "Microsoft Visual FoxPro
table".  I have several .dbf files, a FOXUSER.dbf, ...

I am getting an error in a program written in VB6 when connecting to a VFP
free table directory. It works on the deveopment machine (XP Pro SP2) and
not on the server where the app is to run.
The (pertinent) code is as follows

I have a very large application developed in VFP. Currently I am using a VFP
database. I need to change the back end to a SQL server. I am using VFP grid
extensively in almost all programs. What would be the best way to switch to
SQL Server.

in vfp9 i want to append records from one file to another. I use the append
blank / replace method for this. There are 2.000.000 records to add. When i
try this, after a while i get the message file to big (or something like
that). When i look, my file is, indeed very big. When i ...

I am trying to assign a count into a temporary array. I want a unique
name because the function is actually a VFP9 DBC stored procedure, and
I want to be sure that the return value is unique to a given caller
(this is a heavy multiuser web app doing read-only against the DBC). I

Can anyone point me in the right direction of a method or product that would
be good for replication of a FoxPro database?  Replication needs to take
place between a server and a workstation if at all possible.
Thanks in advance for all the help!