Results 1 to 2 of 2
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    What is an Access Project vs. database

    I have a pic uploaded showing the VB editor. I am trying to understand the difference between an Access Project and Database. How is an Access Project defined?

    In the screenshot, there is something called Central Repository - Experimental (Microsoft Access Forum) at the highest level. Is this a project or a database or something else?

    The reason I am confused is because I have a database called Central Repository - Experimental and another database called Microsoft Access Forum.

    So my questions are these:

    1. How is an Access project defined?


    2. Why is it that two different database names are seemingly being combined into one?
    Attached Thumbnails Attached Thumbnails Access Projects and Databases.png  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    AFAIK, Access projects were an aspect of Access 2003 and earlier. I have never worked with one.

    It is possible you have a split database. This is when the data tables are in one Access file and the file in located on a network central server - this is the backend. All other components (queries, forms, reports, code) of the db are in another Access file (or some other GUI interface) - this is the frontend. The frontend links to the tables of the backend. Copies of frontend would be placed on each user's location workstation.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Database design - first access project!!
    By dantray02 in forum Database Design
    Replies: 3
    Last Post: 05-22-2014, 12:33 PM
  2. Replies: 2
    Last Post: 04-07-2014, 10:01 AM
  3. Replies: 4
    Last Post: 10-31-2013, 12:43 PM
  4. Replies: 2
    Last Post: 12-30-2011, 08:07 PM
  5. Need Help DataBAse Project
    By GuiGui34 in forum Database Design
    Replies: 0
    Last Post: 12-11-2010, 06:32 AM

Tags for this Thread

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