Multiple UNCs in Field

[arbytech]

Hi everyone!

I have an Access database that holds information for a VB6 program to read. One of the fields holds UNC info for a file transfer. Is it possible to add two different UNCs in the same field? The files that get transfered need to go to two different servers now.

Thanks,

RB

 

[jrbarnett]

If the field allows enough space, you could put two different UNC paths in (if it is a text field). However, if the file copy is automated from the database application, the code will have to be rewritten to take account of the changes.
Its probably easier in the long run to add another field with a second location in.

John