Global AccpacDBLink object 1

[JoeAtWork]

I am wondering if I can open an AccpacDBLink object when my program starts up, and keep it open during the life of the application. I would think that is more efficient then opening a new DBLink every time I check for a record, add a record, etc.

Are there any reasons agains doing this?

 

[jayconverse]

Err, yeah, that's the only way I ever do it. Also consider using two links, one read-write and one read-only. Use the read-only link for lookups and validations, it's faster.

Jay Converse
IT Director
Systemlink, Inc.

 

[JoeAtWork]

Thanks Jay, I figured that would be the case. I will only need one read-write open because all the application does is add records.