this is the file address as it was given to me after the file was loaded: "http://wl.filegenie.com/~cherono/ADFDataBase.mdb"
I'v placed this address inside a variable called TstSorce and with the following sub i try to open the connection:
Public Sub OpenConnection() If ConnectionString.State = 0 Then On Error Resume Next MsgBox Err.Description ConnectionString.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TstSorce & ";User Id=admin;Password=;" If Err Then MsgBox Err.Description MsgBox "File is either not found or the server is offline" & vbCrLf & "or the connection string is currupted." & vbCrLf & "Please check your connection string and file user/password combo or try again later." & vbCrLf & "Error code:" & Err.Number Call MainForm.ConnConfig_Click End If End If End Sub
however I get an error "Bad File name"
what am I doing wrong and how can I fix it?
should I upload to a different site or maybe even go as making my own site?
This post has been edited by Neku: 21 June 2013 - 09:23 AM