Results 1 to 2 of 2
2002-02-12, 22:21 #1
- 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>
2002-02-13, 01:26 #2
- 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.