News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, July 11, 2005

Split or not to split

Today I had a discussion in Microsoft Public Newsgroups about "how to backup a database where tables and forms and everything in one file?" Good answer is "spit your database into Backend (BE, database with tables) and Frontend (FE - database with the rest)". I know the only one reason to have everything in one file - when you develop database in early stage and you are the only user of it. In this case you can make backup any time you like, no problem. But once you gave it to users to enter data - you have to split it. Then I would recommend making a backup every day, at first start, when nobody logged into. In my routine I first make a copy of BE to specified folder, keeping 3 last backup and deleting older (by default) and then I make a compact of BE. I am planning to publish my routine soon, hope it will help somebody also.
Some useful links on splitting databases you can also find at Jeff Conrad site:
Database Splitting Information


Anonymous Anonymous said...

Hi Alex,

Yeah, that would be nice. Let me know when you have the routine done, if you'd like me to test it, I'd be glad to.


9:24 PM  

Post a Comment

<< Home