centralmike
asked on
Access Conversion 97 to 2007
I am trying to convert Access 97 app to Access 2007 application. I am running into a problem with multi-users in the database. The multiuser application works fine in 97. But in 2007 when two users are in the database at the sametime one of users is always switch to the record the other user in working on. Any ideas how to fix this? I have tried splitting the database and making it executable file no luck.
No points please.
I would not be surprised at all to find out that your users are using the same front-end and it is a temp-table issue as Pat described above.
I would not be surprised at all to find out that your users are using the same front-end and it is a temp-table issue as Pat described above.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Put the BE on a shared network drive and link the FE to it.
Each user MUST have his own personal copy of the FE. They cannot share the same copy so move the FE to each user's C: drive.
If this still happens, it is being caused by code in the application. Look for linked tables that should be local. Sometimes an application uses temp tables. If that is the case, the temp tables either need to have some identifying column so that each user's records can be isolated or you need to keep the temp table in the FE so each user has his own personal copy.
Compiling the database to an .mde or .accde does not make it an "executable". All the "compiling" process does is generate pcode which can be interpreted at run time and remove the source code. Access databases are never truly compiled and so they can never be an executable.