Search results

I have an Access2003 database that is split with a backend on one logical drive on the server and the frontend on another logical drive. I am connecting to a sql database on another server. I created an ODBC datasource on each computer for the sql database. I have a textbox on a subform that...

I have a query that works on its own but I am now trying to set a recordset equal to the query. Here is the vba code that I am using: Dim db As Database, rs As DAO.Recordset, qdf As QueryDef, prm As Parameter On Error GoTo Error_Handler Set db = CurrentDb Set qdf =...

I have a front-end database linked to tables in a back-end database. I have security permissions set for a group to have read permissions on the form and read permissions on the linked table in the front-end and also read permissions on the underlying table in the back-end. When I sign on with...