Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Suffolk, England
    Thanked 0 Times in 0 Posts

    Half a Splitter Wizard (A2k Sr-1)

    I have an Access db which has been running OK, using forms as its front end, but which I now need to network with another user who dials in on a single link ISDN line. I wish I'd created data access pages from the beginning! <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    I have tried to split it using the wizard, but get error messages 'subscript out of range', followed by 'invalid procedure call or argument'. So far so similar to Berky 'Error when splitting database' (04 Feb). The difference is that the back end mdb file, consisting of tables only and no relationships, has been created.

    If I recreate the relationships, and then in the main file delete same, plus tables, then create linked tables from my back end file, will I have achieved my aim?

    Is it then worthwhile upsizing to SQL - there will only ever be two of us sharing this db, and the back end is unlikely ever to grow beyond 5MB. <img src=/S/baby.gif border=0 alt=baby width=15 height=15>


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Half a Splitter Wizard (A2k Sr-1)

    The Splitter Wizard is nice, but it isn't as if this is such a difficult task. Start by creating a new database that will be the backend. Import all the tables and relationship from the old database (soon to become the frontend). Then go to the old database and delete all the tables, then re-add them by linking to the new backend. Voila, that's all there is too it!

    As for your 2nd question, you probably won't need to upgrade to SQL Server for the situation you described. If it was a LAN, I'd be quite confident, but knowing that Access generally isn't good over a WAN, I'm not sure what problems you might have.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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