Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

mutiple users on a database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Russell - 30 Mar 2007 23:26 GMT
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 - 31 Mar 2007 06:21 GMT
>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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.