Results 1 to 5 of 5
  1. #1
    f15e is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2016
    Posts
    71

    Need advice on building DB for company

    Hi all.
    This is my first post on AccessForums. I need some advice on building an DB for a small engineering firm I work for. The DB will basically be for business development where contacts, resources, project info and so on, can be accessed while generating reports, etc. The DB will be located on a server allowing authorized users access to it. I am using Access 2010 for my DB and Visual Studio C# for the front-end. This is my first time building a DB and have a fairly decent understanding of it and have been programming in C# for several years. Now before getting too far into this project, I would like advice from experienced developers who can steer me in the right direction and have the following questions:



    1. What is the best strategy for puttig a DB on a server allowing user access?
    2. What are some of the issues I should look for or consider?

    Any addition advice or guidance would be greatly appreciated.

    Thank you.

  2. #2
    Ajax is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,967
    personally, if using C# to develop your front end, I would use sql server express for the backend. Main benefit of access is to quickly developing forms and reports - and can use many different backends - but if you just want the tables, sql server provides a stronger offering than the access db engine (ACE) particularly in terms of user access.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,704

  4. #4
    f15e is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2016
    Posts
    71
    An off the shelf product really isn't an option in my case. I don't mind building it from scratch but I just wanted some advice or direction before I go too far. I will look into Ajax's suggestion about using SQL Server Express. Thanks for the info. I really appreciate it.

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,676
    2. What are some of the issues I should look for or consider?
    Understand Normalization.
    Design the table structure on paper/ cardboard/ whiteboard. before using the computer.
    Try walking through your design "entering data" to see how the design works.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 12
    Last Post: 09-18-2015, 02:20 PM
  2. Company Details
    By Surreall in forum Access
    Replies: 2
    Last Post: 02-07-2013, 01:52 AM
  3. Replies: 1
    Last Post: 10-31-2012, 01:27 PM
  4. Company Logo available to all reports
    By Opid in forum Access
    Replies: 1
    Last Post: 06-15-2012, 05:43 PM
  5. need some advice building DB (noobie)
    By sureshot in forum Access
    Replies: 2
    Last Post: 10-12-2009, 09:49 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
  •  
Tech Forums: Microsoft Office Forums