how to copy an access database with it loaded

[Hcoms]

Hello,

How is it possible to copy an open database to make a backup. For example
when the user goes to close the database a backup is made.
I have tried using , in vb, filecopy( ) , however it comes back with a file
permissions error because the file i am trying to copy ( i.e. the database
that the code is executed from) is open.

Cheers

 

[John Vinson]

How is it possible to copy an open database to make a backup.

It isn't, at least not safely. Any open database is likely to be in an
inconsistent state (if the user/one of the users is updating
something); a copy runs a great risk of being corrupt.

It's best to make your backups (by simply copying the .mdb file) when
everyone is OUT of the database and Access is not running. You can
create an icon to run a simple batch copy.

 

[Guest]

Pretty, suchesfull family from Dominica (Caribbean islands) search nanny for
care of my daughter, age 5 year. Salary 1200.00 US dollars per month,
separate room

The schedule of work: 8 hours per day, except Sunday.

Applicant age: 27-50

(e-mail address removed)

 

[Dirk Goldgar]

Pretty, suchesfull family from Dominica (Caribbean islands) search
nanny for care of my daughter, age 5 year. Salary 1200.00 US dollars
per month, separate room

The schedule of work: 8 hours per day, except Sunday.

Applicant age: 27-50

Must possess strong database skills. Referential integrity required.

 

[Ken Snell]

Must possess strong database skills. Referential integrity required.

and capable of being subclassed.

 

[Van T. Dinh]

Very "suchesfull" with spelling as well.