Search results

For added security I was requested to build an Access application using SQL Server with no linked tables. I was unable to find an example anywhere so here is my solution. (The code references a procedure 'SendError' This procedure sends an email to me via Outlook when a user encounters an error...

Due to security requirements of my application, linked tables are not allowed. I can create a pass through query to SQL Server and retrieve results. I can set a forms record source to an ADODB connected query IF related table is linked. The same query does not work if the linked table is...