ADO - connect to accdb in Sharepoint Library

[Jon von der Heyden]

Hi All

I am trying to port a database kept on a shared file server to a SharePoint Library.

I believe that all that is required is a change in the connection string.

Example from ConnectionStrings.com

[FONT=Courier New]Provider[/FONT][FONT=Courier New]=[/FONT][FONT=Courier New]Microsoft.ACE.OLEDB.12.0;[/FONT][FONT=Courier New]WSS;[/FONT][FONT=Courier New]IMEX[/FONT][FONT=Courier New]=[/FONT][FONT=Courier New]0;[/FONT][FONT=Courier New]RetrieveIds[/FONT][FONT=Courier New]=[/FONT][FONT=Courier New]Yes;[/FONT][FONT=Courier New]DATABASE[/FONT][FONT=Courier New]=[/FONT][FONT=Courier New]http://mysharepointsite.com/documents/;[/FONT][FONT=Courier New]LIST[/FONT][FONT=Courier New]=[/FONT][FONT=Courier New]{5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};[/FONT]

I use this to create my connection:

Public Property Get Connection() As ADODB.Connection
    On Error GoTo end_prop


    If m_conASYNCCONNECTION Is Nothing Then
        Set m_conASYNCCONNECTION = New ADODB.Connection
        With m_conASYNCCONNECTION
            .CursorLocation = adUseClient
            .ConnectionString = Me.ConnectionString
            Call .Open
        End With
    End If


    Set Connection = m_conASYNCCONNECTION
    Exit Property


end_prop:
    Set m_conASYNCCONNECTION = Nothing
    Call RaiseError("Could not connect to the database!")
End Property

The old connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\server\fl1\fl2\fl3\fl4\FileDB.accdb;Persist Security Info=False;

And this has worked 100% in the past.

The new connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=http://abc.dev.xyz.com/ff/ll/blah/;TABLE={FD0BAC76-60F5-84G1-9Z8X-7Y01497M3T89}

When I attempt this I get th ol':

Could not find installable ISAM.

Unless I am mistaken, this error could be the result of sooo many factors

I have also attempted to pass arguments to the command Open method, such that I pass my username and password. When I do that I get this error:

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

Has anybody successfully hooked up to an accdb (or mdb for that matter), using a SharePoint Library as DB host? Can you perhaps help me understand where I am going wrong?

 

[gabivleon]

Have you solved it?

 

[Jon von der Heyden]

I honestly don't remember.

 

[chengkoonwing]

Have you solved it?

I solved by install MS Access