I've got a slight problem... I have a Main form that essentially has tabbed forms on it. within one of the forms, there is a listbox which is based on a linked table from a SQL database. whenever the form loads, the user is prompted for their username and password. is there a way to open the connection when the form opens, and have the connection close when the form is closed? i have tried using an ADODB.Connection to connect to SQL, but this doesn't do any good. i have also tried including the a connect string in the sql string source of the listbox, but this doesn't work b/c the table is a linked table (which i'm unioning with a table in my access db).
i would appreciate any help anyone can give, as i don't have much knowledge in connecting to outside datasources.
Thanks,
evan
i would appreciate any help anyone can give, as i don't have much knowledge in connecting to outside datasources.
Thanks,
evan