To Replica or Not to Replica

[bonekrusher]

Hi All,

With the help of many people on this forum, my database is coming along well (Thank you!). My DB will end up on a server where it will be accessed. My question is; should I use the replica function, or back up the file every day or so.

The database I am replacing has been a replica and it always looses data. I am not sure it is because its a replica or not.

Any thoughts?

Bones

 

[RuralGuy]

It is my understanding that the only reason to replicate a db is in the situation where it is difficult or impossible for everyone to get to the BackEnd. As long as everyone that uses the db can get to the BackEnd then a reliable backup system is all that is required. Depending on how much data is changing you may want to consider backing up more often than once a day. The decision question: How much data can you afford to loose? You are only covered up to your last backup.

 

[bonekrusher]

Thanks for the input. The data exchange is not that heavy so loosing a day or two will not have an impact. Our exsisting database, that is a replica is a lot of maintenance.

 

[RuralGuy]

Do you know why they elected to replicate the Database? I can't believe it was just for backup purposes! Where is the Master?

 

[bonekrusher]

The Master is on the server in another folder. I asked him why he was using a replica and he said because many people needed to access it over the network.

 

[RuralGuy]

That does not sound like a good enough reason to replicate. Is he afraid if too many users are on the db at one time it will corrupt? Access can handle up to 255 concurrent users however I've heard that system performance degrades when you get over 50 concurrent users. Here's a link I believe your IT dept needs to read: Microsoft Access Performance FAQ

 

[bonekrusher]

Thanks, My thoughts are that he was given bad information. I did some research last night on the subject. I will back the DB often. I need to search the forums to see how I can import the tables for back up with a click of the button using VB. What do you think?

Bones

 

[RuralGuy]

There is no reason to import when the system has been split into FrontEnd and BackEnd! Split your MDB file into data and application

 

[bonekrusher]

Thanks Again, I'll do some research tonight. That might be the way to go.

Bones