Hello,
We're in the process of migrating our systems from access to another environment.
One of the first steps is to move our main tables that became too big to handle in access to an SQL environment, as a temp solution in transition to the new environment.
Performing simple queries on the migrated tables works like a charm, but once I attach them to a form that we use a lot, the database crashes on the first function (a simple 'search' button to find a number in the table). Is it because it uses the vba DAO commands, starting with Dim rst As DAO.Recordset?
We're in the process of migrating our systems from access to another environment.
One of the first steps is to move our main tables that became too big to handle in access to an SQL environment, as a temp solution in transition to the new environment.
Performing simple queries on the migrated tables works like a charm, but once I attach them to a form that we use a lot, the database crashes on the first function (a simple 'search' button to find a number in the table). Is it because it uses the vba DAO commands, starting with Dim rst As DAO.Recordset?