Hi People,
I am trying to create adodb connection from Access Runtime to another database in Access.
I have split database and front-end is access runtime and back-end with normal access will be only in one computer.
In back-end i have created a make table query and this is run by macro.
I need VBA code to front-end users (access runtime) to join to back-end and run a query automatically.
With this code i have an error:
"Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'"
Code:
Dim HurtowniaADO As ObjectDim ConnectionString As String
Dim ZdanieSQL As String
Set HurtowniaADO = CreateObject("ADODB.Connection")
ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" & "C:\Users\ljar01\Desktop\Makro\Makro IBS\Nowy System\Pliki docelowe\" & "\TeleIBS_doc_wb.accdb"
HurtowniaADO.Open ConnectionString
ZdanieSQL = "OdswiezAll"
HurtowniaADO.Execute ZdanieSQL
Please help,
Jacek Antek