focas.blogg.se - Microsoft access 2013 tutorial level 1 part 03 of 12

The error I get is "=> Variable must be of type "Object".:" against line 7. The only things I have tweaked are the provider details and added in the password parameter.

This is the setup I used to use for connecting to my mdb files.

$desc = $actionData.fieldS("Description").value.

$action = $actionData.fieldS("ID").value.

$dbAccess = ObjCreate ("ADODB.Connection").

Global $Server_Access="Provider=.12.0 Data Source=" & $db & " Jet OLEDB:Database Password=password ".

This is my first time using accdb and a password encrypted file.

In my previous experience I used user level security to protect the server database so connecting to it and working with the data was never a problem. I have a client based database that connects to the password protected backend database. I have a backend database on a server which is password protected. I am trying to connect to it using AutoIT but I cannot get my old sample scripts to connect to the database and return data using a query. I now work for a new company and I have built a database using the accdb format for the first time. However, my experience has been based on working with the. I've been working with AutoIT and MS Access for a number of years now.