Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Wed Feb 16 05:27:43 CST 2005
I don't wanna go into Jet syncing because I hope to rewrite my application to an Access Project+SQL server somewhere this year if I find a month of free time :-) When rewriting I would the syncing functionality build into SQL server. As far as I know Jet syncing will generate random ID's and I want to avoid that. thx -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, February 15, 2005 6:18 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Knowing when DB is read-only Hi Erwin: I am not sure of all the issues with copying a file while in use. Some of the better backup software solutions can it without being affecting the state of the file or being unable to backup the file. Have you tried using master and replicas to sync a file backup? I had a system a few years ago that used this method, designed for a couple of sites and to transfer data to the laptops for off site work. As an extra benefit, there were plenty of backups around and an incomplete database could be synced up in about 30 seconds and never any issues with locked records. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Tuesday, February 15, 2005 2:29 AM To: Access Developers discussion and problem solving Subject: [AccessD] Knowing when DB is read-only Dear group I have a backend MDB database that is about 677MB in size and growing.... For reasons of fast recovery this file is not only backuped on tape several times a day, but also copied several times a day to my notebook computer (using briefcase but I don't use syncing at datalevel, just file level). Because copying this file takes about a minute or so, it seems that the database get's in a read-only state. I noticed this because on my server two applications run every 2,5 minutes dooing some stuff on it, but during the filecopy I get "No updateable query" errrors. So the question is, how can I get the state of the database during opening so I can leave straightaway the application on the server when it notices that the backend is read-only or whatever state while copying the file to my notebook??? Greetz Erwin Craps Zaakvoerder www.ithelps.be/onsgezin This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com