error vfp 9.0 tables linked to MS Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pabloov - 11 Jul 2008 12:08 GMT

I have a visual fox pro database file where a few of the tables are linked to
a Microsoft Access 2003 database. I only use this link to retrieve data from
the vfp database. These linked tables works fine, but there are only a vfp
table that doesn't work, i can't link this table.

This table have a particularity, it has an index tag that calls a FoxPro
function DELETED(). This is the problem. If i delete this call, the table
linked fine.

I use the OLEDB to connect VFP 9.0 and Acess 2003

I read this article about it:

http://support.microsoft.com/kb/188401/en-us

There is a way to fixit this problem?.

Thanks in advance.

Pablo Ortiz.

Reply to this Message

Craig Berntson - 11 Jul 2008 15:49 GMT

Did you actually read the KB article you referenced? It gives you two ways
to fix the problem.

Signature

Craig Berntson
Microsoft MVP

-------------

>I have a visual fox pro database file where a few of the tables are linked
>to
[quoted text clipped - 18 lines]
>
> Pablo Ortiz.

Reply to this Message

pabloov - 14 Jul 2008 18:39 GMT

of course, i read the article but i can't modify the database. I need a
solution without modify the database. i'm not the owner of the database. A
lot of process uses the table and if i moddify the table maybe the process
doesn't work.

thanks.

> I have a visual fox pro database file where a few of the tables are linked to
> a Microsoft Access 2003 database. I only use this link to retrieve data from
[quoted text clipped - 16 lines]
>
> Pablo Ortiz.

Reply to this Message