Hi all,
I have this really old database that was most likely created in Access '97. A colleague got it working when we upgraded to 2016 and part of that was manually installing Microsoft DAO 2.5/3.5 Compatability Library. The issue is, every time this database is opened, the reference seems to disappear from the loaded References list (it doesn't even show as MISSING) and then the database gives off errors and does not work.
This database is located on our network and is used by several people (not at the same time). I'm not sure if that has something to do with the reference being removed or not.
The section that is flagged when the error occurs is the following:
I've been fiddling with a copy of the database after doing a google search on the issue. One post I found said you could just change 'Dim as Database' to 'Dim as Object'. Can you do the same thing for 'Dim as Recordset'?
I did try changing both 'Database' and 'Recordset' to 'Object" and the database now compiles and seems to work correctly. I'm not really sure if this is a good idea or not. Could someone provide some feedback/suggestions?
I have this really old database that was most likely created in Access '97. A colleague got it working when we upgraded to 2016 and part of that was manually installing Microsoft DAO 2.5/3.5 Compatability Library. The issue is, every time this database is opened, the reference seems to disappear from the loaded References list (it doesn't even show as MISSING) and then the database gives off errors and does not work.
This database is located on our network and is used by several people (not at the same time). I'm not sure if that has something to do with the reference being removed or not.
The section that is flagged when the error occurs is the following:
Code:
Dim SourMyDB As Database
Dim SourMyData As Recordset
I've been fiddling with a copy of the database after doing a google search on the issue. One post I found said you could just change 'Dim as Database' to 'Dim as Object'. Can you do the same thing for 'Dim as Recordset'?
I did try changing both 'Database' and 'Recordset' to 'Object" and the database now compiles and seems to work correctly. I'm not really sure if this is a good idea or not. Could someone provide some feedback/suggestions?