>Hi Barry ----
>
>Find the .MDB file and zip up the whole darn thing (if possible). It's better to have a copy of the whole database where possible until you understand the relationships within the schema: You may break some relationships with a "COPY NEXT 500" type approach.
>
>
>Then back when you have access to VFP, create a DSN and link to the tables via VFP remote views, as John Peterson pointed out.
>
>
>>
>> I have a strange request to ask the forum. I am a VFP consultant. I have a client who has a Visual Basic Application that he wants me to convert to VFP. I am not yet proficient in VB but am learning rapidly. My problem is this:
>>
>> I have to view their Access files and create a copy of some of them to transport back to my office. In VisFox, this is easy. I'd do it in the Command window. How can I do this in VB? Is there COPY NEXT 500 type instruction, etc. Also, is there a BROWSE type command I can use to view Access files? IS there even a Command Type window?
>>
>> Sure could use some help here.
>>
>>
>>TIA
>>
>>Barry
Hi John,
Thanks for responding.

The client's data is extremely sensitive and confidential. They will not permit me to copy the entire Access DB (it contains over 150,000 records). Don't know how to do a partial zip copy. Weird situation, isn't it. Any more ideas?

TIA
BArry