Results 1 to 6 of 6
  1. #1
    sbeardsley51 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    3

    Individual Database


    I have created a database for contacts in my industry. I have a few individual coworkers that would like to use it as well. Everyone has their own set of contacts. They are not shared.

    What is the process to make this happen?

    Or can it be done?

    Steve

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    Can you give us a little more info about:
    -your industry
    -contacts
    -any relationship between your projects and coworkers ?

  3. #3
    sbeardsley51 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    3
    MLM Industry
    Everyone has their own contacts.
    No relationship between coworkers what so ever.
    The database is a standalone unit that only that person uses it.

    Does that help?

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    No summary of info from coworkers? Many orgs use summary statistics to compare individual performances and company direction/priorities.
    It seems MLM (multiLevel marketing is the business).
    So if each worker/coworker has a unique set of products and "potential clients", then a generic model
    that you can populate with worker specific needs/data may be a feasible approach.

    A clear description of the processes involved for 1 or 2 coworkers may help others with forming a response.
    Good luck with your project.

  5. #5
    sbeardsley51 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    3

    Talking

    Non of the people are realted in any way to each other. So I created a database for my business. Got it working correctly.

    1.Copied it as a new file, to have blank tables, for others to fill out.
    2.Exported my tables to excel.
    3.Cleaned out all of my information.
    4.imported the clean tables back into the access database.

    But, when I try to open any of the forms it still tries to use my database tables and file location.

    I split the database so that I have a back end and front end. Thought that would be easier to update.

    How do I remedy that issue.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    Since you have split the database, the "real tables" should be in the Backend database. If there is no data in those tables, then you'll have to sign on to the backend database and import the data to those tables.
    Then, in your front end database, you would use the linked table manager to link to the Backend Tables.
    Search youtube for examples.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-04-2017, 06:54 AM
  2. Replies: 7
    Last Post: 08-29-2014, 12:02 PM
  3. Replies: 1
    Last Post: 08-28-2013, 02:27 AM
  4. Registration Database with Family and Individual Tables
    By mcbowlby in forum Database Design
    Replies: 2
    Last Post: 08-18-2012, 05:58 AM
  5. Replies: 3
    Last Post: 01-25-2011, 09:50 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