Thanks for the quick reply, I was simply missing dr.Close() from a couple of the calling methods...

Slightly embarrassed yet relieved at the simplicity of the solution!

I opted for the ODBC approach and have it working now. Thank you!

string myConnString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=test.server.com;DATABASE=dbname;USER=username; PASSWORD=password;OPTION=3;";
OdbcConnection myConnection = new OdbcConnection(myConnString);
myConnection.Open();

Thanks, I had a feeling it'd end up with sql so I will give that a try. I'm more of a beginner when it comes to sql but I should have enough knowledge to replicate the access database.

The web hosting company that I use provides me with a free MySql database. Could I utilize this so that both my website and winforms app can access it or will I need to go down another route? Any pointers would be greatly appreciated.

Have tried both and get the same error which is around 30 lines long stating that the [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Invalid connection string attribute provider. Invalid connection string attribute provider data source.

Having looked through the documentation I received from Sky.UK.Net I have found the domain name server so I'm assuming I should be using this instead of the IP address.

So I currently have the domain name server, the database filepath and the database password but I'm unsure how to put these together.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ns1.sky.uk.net\mydomain.com\public_html\data\db.mdb;
Driver={Microsoft Access Driver (*.mdb)};Dbq=\\ns1.sky.uk.net\mydomain.com\public_html\data\db.mdb;

Thanks for the quick response.

Would UNC be the IP address?

The database is saved in the subfolder www.mydomain.com/data/db.mdb however when I access this through ftp I go through mydomain.com/public_html/data/db.mdb

If I use the IP address, I assume it would look similar to this

\\01.234.56.78\home\mydomain.com\data\db.mdb

Though I'm unsure what the 'home' part of the string would relate to.