BC30205: End of statement expected.

[joopdog]

How do I fix this?

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30205: End of statement expected.

Source Error:

Dim conn SqlConnection = New SqlConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db_scratch.mdb";)

Any help would be appreciated.

[basilisk]

try changing to :

Dim conn As SqlConnection = New SqlConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db_scratch.mdb;")

which should compile (i added 'as' after conn and moved the semi-colon before the quote)