ADO - connect to accdb in Sharepoint Library

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,797
Office Version
365
Platform
Windows
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
Code:
[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:
Code:
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:
Code:
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:
Rich (BB code):
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?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,095,978
Messages
5,447,670
Members
405,462
Latest member
est1989

This Week's Hot Topics

Top