Urgent questions

[Bee]

Hi folks

I wonder if you can help with these two questions please?

To compact and repair a FE, does each client have to be logged off or doesn't it matter?

What's the difference between make database replica and make database backup in access?

Thanks a lot,
B

 

[Zigzag]

Hi B,

In response to your first question the answers is no it doesnt matter, each client does not have to logged off.

As for the second question i will have to leave that for someone else to answer as i never use replica or backup, I use VBA to create backups by transfering tables etc.

Garry

 

[Bee]

That's excellent! Thanks Garry.

 

[boblarson]

A Replica is a special database which Access tracks all changes and then when the database is synched with the master it will make those changes in the master and then, when the other replicas synch, they will be propagated to the other replicas as well.

Replication should ONLY be used with backend databases (tables only) as using it with frontends or full databases will almost assuredly at some point cause corruption as it is not designed for propagating design changes among objects other than tables.

A make backup would be just that, a copy of the current database file that you are in. If in the frontend, it will make a copy of that file, if in the backend it will make a copy of that file.

 

[Bee]

That's great information. Cheers. I am more interested in the Backup in this case so I will go for that.

 

[Oldsoftboss]

http://www.access-programmers.co.uk/forums/showthread.php?t=125828

Dave

 

[Oldsoftboss]

PS.. Bee

You would be better titling your post "A couple of questions" rather that "Urgent"

Folks that have been on this forum a long time and see "Urgent" think - another school project running late, and don't bother even having a look.

Cheers,

Dave

 

[Bee]

Haha, that's true. It's been a while between me and school projects! I did write urgent beause I was quite desperate to know the answers as I was writing a user manual and did not find anything exactly about that in Google! The DB is installed in the client's site now, so no more urgency and panic for the near future at least!