Adding a second Database to my exisisting

[BigMac4]

Hi all

I have recently created a database for my department at work and my boss has asked me to make ones for the other departments in our company, they would be identical tables and forms ect, but he wants them to run on the same database not on seperate ones is there anyway i can copy/paste my tables, forms, reports and switchboards and add it to mine and just change a few names around or would this just really confuse Access. I dont really want to have to recreate every table and form again in my database.

By the way just so you know my database is empty at the moment so no information in it yet if that helps.



cheers

Mac

[A S MANN]

you may use same back end DB and create a copy of front end for another department. Filter the data in frnt end DB or else take user to another forms by defining users in log in forms
Hope this is useful to you.

[orange]

Mac,

You need to do some research on Data Management . The last thing you need is a bunch of separate access databases maintained and used by different organizations and people within your company - all thinking they are working efficiently, together..

Here is a starting link http://en.wikipedia.org/wiki/Data_management