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

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.

"Toxalot" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Jennifer,

For the second part of your question see :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

On Sun, 22 Jul 2007 05:12:04 -0700, Toxalot <(E-Mail Removed)> wrote:

>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