migrating ACC97 to ACC2000, unable to update report in shared mod

[Marcel Morel]

We used ACC97. The DB is on a file server. Every one can open and update
queries, reports... Since we migrated to ACC2000 we still can update and
create queries but we can't update report (except for the first user who open
the DB). Every setup open database in Shared Mode and we didn't use any
Access Security Feature.

Migrating mistake?

 

[Douglas J. Steele]

Access 2000 (and all subsequent versions) require you to have exclusive
access to the database to save any changes to things like reports and forms.

You're going to have to change how you do things. (To be honest, if
everyone's been using the same database, you've been extremely lucky that
you haven't had a problem with corruption)

The standard approach is to split the database into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end. Only
the back-end should be on the server: each user should have his/her own copy
of the front-end, preferably on their hard drive.

If your users were previously changing shared reports, you'll have to
provide updated front-ends on a regular basis.