Connection String To Access With Workgroup File

[Joe]

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

 

[Gregory Beamer]

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! |
********************************************

 

[sloan]

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.

 

[agile]

check 2

 

[agile]

check 2

 

[agile]

check 2

 

[agile]

check 2