Can anyone guide me on how can I access the database (ms access) on a local network?
I used ODBC 64bit but it doesn't connect via a local network see below the picture and here is my code
I tried to changed runrev into the network path still there is error
Code: Select all
on mouseUp
global gConnectionID
put "runrev" into tDatabaseAddress
put "livecodeTest" into tDatabaseName
put "" into tDatabaseUser
put "" into tDatabasePassword
put revOpenDatabase("ODBC", "tDatabaseAddress", "tDatabaseName", "", "" ) into tResult
--check if it worked and display an error message if it didn't
-- & set the connection ID global
if tResult is a number then
put tResult into gConnectionID
answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
else
put empty into gConnectionID
answer error "Unable to connect to the database:" & cr & tResult
end if
end mouseUp