D
david
I am new to Access & have been given a building companys
undocumented db to add new features to. It has been
developed over several years by a single programmer who
went missing 3 years ago! The users only know how to use
it & nothing about its internals. It is in Access97
contains 42 tables with many relationships, 172 queries,
84 forms,48 reports & 31 macros and runs as a split
server backend & users frontend.
Is it worth deconstructing/reconstructing it - importing
object by object into a new db to find out how it works
or redesigning it from scratch knowing what the client
needs & currently has.
What is the normal strategy with this sort of problem.
Is, at some point, Access not the right db to be using?
Any advice general or specific is welcome.
undocumented db to add new features to. It has been
developed over several years by a single programmer who
went missing 3 years ago! The users only know how to use
it & nothing about its internals. It is in Access97
contains 42 tables with many relationships, 172 queries,
84 forms,48 reports & 31 macros and runs as a split
server backend & users frontend.
Is it worth deconstructing/reconstructing it - importing
object by object into a new db to find out how it works
or redesigning it from scratch knowing what the client
needs & currently has.
What is the normal strategy with this sort of problem.
Is, at some point, Access not the right db to be using?
Any advice general or specific is welcome.