I
Italian Pete
Hi,
I have an Access Project front end connecting to an SQL Server
database. The connection was set up in the data link properties but seems a
bit flakey. I'd like to ask a question about best practices for connecting to
a database for reading and writing data.
When reading/writing, is it best to create a connection in code in the
moment in which it is required or should a continuous connection e created
and tested periodically to check that it's state is still active?
What code would be used in the best practice case?
I hope this makes sense,
Many thanks,
Pete
I have an Access Project front end connecting to an SQL Server
database. The connection was set up in the data link properties but seems a
bit flakey. I'd like to ask a question about best practices for connecting to
a database for reading and writing data.
When reading/writing, is it best to create a connection in code in the
moment in which it is required or should a continuous connection e created
and tested periodically to check that it's state is still active?
What code would be used in the best practice case?
I hope this makes sense,
Many thanks,
Pete