Results 1 to 4 of 4
  1. #1
    rpaldridge is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    2

    2010 and 2007 Access Queries, Forms & Reports


    I'm putting together a church membership database. The Access version on the computer at church is 2007. The one I have at home is 2010. The design of the tables are finished, and the church secretary has already started inputting data, while I'm working on queries, forms and reports. I know not to upload a copy of my trial table into what she's doing, but how can I copy and paste queries, forms and reports onto a DVD and upload them into her version? Access shows "save database" and "save object". Are queries, forms and reports considered objects, or should I simply use copy and paste from a DVD? Thanks in advance. This is my first attempt at using MS Access.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You should have the application split into FrontEnd (FE) and BackEnd (BE). All of the data would be in the BE and you could simple replace the FE when you have new additions without disturbing the data in the BE. http://allenbrowne.com/ser-01.html

  3. #3
    rpaldridge is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    2
    Thanks RuralGuy,

    And thanks for sending a link about how to accomplish this split. I have lots to learn.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad we could help. If you are ready to close this thread then go ahead and use the Thread Tools and mark it as Solved.

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

Similar Threads

  1. Using Public variables between forms/queries/reports
    By dcrake in forum Sample Databases
    Replies: 2
    Last Post: 12-25-2015, 05:44 PM
  2. Replies: 0
    Last Post: 02-08-2011, 02:34 PM
  3. 2010 Access reports
    By wthoffman in forum Reports
    Replies: 3
    Last Post: 10-12-2010, 09:36 AM
  4. Splitting DB; Keeping the Forms, Queries, Reports in BE
    By evander in forum Database Design
    Replies: 2
    Last Post: 07-07-2010, 04:59 PM
  5. Queries, Forms, Reports..
    By groundhog in forum Access
    Replies: 3
    Last Post: 07-07-2010, 12:30 PM

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