Admin Tables to avoid hardcoding data?

[Smriti Dev]

Hi There,

I am creating a ms access database where I want to design admin forms that
can be used to enter in all the relevant information by the user instead of
me feeding in the data (don't want to hard code anything so the users of the
application can easily make changes later). What is the best way to design
such a system? Do you have suggestions on what would be good books or
internet sites on this subject?

Thanks so much,
Smriti

[Larry Linson]

Re: Admin Tables to avoid hardcoding data?

I'm afraid there's not enough information here for me to answer. It is
possible to control a good deal of an application via data stored in
tables -- unsurprisingly, we call that "table-driven".

But it is certainly not feasible to give them all the flexibility of Access
itself in that manner. To do that you give them Access itself and teach them
how to use it. "Not hard coding anything" would seem to imply this is what
you had in mind.

Somewhere in between, there is a point where "table driven" is useful. To
determine whether is seems so would require a good deal more detail on your
part.

Larry Linson
Microsoft Access MVP



"Smriti Dev" <smriti.dev@uto ronto.ca> wrote in message
news:IIrHnw.7Ix @campus-news-reading.utoront o.ca...[color=blue]
>
> Hi There,
>
> I am creating a ms access database where I want to design admin forms[/color]
that[color=blue]
> can be used to enter in all the relevant information by the user instead[/color]
of[color=blue]
> me feeding in the data (don't want to hard code anything so the users of[/color]
the[color=blue]
> application can easily make changes later). What is the best way to design
> such a system? Do you have suggestions on what would be good books or
> internet sites on this subject?
>
> Thanks so much,
> Smriti
>
>[/color]