Hi Guys,

I have a simple front end to an mdb. Can you please confirm that I need to make a (new) connection (and adapters etc) to the mdb 'each' time I want to read, add, or modify the db.

In other words, do I make a connection, read/manipulate the data (via a DataTable/Adater), then Close() - and do that each time I access the mdb.

I know thats how I would do it VB6, and I recall doing something along those lines with VB.Net2003, but, 2005 is doing my head in......



Regards,
Bruce.