Bug in Access 2000??

[Guest]

Hello,
I want to introduce an access database to be worked by many people.
While I was testing the multi-user capability, I found that, whenever a user
has a sub.form, as a pop up from a main form, another user is not able to
open the database..
Any tips to solve such a problem??!?

Thanx in advance..
Joshua

 

[Douglas J. Steele]

That doesn't sound normal.

What error message does the second user (the one who's "not able to open the
database") get? You're sure that second user can get into the database
normally under other conditions?

 

[Joseph Meehan]

Hello,
I want to introduce an access database to be worked by many
people. While I was testing the multi-user capability, I found that,
whenever a user has a sub.form, as a pop up from a main form, another
user is not able to open the database..
Any tips to solve such a problem??!?

Thanx in advance..
Joshua

I don't know of any reason the sub form would be a problem. However I
do have a suggestion. If you have not split the database so that there is a
back end on the server holding only the dynamic table data and each user has
their own front end with static data tables, queries, code, forms and
reports, then you should do so. All kinds of problems are resolved by
setting up Access properly for multi user access.

 

[Guest]

Hi Douglas,
Thanx for the reply. The error that the second user gets is:
"The database is blocked by ADMIN in <server name>"
Thanx in advance for any help.

Joshua

 

[Douglas J. Steele]

Is your application split into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables), with
only the back-end on the server and each user having his/her own copy of the
front-end? If not, that's the first thing to do.

 

[kinkilixiang]

£±£²£³
£´

Is your application split into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables), with
only the back-end on the server and each user having his/her own copy of
the front-end? If not, that's the first thing to do.