Ok, lets forget the file thing as ive fixed that bit.

Now ive added the code you sent me, the bit with the provide = microsoft.ace etc etc is apparently the duff bit. when i debug the system and press log on once i type the username and password it keeps coming up with an exception error message. i cant copy and paste it, its quite long, it says something along the lines of:

System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' Provider is not registered on a local computer.

It then carrys on with a load of other words which takes up half the screen, so its a pretty bit error message and i cant type it all.

Hope this is less 'Vague'