Hi,

I am attempting to connect by VB.NET program to a Microsoft
Access database which uses a workgroup file, but something is wrong
with my connection string. My code is shown below.

The error message that I get is: "Could not find
file ...Shortcut To Database.mdb"

But when I double-click on this file, everything behaves
normally. I double-checked the pathname and filename, no errors
there. So I am thinking that ADO.NET must do something different
when dealing with an Access database that uses a workgroup file, than
it does when a workgroup file is not involved.

Can anyone provide me any guidance on correct syntax for the
ConnectionString when a workgroup file is involved?

--------------------------------------------------------------------------
Public Function ConnectToDB() As Boolean
cnPCMTool = New System.Data.OleDb.OleDbConnection
cnPCMTool.ConnectionString = "Provider=Microsoft.Jet.OLEDB.
4.0;Data Source=C:\VS 2005 Projects\PCM Line Review\Shortcut To
Database.mdb"

If cnPCMTool.State = ConnectionState.Closed Then
Try
cnPCMTool.Open()
Return True
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical)
Return False
End Try
End If
End Function

Are there spaces in the name of the .mdb file? If so, I would change that
and try again. The other option is a messed up connection string.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Blog:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************

"Joe" <(E-Mail Removed)> wrote in message
news:760616bc-0c39-4216-a024-(E-Mail Removed)...
> Hi,
>
> I am attempting to connect by VB.NET program to a Microsoft
> Access database which uses a workgroup file, but something is wrong
> with my connection string. My code is shown below.
>
> The error message that I get is: "Could not find
> file ...Shortcut To Database.mdb"
>
> But when I double-click on this file, everything behaves
> normally. I double-checked the pathname and filename, no errors
> there. So I am thinking that ADO.NET must do something different
> when dealing with an Access database that uses a workgroup file, than
> it does when a workgroup file is not involved.
>
> Can anyone provide me any guidance on correct syntax for the
> ConnectionString when a workgroup file is involved?
>
> --------------------------------------------------------------------------
> Public Function ConnectToDB() As Boolean
> cnPCMTool = New System.Data.OleDb.OleDbConnection
> cnPCMTool.ConnectionString = "Provider=Microsoft.Jet.OLEDB.
> 4.0;Data Source=C:\VS 2005 Projects\PCM Line Review\Shortcut To
> Database.mdb"
>
> If cnPCMTool.State = ConnectionState.Closed Then
> Try
> cnPCMTool.Open()
> Return True
> Catch ex As Exception
> MsgBox(ex.Message, MsgBoxStyle.Critical)
> Return False
> End Try
> End If
> End Function

Try a single quote around the filename. Especially since you have spaces.

I hope the code below is only demonstration code, and you're not actually
hardcoding filenames into your code.

I have a JET DATABASE (better term to use instead of an "Access database")
example here:

http://sholliday.spaces.live.com/blog/cns!A68482B9628A842A!176.entry

Which has the connections strings in the config correctly.




"Joe" <(E-Mail Removed)> wrote in message
news:760616bc-0c39-4216-a024-(E-Mail Removed)...
> Hi,
>
> I am attempting to connect by VB.NET program to a Microsoft
> Access database which uses a workgroup file, but something is wrong
> with my connection string. My code is shown below.
>
> The error message that I get is: "Could not find
> file ...Shortcut To Database.mdb"
>
> But when I double-click on this file, everything behaves
> normally. I double-checked the pathname and filename, no errors
> there. So I am thinking that ADO.NET must do something different
> when dealing with an Access database that uses a workgroup file, than
> it does when a workgroup file is not involved.
>
> Can anyone provide me any guidance on correct syntax for the
> ConnectionString when a workgroup file is involved?
>
> --------------------------------------------------------------------------
> Public Function ConnectToDB() As Boolean
> cnPCMTool = New System.Data.OleDb.OleDbConnection
> cnPCMTool.ConnectionString = "Provider=Microsoft.Jet.OLEDB.
> 4.0;Data Source=C:\VS 2005 Projects\PCM Line Review\Shortcut To
> Database.mdb"
>
> If cnPCMTool.State = ConnectionState.Closed Then
> Try
> cnPCMTool.Open()
> Return True
> Catch ex As Exception
> MsgBox(ex.Message, MsgBoxStyle.Critical)
> Return False
> End Try
> End If
> End Function

check 2

check 2

check 2

check 2