[AccessD] Relinking Foxpro Tables

Hi David

Yes, but you are using ODBC. Access can link to dbf files directly at
least for dBase x, but perhaps not for FoxPro, but you could try that.

Feel free to mail a sample file.

/gustav

>>> newsgrps at dalyn.co.nz 25-02-2005 20:15:50 >>>
Gustav,

The files are Visual Foxpro dbf files.

Tried replacing CurrentDB with no luck.

Also tried delete and relink but also had the same result.

Have even tried ADO instead of DOA with the same result.

The problem seems to be with Access not actually recognising the new
links 
until Access is closed and opened again.  Maybe it is something to do
with 
the connection code.

The offer is still open for me to send a sample file for others to
test.

David

At 25/02/2005, you wrote:
>Hi David
>
>I have no firm advice on this. But you could try two things.
>First, can't you link dbf files directly (dBase x files)?
>Second, what happens if you replace CurrentDb with DBEngine:
>
>      Set mdb = DBEngine(0)(0)
>
>If that adds nothing, you could try to not use RefreshLink but delete
>the tables and relink them.