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

New database template

P: 56
Is it possible to create our own database template... in access
for example i created one pay slips database which is useful for all the branches of our firm... and i want to create it as template .. are there any possibilities for it..
Oct 9 '07 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 3,072
Just create your database and give the other companies a copy.
The only thing to do is to "split" the database in a front-end and a back-end. (See Tools/Database utilities/Split database manager)
This will make sure that the data is stored in a different .mdb and thus you can create new forms and reports and distribute only a new frontend, leaving the data of the companies "untouched".
Only when table changes are needed, the distribution will be more work.

Getting the idea ?

Oct 9 '07 #2

P: 56
i tried to split the table but the main file is not working ... only tables are appearing in splitted file
Oct 10 '07 #3

Expert 2.5K+
P: 3,072
The split's objective is to have the tables (and only the tables) in another database.
Now you can change the forms/reports/etc. without having to bother about the actual data.
Perhaps reading the F1 file on splitting databases might give some more insights.

Oct 10 '07 #4

P: 56
OK thank you.. i wil try
Oct 10 '07 #5

Post your reply

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