multiple users to be able to design reports or such at same time

[Sharon]

Using access 2003 not able to have multiple users creating reports or going
into design view like it was in access 97. Now everytime that i want to
create something, I have to have everyone shut down. seems like there should
be an easy solution. running db on network and not standalone.

 

[MikeJohnB]

There is, split the database using the wizard into front end back end. Place
the back end Tables, relationships on the server. copy the front end and
issue a copy of the front end to each user to run from their own PC's. This
allows you to modify a copy of the front end without everyone being logged
out, then re-issue that copy to the users. They then will re-place their
copies with the udated version. If the users are allowed to modify the
programme, they will only modify their copies. They could then send you a
copy and if you approve, you could distribute a copy to each user again. The
tables may have to be re-linked but that is an easy enough process.

Hope this helps????

Kindest Regards

 

[John Spencer]

Easy solution:
Split the database into a backend (all the tables) and a front end (all the
other stuff). There is a database splitter under the Tools: Database
Utilities menu item. Give each user a copy of the front end.

Now make a copy of the front end and make your changes there. Once you are
successful and have tested things, replace all the users front ends with the
updated one you have created.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Douglas J. Steele]

Access 97 was the last version in which design changes could be made by
multiple users concurrently.

All Access applications should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relations). Only the back-end should be on the
server: each user should have his/her own copy of the back-end, ideally on
his/her hard drive.

That way, any user can make any change(s) he/she wants to his/her own copy
of the front-end. If you need to share the new reports with all the users,
on a regular basis you'll need to copy the changes from each user into a
common version of the front-end and redistribute to all the users.