Expand|Select|Wrap|Line Numbers
- 'public variable
- public db as new adodb.connection
- sub main()
- 'create connection
- end sub
Now, the problem is when a button is clicked to open a form and that opened form have to get something from the database as it opens up [at form_load], like this:
Expand|Select|Wrap|Line Numbers
- dim rs1 as new adodb.recordset
- rs1.open sql,db,adopenkeyset,adlockoptimistic
I never had the problem in the previous application, just when the whole Switch Board application request came in.
Why would db.connectionstring became null or blank?
[/code]