Results 1 to 5 of 5
  1. #1
    caliskier is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    3

    Access Switching to frontend and backend

    All,

    I am very good at excel and can program macros, but I am very new to access and may have a lot of questions, this is my first post. I am being asked to build something in access for my company, or at least manage a build. So here is my question...

    If we build it without both a front and back end, is it easier to take what you have and switch it to a front and back end?

    Also, when and why is it better?



    Thanks very much

  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,515
    I would strongly recommend splitting it. The only db I haven't split is one where I'm the only user. You can build it as a single db and split it later (and it's not hard), but sometimes you'll run into things that work one way and not the other, so I'd build it split from the start.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    caliskier is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    3
    Quote Originally Posted by pbaldy View Post
    I would strongly recommend splitting it. The only db I haven't split is one where I'm the only user. You can build it as a single db and split it later (and it's not hard), but sometimes you'll run into things that work one way and not the other, so I'd build it split from the start.
    Thanks very much, i have a lot to learn

  4. #4
    caliskier is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    3
    Here is question 2...

    What is the fastest and best way to learn access?

    Take a class?, buy a book? watch youtube?

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,515
    That probably depends on the individual, but for me I learn best by doing, so probably a hands-on class. That said, most of what I know came from a couple of books, forums like this and beating my head against a problem until the answer sunk in.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 03-01-2012, 09:06 AM
  2. Passwording frontend / backend Access 2010
    By erkwong in forum Security
    Replies: 0
    Last Post: 01-30-2012, 01:28 PM
  3. Replies: 1
    Last Post: 01-12-2012, 09:43 AM
  4. Replies: 1
    Last Post: 01-01-2012, 12:08 AM
  5. Replies: 1
    Last Post: 11-25-2011, 11:16 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