I have an access 2000 file format front end database which is run in Access 2007, tables are held in a back end SQL Server database and are linked to the front end. The front end is kept in a folder on a shared network drive where everyone accesses it. I would like to upgrade the DB to Access 2007/2010, however when I have tried to do this, the following problem presents itself.
A lot of my queries/reports are opened via a popup form which allows users to select an option which then filters the resulting query/report by the chosen option. After the upgrade, the popup still works on my PC but will not popup on another PC when trying to open the same report. The database locks up and I have to force a quit.
Can anyone assist please?