Error while debugging project (Oledb connection error when attempting to connect to a database)

[Chandrasekharan]

When my Visual Studio project attempts to connect to an MSAccess database using the following connection string:

Dim constring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|dBase|\datafile; Persist Security Info=False;"

The following error is reported:



An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll


Additional information: Not a valid file name.

Can anyone help me solve my problem?

[ranman256]

Either :
change the provider to a different one.
or
stop using code to connect and use ODBC and connect your tables directly.