Steve --
I was told recently that VFP gets "confused" when you have two tables open that have the same filename and database container names (even if in different locations). Look in the Microsoft KB for more info.
>The error message I get is "File access denied."
>
>Here is what I'm trying to do:
>
>I have two PCs, each running Visual FoxPro. They have duplicate database structures with identical DB and table and field names. I update a table on PC #1 and pass it over to PC #2 so PC #2 can update his table to match PC #1's table update, but since the DBs, tables and field names are the same, I get the error whenever I try to OPEN or USE the PC #1's table and APPEND FROM into PC #2's table with the same name.
>
>How can I get around this problem? Is there a way to disassociate the PC #1 table from it database so the USE or OPEN will not cause a "File access denied." error?
>
>THANKS for your help. I think this is Deja Vu for me, but I am drawing a blank this afternoon.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05