Forms disappear

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

timpuri - 22 May 2004 18:16 GMT

H

I have a access2000 database(*.mdb). ,office servicepack1, language Finnish. It is shared in a workgroup, number of simultanious users vary from 4 - 13. It works just fine when used by single user, but in a workgroup forms start to dissappear and also commandbuttons are don't work. All functionality is in the same project

The database is unusable at the moment. How should I troubleshoot this issue

Thanks alread

Timo Salminen

Reply to this Message

Tony Toews - 22 May 2004 20:27 GMT

>I have a access2000 database(*.mdb). ,office servicepack1, language Finnish. It is shared in a workgroup, number of simultanious users vary from 4 - 13. It works just fine when used by single user, but in a workgroup forms start to dissappear and also commandbuttons are don't work. All functionality is in the same project.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message