Thanks for the reply. It made me realize the most simple answer. If I have mydbc with mytable in it locally and on the network I can simply do the following: USE :\mytable USE :\mytable ALIAS mytablemast upload/download to/from code
PS That sound you hear is my head banging against the monitor :-)
>It is possible to duplicate a view in a personnal DBC container created on the fly. >You are also able to open more than one DBC with the same name. It works for tables but not for views. > > >>I thought about this at the beginning of the project but views can only be taken OFFLINE by one person at a time and this is a multi-user system. IMHO, until OFFLINE views support multi-user it's basically useless. > >>>Have you consdered using OffLine Views? >>> >>>>I am working on an app that requires the EXE, Database and tables reside locally so the users can work on the system when not connected to the network. A copy of the Database and tables will reside on the network as well as a master data warehouse for users to upload/download to/from. >>>> >>>>I am looking for suggestions on the best way to do this. Can more than one DBC be open at the same time?
Colin Magee Team Leader, Systems Development Metroland Media Group Ltd. Mississauga, Ontario, Canada