Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2008
    Posts
    3

    Question Unanswered: Creating Backend DB - access 2003

    Hi all.

    I have created a backend DB from my main DB but it did not transfer any of the tables, forms queries etc just an empty DB.

    How do I get the all the tables, forms & queries into the BE database AND THEN link the front end to the BE?

    Cheers

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Exactly how did you create this back end?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2008
    Posts
    3

    Question trying to reapir Access 2003 SP2

    I used the Database Splitter wizard & this did not put tables in it.

    So exported the tables to the Backend, deleted the tables from the front end & tried to link the front end to the back end but the links manager did not work.

    I am at the moment trying to repair Office 2003 but something is preventing this happening so I will reboot & repair from the reboot.

    BTW - we are using Office 2003 SP2 & I have noticed there was an
    update of SP3. Should I get an install of SP3 but I have some real problems with SP3.

    We also have had some funny things go on with our 2003
    small bus server over the last 2-3 weeks. Nothing major just little
    things.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, get SP3.

    Links manager? Do you mean File - Get External Data - Link Tables? I've never known that not to work.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jun 2008
    Posts
    3

    Question FrontEnd - how to use effectively

    Thanks for the quick reply.

    The DB had ALREADY been split to a front end & backend & I was trying split the frontend & wondering why it was not working!

    Live & learn I suppose!!!

    Few more questions about using FE & BE's.

    At the moment I think the user's have a shortcut to the frontend (which is on a shared folder on the network) on their desktops.

    Should they have is their own copy of the FE on their desktop?

    I suspect YES!!!! & it is this that allows multiple users to access the DB.

    How many users are allowed to access at one time? Are there any special settings, permissions that I need to set?

    Any good Access 2003 texts to recommend for an old 97 access user that hasn't really developed DB's since 1998/9?

    Thanks

    BTW - Office 2003 SP2

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Should they have is their own copy of the FE on their desktop?
    Not necessarily. Most of my distributions don't do this. Although there is no harm in having each user's FE reside on their local machine, there is no real reason to do it.

    How many users are allowed to access at one time? Are there any special settings, permissions that I need to set?
    No special settings... there is the Record Locks thing, but other than setting this property to what you want, there's not much else to worry about.

    You can have a realistic limit of about 15 users (less with larger / more complicated applications) with a standard Access BE/FE configuration, but beyond that things tend to get messy and then you put your BE on SQL Server and you can run more users than I have ever encountered.... Let's call it 255

    The DB had ALREADY been split to a front end & backend & I was trying split the frontend & wondering why it was not working!
    Tee hee!! ^^ I guess that would explain your symptoms lol
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •