I've got an app I've got to stick with an Access front-end that has > 50 people on it. It depends on what you want to achieve, not that I'm saying it's good, and that replacing it with a .NET equivalent wouldn't be better, but it does what it needs to.
> > Whenever you try scaling Access, it becomes ugly and fragile. But it's > nice for a single user app. > > >> Best of luck >> Martin >> >> -----Original Message----- >> From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] >> On Behalf Of Les Hughes >> Sent: Tuesday, 7 September 2010 12:33 PM >> To: ozDotNet >> Subject: Access Database Replication >> >> >> Hi All, >> >> I've got a legacy MSAccess app in VBA which is been used at two separate >> office locations (Melbourne & Singapore), with two separate copies of >> the database. >> >> There is a table with 5,000 rows in it (about 30 columns) which has >> inserts/updates at both offices, and we were looking for some way to >> propagate the changes. >> >> Ideally, we would either migrate the app to .NET/SQL Server (which would >> be fairly expensive... management say 'grrr'), or use RDP and having the >> app on one computer. (which is also for some reason is also 'grrrr') >> >> Based of my knowledge of access/mdb's, there are no triggers, meaning >> the only way we could really track updates is to modify the Access forms >> to update a flag column with a datetime or something similar, and then >> have a batch process move updates every now and then. >> >> This idea seems dirty to me because if someone changes with the tables >> directly, or there are updates around the same time it becomes quite >> messy in keeping a clean dataset/dealing with race conditions/etc. >> >> Long story short: >> >> Has anyone dealt with something similar to this before? Any ideas would >> be appreciated. >> >> Thanks heaps, >> -- >> Les Hughes >> l...@datarev.com.au >> No virus found in this incoming message. >> Checked by AVG - www.avg.com >> Version: 9.0.851 / Virus Database: 271.1.1/3117 - Release Date: 09/06/10 >> 16:35:00 >> >> > > > -- > Meski > > "Going to Starbucks for coffee is like going to prison for sex. Sure, > you'll get it, but it's going to be rough" - Adam Hills >