Results 1 to 3 of 3

Thread: Shared Excel Database Advice
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2016
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Shared Excel Database Advice

    Hey all, I am seeking some general advice from all those that have gone before me. I work in a small office with REALLY slow computers. I am working on a log that tracks work flow in the office. All should be able to see the current data and all should be able to update it as they complete work. I first tried a shared file. Then I ran into limitations (macros and tables). Then I tried a data connection and I am running into troubles with that too (updating and connecting in order and transferring data back and forth is getting complicated and glitchy). So I am looking at possibly doing a back end excel file with just the data and front ends that connect to it and update it. After all this trial and error am I finally on the right track? Is there a better and easier way to do this ?

    Additionally, we do have OneDrive in the office. If I use that do I still need to "share" the file or does that happen automatically with OneDrive? Can more than one user open and use the backend data file at a time?

    Thanks for all of you experience and advice in advance.
    Last edited by Kevin0427; Aug 16th, 2019 at 09:43 AM.

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,794
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Shared Excel Database Advice

    Personally, I would use Access. If you split the database to have a single central back-end that holds all the data, and front-end that you share with users (each user has their own copy), then multiple users can be accessing/updating it at the same time without issues.

    Of course, that depends up on a few key items:
    - Having Microsoft Access
    - Having someone knowledgeable enough to build the database in Access

    Access is not something that you can just pick up and create a well-designed database, if you have not had prior training/esperience in. There is a learning curve to it, and some "rules" that you should follow (i.e. "Rules of Normalization").
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Mar 2016
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Shared Excel Database Advice

    Quote Originally Posted by Joe4 View Post
    Personally, I would use Access. If you split the database to have a single central back-end that holds all the data, and front-end that you share with users (each user has their own copy), then multiple users can be accessing/updating it at the same time without issues.

    Of course, that depends up on a few key items:
    - Having Microsoft Access
    - Having someone knowledgeable enough to build the database in Access

    Access is not something that you can just pick up and create a well-designed database, if you have not had prior training/esperience in. There is a learning curve to it, and some "rules" that you should follow (i.e. "Rules of Normalization").
    I know access is better this is exactly why I am not using it. Learning curve to steep for this project.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •