A Follow-on to using ADODC and Access 2000. Want to copy table. 1

[THOMASNG]

This is really a follow-up question.
With much assistance, I was able to get a VB6 project that used ADODC to connect with and manipulate a data-table
that I'd created using ACCESS 2000. However, everything was on the same computer.
I have now relocated the VB6 project with ADODC to a different computer. The original computer still has ACCESS
2000 and the data-table that I wish to manipulate (but this time from the new computer.)
The original computer's network name is BUILDWINS2000.
I've used a PC-to-PC serial cable to connect its Com1 with
the new computer's Com3. I have verified that the cable
and these sockets do (indeed) work for I/O, via HYPERTERMINAL.
When I tried changing the connection path to: "Buildwins2000\c:\Access VBA Practice Files\CCRTable1",
I received the error message: "Improper Provider ....".

 

[johnwm]

Use a UNC.

\\Buildwins2000\newsharename\Access VBA Practice Files\CCRTable1

where newsharename is a shared folder containing the Access VBA Practice Files folder
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[THOMASNG]

Yup! First time did the trick! Have a star!