Results 1 to 3 of 3
  1. #1
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    206

    Post Splitting DB; Keeping the Forms, Queries, Reports in BE


    Hi.

    I am about to split the database I deployed recently. I was wondering if I could still keep the forms, queries, and reports in the back-end database, even if users will open these objects in the front-end.

    Will my decision cause any troubles in the future? It is easier for me to update all the tables, queries, forms, and reports if the DB is just a single file, rather than if the DB is already split.

    Hope to get a reply. Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I wouldn't. It would seem pointless, as you aren't going to distribute the back end to users anyway, only the front. You don't want to have 2 copies of every form, etc, because you'd have to update both.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    206
    Alright. Thanks Paul.

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. Queries, Forms, Reports..
    By groundhog in forum Access
    Replies: 3
    Last Post: 07-07-2010, 12:30 PM
  3. Reports based on queries
    By Merkava in forum Reports
    Replies: 13
    Last Post: 12-14-2009, 11:21 AM
  4. Replies: 4
    Last Post: 04-01-2009, 08:49 PM
  5. How to move copy queries and reports.
    By Fred C in forum Access
    Replies: 1
    Last Post: 11-08-2008, 10:24 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