Link to ACT! customer database system
 

Dear Integencia

I am trying to read an ACT! v6.0 database into excel but have not been able to open the database using the programme DLL provided. I must be missing something obvious - has anyone tried this or can see if something is missing ?

All help greatly appreciated, as usual.

Andrew


I am using the sample code supplied as follows:

Sub MacOpenSingleUser()
'This sample demonstrates how to properly log on a multiuser ACT! database
Dim objDatabase As Object
'Create the object
Set objDatabase = CreateObject("ACTOLE.DATABASE")
'Open the database
objDatabase.Open dbName
'Perform login validation
If objDatabase.IsMultiUser Then
'at this point you can display a dialog which asks for
'username and password. The dialog is something you create.
UserName = "****"
Password = "****"
objDatabase.ValidateUser UserName, Password
If objDatabase.Error Then
Login = False
Else
Login = True
End If
Else
Login = True
'Single-user database - validation not required
End If
If objDatabase.IsOpen = False Then
MsgBox "Failed opening the database"
Else
MsgBox "Currently open database is: " & objDatabase.GetDatabasePath
End If
Set objDatabase = Nothing
End Sub