How to connect to the ms access databse via a local network?

[lemodizon]

Hi everyone,

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

hope you can help me thanks