Spliting a table after DB has been all created

[thowe]

I have a fairly complex setup that I have created in Access 97. I think now, as I continue to build on the database, I now find that I need to break my table. I didn't plan all that well in the beginning and have only ONE table with 2 look-up tables. Well now I find that I should split my table up, but don't want to rebuild everything. Is this possible? I am quite scared to do this because I am on a contract, don't know enough about Access to do everything I want to do, and the deliverable is due in a few weeks. So is this hard to do?

 

[JoeMiller]

You'll have to redo a good amount of stuff, but it's much easier doing it all the second time because there's not as many "decisions" to make. Decisions like, what's the caption gonna be, what do I call this field, how do my forms work. Since you state you are on contract it would seem to me that you would want to start splitting ASAP if you have an inferior design. If the customer receives the db and has the savvy to recognize a bad design (ie, they can't get the info they need) then you just lost some work in the future. That's my $0.02, but I'm sure someone will have a differing opinion!

HTH Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

I agree with Joe. I would only add that it is poor practice to even solicit jobs which are beyond your capability. Especially on a contract basis. You can easily end up in serers legal difficulties by failing to perform. Even if you accepted the contract on a T&M basis, uniform commercial code leaves you with A LOT of liability. I would suggest that you "come clean" with the oyrchaser and negotiate a soloution. You could be suprised. He may appreciate your attitude and efforts and simply extend the deadline or at least pay you for what you've done to date without further oblligation.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over