Dear Tamsin,
Having been on the 'other side of the fence' I urge you to be careful about
how you structure an Access application for this. Maintaining control over
the structure and quantity of the tables is all-important.
By ensuring the users of this system aren't able to make new tables you will
reduce the risks quite considerably.
Keeping the structure simple will mean that the data migration to your final
system will be simpler, not only for your supplier but also for you when you
check the migration.
If you get it right then you'll begin using your system with a satisfying
head start but get it wrong and you'll be faced with a complex, costly and
time consuming data migration.
Of course, from a supplier and developer perspective that isn't necessarily
a bad thing :)
Kyle
Kyle Summers
Just Breathe
www.JustBreathe.co.uk
|