Recent content by Bergman

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...

Found the issue: I can use OpenDynamic if I set the cursor location to client Private Sub Form_Load() Dim strSQL As String 10 On Error GoTo ErrorHandler 20 CurrentISO.ISOID = 2 30 SetConnection 40 strSQL = "SELECT * FROM tblISOComponent WHERE ISO_ID = " &...

Discoveries: Created a local bogus table (one field, no records) with the same name as the SQL Server table. Opened the ADODB recordset as OpenKeyset and set the form's recordset to the ADODB recordset. I get the records to display. Unfortunately this is static data...

I agree. Except that they want to use an existing app I wrote 2 years ago. They've decided they want to use it long term and have set new parameters (encryption, no linked tables etc.) The application is already using ADS security. I'm not finding anything in my online searches and may have...

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...