Storing Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to permanently store a piece of data in the database that is entered
one time when the database is first opened. I know I can do this with a
table, but sometimes this gets a little clunky. Is there any other way to
store data that changes from the first to the second time that a database is
opened?

Any help would be appreciated.
 
Hi Frank,

If you are finding that storing the data in a table is taking too much time,
you have a couple of options:

1) Depending what the information is and how confidential it may be, you
could store it in a flat file in the same location of the database. This is
really only a good idea if the data is configuration type data or data that
you don't mind being exposed to users.

2) If the reason for not storing it in a table is because they are
complaining that it is taking to long, display a progress bar if you aren't
already. That usually makes most of my users happy; knowing that something
is actually going on in the background.

Is there a reason that it is 'clunky'? Are you trying to store a lot of data?

Lance
 
Lance:

The main reason I find tables "Clunky" when there is only one record, is
that when I link the table to a form as a source, sometimes the form gets
moved to the next record, and a new blank record now creeps into the system.
As I write this, I guess I could not directly link the table to any form as a
source, but just update the record using VBA code. That may be the solution.
Let me know your thoughts.

Thanks
 
Back
Top