Hi,

Sorry if this sounds odd, or goes on a bit, but I've got a question that I'd really appreciate any help anyone can give.

I'm writing an app that has a number of forms, a couple of which depend on having access to the same data table (Access 200, for the moment).

Basically, I can open a connection to a connection object & recordset at form.load time, but there will come a point where due to the nature of vb's "loads of things can happen at once" style of programming, two procedures could be accessing the same "public" recordset at the same time.

This could cause some confusion and perhaps loss of data integrity. Is it usual for each procedure within a "data enabled" app to create and then destroy it's own connection or recordset objects - or is it more usual for a global module or class module to manage data access to a shared table?

I hope someone out there can get where I'm coming from - I'm really after a few pointers I guess!

Anyway, thanks for taking the time to read this - and if you have any comments, please respond!

Many thanks,
Tarique