Results 1 to 3 of 3
  1. #1
    BigMac4 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    30

    Adding a second Database to my exisisting

    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

  2. #2
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    164
    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.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 28
    Last Post: 04-24-2012, 10:14 PM
  2. adding images & documents to database
    By ksosnick in forum Database Design
    Replies: 2
    Last Post: 10-26-2011, 01:48 PM
  3. Adding Hyperlink to database
    By JeffG3209 in forum Access
    Replies: 3
    Last Post: 05-05-2011, 04:47 AM
  4. Replies: 1
    Last Post: 11-04-2010, 12:57 PM
  5. Replies: 0
    Last Post: 06-19-2007, 09:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums