This is an extension of previous question about syncronizing server and laptop DB. The previous comments were very helpful and appreciated. I ended up using an sql created arrays from the laptop DB files and then appended from the array to the server DB files.
My new question relates to copying the data folder from the server copy to the laptop so I can go out a roam with an updated version.
I sign on from laptop and connect to the data folder on the server. My routine to upload the data file from the server is briefly...
CLOSE DATABASES ALL
COPY FILE "C:.(serverDB)..\DATAFOLDER" TO [\\.(laptopDB)..\DATAFOLDER]
OPEN DATABASE(laptopDB)
... seems to copy all the data tables in the folder without problem until the error 'file in use occurs'. I believe this occurs when it tries to copy the DBC.dbt file. The copy process moves thru the files alphabetically and ends at this point.
Is this what is happening and how can I work around this? The DBC file must be in use and though I have close the databases/tables ... the DBC.dbt remains in use. For speed reasons, copying the entire folder is much faster. Down the road what problems will I have doing this while others want to use the server DB. WIll they have to close out before any uploading in this manner?
I very much appreciate the help you all have given in the past. Thanks again in advance. hunter
My new question relates to copying the data folder from the server copy to the laptop so I can go out a roam with an updated version.
I sign on from laptop and connect to the data folder on the server. My routine to upload the data file from the server is briefly...
CLOSE DATABASES ALL
COPY FILE "C:.(serverDB)..\DATAFOLDER" TO [\\.(laptopDB)..\DATAFOLDER]
OPEN DATABASE(laptopDB)
... seems to copy all the data tables in the folder without problem until the error 'file in use occurs'. I believe this occurs when it tries to copy the DBC.dbt file. The copy process moves thru the files alphabetically and ends at this point.
Is this what is happening and how can I work around this? The DBC file must be in use and though I have close the databases/tables ... the DBC.dbt remains in use. For speed reasons, copying the entire folder is much faster. Down the road what problems will I have doing this while others want to use the server DB. WIll they have to close out before any uploading in this manner?
I very much appreciate the help you all have given in the past. Thanks again in advance. hunter