By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Automatic back up after exit from db

P: 8
Hello, once again :)

I've just implemented a database with the view that several users can use it simultaneously. I've hit two problems (1) despite the database being in a public folder, it isn't allowing other users to access it and (2) when the database is exited it automatically backs up ... so by the end of a day there could be up to 20 backed up copies. I'm wondering whether this is to do with the securities set by the organisation because I didn't have these problems when I was designing it on my home computer ... or is there something I've missed??? I'm using Access 2000. Also, I have a mouse scroll so I have turn to mouse wheel off ... could this be the cause of the problems??

Any assistance would be greatly appreciated.

Kind regards
Kate
Jul 7 '09 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
@kate2272
Have you split your database? In a multi-user environment the database should split into a front end (with forms, reports, queries, etc) and a back end (with tables.) Having an un-split database on a shared is a sure fire way to generate all kinds of problems including chronic corruption. Access can do this for you automatically.

A copy of the front end should be on each user's PC.

A single copy of the back end should be on the shared drive.

@kate2272
I know of no native facility in any version of Access, certainly not up thru 2003, that allows for the automatic backup of a db on exiting. There has to either be code in the database for doing this or, I suppose, maybe your IT administrative people have something set up in your network that does this.

What exactly does "implemented" mean in this context? Did you develop the db yourself, or was it developed by someone else and you're simply getting it up and running? IF the former, did you do it from scratch or did you use another database as a template? I ask because that may be the source of the code that is backing up it up.
Jul 7 '09 #2

P: 8
Hi Linq,

Thanks for answering my query. No I haven't split the database ... not quite sure how to do that - is that in tools then database splitter??

It is a database that I designed from scratch, so there aren't any codes in there that I haven't put in ... the organisation is checking with there IT section if the automatic backup is due to their settings ...

Thanks once again for your help

Kind regards
Kate
Jul 7 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.