config file

T

Toxalot

I'm creating an application in Access 2003 using VBA, JET, ADO. I'm
fairly new to this world. I come from a php background.

There is some data that will rarely if ever change. For example, a
list of province names and two letter codes. I need to use this list
in several different places in the application. Sometimes, I may need
to get the name from the code. Sometimes I may need to populate a
combo box. I have several static lists like this.

What is the best way to store this data? Global variables, tables,
files?

I will also need to store the location of the backend file. I'm
thinking that the first time the user runs the app, it will show a
file browse box. Then the file they select will be remembered for next
time.

Jennifer
 
B

Baz

Create a table which has the two-letter code as the primary key and the
province name in another field. Most relational database have lots of
tables for this kind of data. With the data in a table you can easily use
it as the record source for combo and list boxes, and you can join it to
other tables in queries.
 
Top