Multi User Problem In Access 97
Aug 20, 2007
hi..
i have used one globle variable ...which gives me a new batch refrence numbers.. but when two users are working same time then ...it gives same number to both of them...i want different number as a result to both of them..
like it will give 37679...to both of them as new batch refrence numbr but i want 37679 and next number 37680 .....
plese help me how i can do this.... i really appreciate your help..
if need more information please let me know...
many thanks...
Nitesha
View Replies
ADVERTISEMENT
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Sep 5, 2005
Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.
They need to each be able to use the database when they need to and read or add data, reports etc.
I am using access 2003.
Thanks
Dave
View 14 Replies
View Related
Sep 2, 2004
Hello,
Great forum
I am a virtual assistant and I have a client that wants to "share" their ACCESS database with me so that I can do data entry. How do we go about doing this? Is there a program that allows me to use the same database as my client and their office people? I would be working from a remote location.
Thanks in advance!
View 3 Replies
View Related
Sep 25, 2006
We are planning a database application for a client that will need to be accessed remotely by their consultants. We will initially host this application on one of our servers for a few months, and then the client will take it over and host it. The problem we are facing is that this client wants to use ms access as the database, and doesnt want the interface to be web based. The plan was to use data access pages, and let their consultants use a remote desktop connection to access these pages. I don't use access, but I was under the impression that access couldn't really support multiple users hitting the database in this format. Is this correct?
Thanks,
Greg
View 5 Replies
View Related
Nov 30, 2005
Hello Experts,
Pl. help me in designing a small application..This app. is to be used by 12 users. We need an application to log time spent by the team in office.so this is a time sheet system. I know how to design a table, a form etc..My question is how can many users share the same database?
Let us say that on my computer I have created the database as db1.mdb. (it has all the tables , forms etc) Now for other users to use this what do I have to do?
Also can MS Access be used to make an application which supports simultaneous use by 12 persons?I mean can it support such an app?
Will be most thankful for your inputs..This is urgent.
N.
View 4 Replies
View Related
Jan 8, 2008
Hi
I have an access 2000 database which is networked on a 2003server. I'm having problems with multi user access, as some users can't access the dbase unless it is not being used. Other users on the other hand, have no problem at all.
I'm guessing it has something to do with the machine that is trying to access the db. Although, it is not a permissions issue because as I said earlier, they can get access when no one else is using it.
We are all using XP pro SP2.
Any advice would be great as this is driving me mad!! lol
View 9 Replies
View Related
Sep 10, 2013
I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??
View 7 Replies
View Related
Jul 18, 2012
i have build a single user application in access 2010. now i want to build multi user application and want to deliver to end user.how can i make my all vba code safe from end users.
View 3 Replies
View Related
Jul 4, 2005
We are encountering severe performance problems when running our access database on our Network.
Symptom:
Huge drop off in performance when 2nd and subsequent users refresh links to chosen back end database. If the database is opened by another users front end database.
Takes up to 10 minutes to refresh the links to 120 tables in Back-end MDB database.
The system is designed as a split front and backend Access database. The back-end Data MDB database is located on a Windows 2000 server.
The first time a user logs on they are required to locate and Re- Link the tables from the back-end database which holds data for the current year. If they wish to work on another year they re-link the tables from the relevant back end database.
When running locally the Front end takes between 5 and 10 seconds to refresh ALL the links to around 130 tables.
When the back end is on a network drive the process takes about twice as long. But is still quick.
If another user has the file open via their own (locally held) front end, then the refresh link process takes between 5 and 10 seconds PER TABLE !!
This means that that it takes up to 10 minutes to complete the re-link.
Same behaviour if using Linked table Manager or refresh links using code
As soon as second user logs out of database the refresh link process speeds up.
The behaviour has been observed on a variety of servers and customer networks.
General data access is also much slower after 2nd user - but just about bearable. Data files are small – few records – occupy 7mb on disk.
Development Platforms – Windows XP / 200 clients, Windows 2000 Server hosts the back end database.
Front end is Access XP (MDB or MDE File) with al the latest service packs and security updates installed.
We have experienced this problem with a number of different systems running in various environments. But this wasn’t a problem with the old Access 1 database
HELP! Access should be able to support 10 – 20 users - we can barely run 2!
View 4 Replies
View Related
Mar 31, 2015
If I want to distribute a front end to connect with a MySQL back end ... do I need to set up the system DSN on each workstation that will be using the front end?
View 4 Replies
View Related
Aug 4, 2007
Hi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
View 6 Replies
View Related
Dec 8, 2014
I am developing a small database for use in a multi-user environment: I have split the tables off and am testing with two copies of the front-end on different machines. All seems to work well except on one form.
On this form, the value of a bound control (exposed as a number of radio buttons) is used to make related controls on the form visible or invisible. I use the AfterUpdate event to trigger appropriate VBA code to accomplish this; it works well.
However if two users have the same form open at the same record (unlikely, but not impossible), and User A changes the value of the control via the radio buttons, Access will eventually propagate the change to User B's copy of the form but the AfterUpdate event will not be triggered and the form becomes inconsistent. I understand that events are only triggered when a user makes a change to a control; how can I be alerted when Access makes a change?
View 4 Replies
View Related
Mar 2, 2007
I have read a lot about if multiple users want to share an MDB, they have to create BE and FE and split the database.
I understand having to do that if all those users want to write to the MDB simultaneously.
I have a situation where one person will do data entry (write access), and two other users will just want to view and perhaps just search the database (read).
If only one person is writing at any time, do I have to do all that splitting and FE/BE configuration?
View 2 Replies
View Related
Apr 17, 2007
I've create a form with subform that work like a charm, now they want in a multi user environment. What is the best way to achive this?
View 6 Replies
View Related
Sep 1, 2005
I plan to create a multi-user application on access 2000. There would be more than 20 users simultaneously logging in the database. The database would be kept in Server with high config. The users would work on the database (server) from their workstations. Forms/Queries/Reports ... are in the workstation (client). The database may growup to 70 MB every 3 months. The application will run on the database for 3 months which will be replaced with a new one after that period. Is it a good plan to do so on Access 2000. Am worried about the network traffic. Will the users face it as a very slow application ???
(SysConfig workstation: Win2K Pro/ 128 MB RAM/ 40GB HDD/Pentium-4)
Any suggestion is appreciated. Thanx in advance.
Prodigy.
View 2 Replies
View Related
Mar 10, 2006
I maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method for making this database accessible to several users at once? My main concerns are accuracy (changes commiting in the proper order) and low chance of corruption.
View 1 Replies
View Related
Feb 7, 2007
Hey everyone,
I am in desperate need of your help. I have a split database that I am trying to enable multi users access to the database. I created a folder on the share drive with the front end and a folder on share (BEN) with the backend. I have changed the settings via options, advanced options, and checked that shared box however it will still not allow everyone into the database at the same time. Is there something that I am missing? Should I then right click and copy and paste the front end to local PC since the tables are split and still on the share drive???? I plan on using security in the future will this cause a problem???Thanks
View 3 Replies
View Related
May 22, 2007
Hi,
I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval.
Is it possible? If so, how do I configure my access database?
Please help.
Thanks!!!
View 13 Replies
View Related
Jan 29, 2008
I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options
Any help is appreciated! Thanks
View 2 Replies
View Related
Mar 11, 2008
:Hi,
At the moment I'm writing a production database for work, which include parts in/out, production planning, kitting lists and other forms. What I'm after is a way that when the database opens it asks for a password and depending what it is, is what you can do. Administrator can do all, Stores can only enter parts and scheduler can only enter planning and so on.
How easy is this? :o
View 3 Replies
View Related
Mar 14, 2008
1) I develop my application(Ms-Access 2k) and put into company network directory.
2) The problem here is only 1 user allow to access per time.
3) Is there any setting I miss out?
View 4 Replies
View Related
Mar 17, 2008
Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.
I appreciate any help you can provide me on this!!
View 1 Replies
View Related
Nov 1, 2004
Hi everyone,
can anybody help me on this. I have two PCs connected and i am trying to execute an Access file from the client PC. This appears to be possible but the problem is that i cant save any new record and Active X or OLE seems to be the problem according to the message box appeared when i execute a form. The file works normally when executed from the server.
Any ideas?
It appears that the problem comes when Vba Code is executed for example i can save records from the tables but not from the forms where VBA code is attached
View 2 Replies
View Related
Dec 9, 2004
Hi all, question about using a table for temporary storage. When a user clicks a button after selecting critiera, a form is displayed with fields bound to a TempTable. On this form is a subform which pulls 3 peices of data from a table called QuestionsTable. As a user clicks through the subform, two fields are populated by the user and get stored in the QuestionsTable.
Once done, the user clicks a button and a SQL statement grabs the data from the main form (TempTable) and subform (QuestionsTable) and shoves it into the Archive table. A SQL statement then runs to delete the contents of the TempTable, and Delete the *modified* data in the QuestionsTable (by simply setting the 3 fields which will change to " " or Null).
Now my problem. If two users are in the same form and one clicks save, the SQL statements eraase everything... so the 2nd user will be mid process and their data will poof.
I want to assign a Session ID each time the main form is loaded. This is set via AutoNum in the TempTable. My question is, how can I copy 3 fields (Question, Comment, Result) from the QuestionsTable and insert them into the TempTable, then have the subform load the 3 fields from the temptable (so in essence, everything is loaded from TempTable).
Did that make sense? Sorry if it didn't, I'm reaching my deadline on this and have a bad cold
View 3 Replies
View Related
Jan 13, 2005
I have a form "log_file" that I am going to be placing a nework. All I have done is create a new DB, create a table, and create a form. Now I want to make it so users open up the DB file and only see the form and cannot access/edit the table. Basically, It is okay if they go back and forth through the records and change those, but I don't want them to be able to edit the form either.
I'm just not sure where to go from here. If there is more info I should provide please let me know.
Thanks in advance.
View 3 Replies
View Related
