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
>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
[quoted text clipped - 11 lines]
> 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
Tom Wickerath - 31 Mar 2007 09:20 GMT
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
__________________________________________
> >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
[quoted text clipped - 19 lines]
> Larry Linson
> Microsoft Access MVP