I could set it up as a variable, and pass it to the connection routine.

That brings up another question. In the routine you provided below, would
you run this for each SQL command you needed to run? Or could all but the

oCommand = New OleDbCommand("select * from table1", cn)

somehow be made generic?

Inquiring minds wanna know...






>That'll wurk.
>
>I know very little about Access. (Who uses Access?) How do I know where
>Access keeps it's tables/DB's?
>
>Glad it helped.
>
>As for your question, I haven't used Access in a long time, but there are many Access apps out there. I'm guessing the reference to the location could be stored in a registry entry, config file, etc.
>
>Kevin