Link Table to dbf files

[sapta]

need expert help ,

How to link dbf file, so we can append/update/delete data
to linked table using access 2000(why always read only?)

if using access 97 we can append/update/delete these the
linked table.

thanks in advance.
sapta

 

[Albert D. Kallal]

You must have jet4.0 SP5 or later to udpate Dbase,

OR you muse use the
the Borland Database Engine (BDE) is installed

http://support.microsoft.com/?id=230125

If you are using a97, then you can open the files and import, or even link
to the file. You can even update the file.

In a2000, you need have installed jetsp5 or later to update. You can link
and import with pre jetsp5, but you need later sp5 or later to update with
jet4 in a2000. We are now at sp8...so any update you run to JET should allow
you to update.

For FoxPro files in a2000, you need to use the ODBC driver for FoxPro which
can read/write those files.

For the latest ODBC driver for FoxPro and Visual FoxPro:
http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp