mutiple users on a database

[Guest]

I am working on a database that was desisned in access 97. The database
itself is still in access 97 however the user front end had to be updated to
access 2003 to all for a new active x script. When a user login i to the
datbase they have to transfer data from and hp3000 environment into the
database. Prior to the 2003 update we could have mutiple user do this at the
same time since the update it we only allow one user to do this. If another
user attempts to access the database and load the data from the hp3000 the vb
forms with the database hang for the second user and will not load the data.
If any on has any ideas as to why this maybe happening I would be in thier
debt.

Russell

 

[Larry Linson]

I am working on a database that was desisned in access 97. The database
itself is still in access 97 however the user front end had to be updated
to
access 2003 to all for a new active x script. When a user login i to the
datbase they have to transfer data from and hp3000 environment into the
database. Prior to the 2003 update we could have mutiple user do this at
the
same time since the update it we only allow one user to do this. If
another
user attempts to access the database and load the data from the hp3000 the
vb
forms with the database hang for the second user and will not load the
data.
If any on has any ideas as to why this maybe happening I would be in thier
debt.

To update the design of a database, post-Access97, you have to have
exclusive Access. But, if your database architecture is such that bringing
in new data is a design change, then you probably need to review the
database architecture and design.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Russell,

To add to Larry's comment, it sounds like you might be creating a temporary
table on-the-fly. In any case, you are best off to split the database into
two files: a front-end (FE) application file and a back-end (BE) data file.
Each user gets their own copy of the FE file, installed to their local hard
drive. More details here:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________