Switchboard: Error messages when printing forms

[Guest]

I have a database on a shared network server with 4 users. I created a
series of switchboards. When people try to open some reports, they receive
the "Microsoft Access has encountered a problem and needs to close>" error
message and prompts to send an error report. It alsways occurs when printin
reports. When the reports are accessed from the database window, they open
and print fine. Any suggestions?

 

[G. Vaught]

Your database, if it isn't already, needs to be split into a front-end /
back-end database. The backend with tables only resides on the server. The
front-end, which contains only linked tables and all the queries, forms,
macros, reports or any code modules, resides on each users machine. This
truly makes the database shareable between users.

If the database resides as a whole on the server, it can get easily
corrupted and sometimes unrecoverable.

Access has a wizard that will split the database automatically for you.
However, before you perform this action, make a copy of your database and
ensure that no one is in the database when you perform the split. You can
open the database in exclusive mode.
I would perform this afterhours to ensure noone could accidently open the
database.

 

[Guest]

Thanks, but the db is split. The db isnt on each persons own pc. It sits on
a shared network server. Does it need to be on each persons desktop.