MS Access Multiuser - Main Form w/multiple subforms

Author

Main Form w/multiple subforms

Marilyn

2005-09-15, 8:25 pm

I have an Access 2000 (multiusers) database that has a mainform and multiple
subforms on a tab control page. When Acesss 2003 users open the forms, data
is populated into the main and subforms. However when the 2k users open the
forms, no data appears. However, if the forms are opened by a 2k user after
a 2003 user has opened the form, data will appear. Also there are cases when
the users try to open the form, and only the main form will appear and not
the subforms

Is this a locking issue?

G. Vaught

2005-09-18, 8:24 pm

No, its a design issue. If you have multiple users using different versions
of Access, then you need to split the database into a Backend/Frontend. The
Backend having only the master tables and residing on a server machine (not
someones workstation). The Frontend has the linked tables from the Backend,
the queries, the forms, the macros, reports etc and reside on each users
machines. The Frontend should be developed in the lowest common denominator,
which would be Access 2000. This way the Access 2003 users can open the 2000
Frontend and the 2000 users can open the Frontend. If you create the
Frontend with Access 2003, then you must make sure it is saved in the 2000
format.

"Marilyn" <Marilyn@discussions.microsoft.com> wrote in message
news:4BC10B94-076E-4F2E-BF36- 5E576ABA3744@microso
ft.com...
>I have an Access 2000 (multiusers) database that has a mainform and
>multiple
> subforms on a tab control page. When Acesss 2003 users open the forms,
> data
> is populated into the main and subforms. However when the 2k users open
> the
> forms, no data appears. However, if the forms are opened by a 2k user
> after
> a 2003 user has opened the form, data will appear. Also there are cases
> when
> the users try to open the form, and only the main form will appear and not
> the subforms
>
> Is this a locking issue?

Sponsored Links