I have not created any user accounts for this new app. When working over terminal services, multiple users can open the app and look at it, but only the first person in can add info.
I have set the record lock fields and sharing correctly.
It appears that the program will only allow one admin to take control of the db, regardless of what they are doing inside the app. Is the best solution to define individual userids and passwords for each user?
I have an Access database that uses linked tables to connect to a SQL Server database. I have built many forms and modules that do a variety of things with this data. Lately, we have installed the Access database on a server, and started using Terminal Services to run it. Everything works fine if one person is using it at a time. However, we noticed that when multiple people use it at once, they seem to conflict with eachother.
It seems like one user will change the value of certain variables, and it will affect all other users. To be clear, nobody is using the same Windows User ID. Everybody is logged on in their own session.
Does anybody know why this may be, and what can be done about it?
I have three terminal servers in a cluster. One of them already has MS Access runtime 2000 installed and working. I am attempting to install it on the other servers. I have done this using the terminal server .mst file and in conjunction with the .msi installer. All appears fine until you try to run an Access application and it states 'cannot find system.mdw' however the other server (working) doesnt have this file either. In the 'add/remove progs' list, Access runtime is listed as being installed.
im trying to create a multiple user access database, but i am experincing problems when more then one person is trying to access the same entry fields and this is causing conflicts, the database is stored on a server and is not localised to the network machines. what i would like, is when a form is opened by user 1 (record no 10), user 2 should be able to use the same database form and go to a new record (record no 11) that isnt already in use by user 1.
any advice on enabling the database for multiple user access is welcome.
why access 2007 is displaying an image oddly on a 2003/2008 terminal server farm. I am reasonably sure the problem is an access on terminal server issue because if you view the image in paint, image viewer, or word it displays fine on the terminal server. I don't think it is a resolution or color issue because once again it displays fine in paint, etc regardless of color depth.
The image below shows the difference in the png graphic. The image is transparent (the blue section being the background)
[URL]
As you can see the terminal server image is pixelated.
The form the image is sitting on has a blue gradiant that goes light to dark left to right. The form properties are below
I have a database that was designed for our needs (not by me) and I have limited database experience. I am looking for someone who can guide me through simple query modifications to existing queries for a flat fee. Please respond if interested and the amount charged for services. Chris O'Reilly
If I have also HEALTH and EXPAT (servant) Policies that their details structure are completly different in Order and OrderDetails tables .
ex: tbl HealthOrder: OrderID, TransactionDate, ClientID, AgentID + DoB, and tblHealthPolicy: In, Out , etc And same is for Expat that is different also of Health and Cars Policy and Order..
How to make all the three ORDERS ( car , health and expat) working on one OrderId to make it easly for me when I am working on PAYMENT .Note that I am working on THREE different Order Forms here . and only Payment Table is the common in each Form..
I am using the Desktop services template as a starting point for an invoicing app. I would like to be able to add a product and/or service after the invoice is submitted so I can add a finance charge for invoices that haven't been paid yet. The template is setup to prevent items from being added once it is submitted. Looking for macro / rule that is preventing this action?
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.
I have a database that I splited the tables on one file and queries, forms and macros in another. The front end file (the one with the forms) I published it in our intranet, so when some one clicks on the link a form pops up which is the way it supposed to work. The problem I have is when some other people in my area go to the intranet and click on the link and get the error that the file is read-only and the macro that makes the form open up fails. I checked the file's properties and is NOT read-only, so I don't knwo what the problem is.
I am trying to create a database such that everyone in my company will be able to access it, but without having to install access and put a link to the DB on every computer. Ideally, I would like to have some sort of web applet that uses the DB on a central server and allows users to add and modify entries without having to know anything about Access.
Another baffling problem - there are far more traps for new players than I ever imagined. Any suggestions gratefully received.
I have a fe/be split database with multiple users on a network. All users have the same front end on their PCs and are either running Access 2000 or 2003.
Problem 1:
Some users cannot open the database at all, getting the error message "Could not open xxxxx.mdb - File already in use."
Problem 2:
Some users can open the database but get a message in the status bar saying "Recordset not updateable."
Other users, running either Access 2000 or 2003 have been able to use the database without difficulty. The number of users is in single figures and it is unlikely that more than 4 people have attempted to log on simultaneously.
The database default open mode is set to "shared", the default record locking is set to "No locks" and the "Open database using record-level locking box is checked".
I have been having difficulties setting the security for the database (see other postings on this site) and so it is currently unsecured with no password set for the admin user. Users are joined to their default system Workgroup Information Files.
My guess is that there is a setting on the Access installation of the user's PC that needs to be changed but this is only a guess - anybody any idea what I should try next?
I have a query that prompts the user to display certain/all of the members in my member table. The problem is, using a parameter query in the memberID field only allows the user to send the message to one member, not multiple members. "1 or 2 or 3" or "1,3" obviously don't work. I've tried creating a form with a list box to select the members (which I;ve done) but obviously you need code and stuff to get it to work which I think will be too complicated. Is there a simpiler way or is the form the only thing that will work? Thanks Kris
I have a database application that i intend to split with the table part on a server and the forms part on each users desktop. It will be used by approx 10 users. While the probability of different users accessing and updating the same form is small, the possibility exists.
Is there a way i can prevent any weird multiple update stuff happening? I'm using Access 2003
I've got this database that needs some users to be read only and some users to have full control. I applied the appropriate ntfs permissions but there is a problem. If a read only users open the database, and then a full control users opens the database its stuck in read-only.
I have a database we use to enter new account numbers and several other atribbutes about the account and it is split into a FE/BE with the BE in a shared folder. I have the open database using record-level locking checked but it seems to me that the database is opening up with page-level locking. Multiple users will receive a message that the current record is locked and I am sure that they are all not updating the same record. Does anybody have any idea's of what I can do? If nothing else I am going to have to recreate my form as an unbound form and see how that goes.
I have created a database for my department to log all of our jobs to keep track of them and I want to create a simple search for them but I am having difficulties.
I am familiar with creating queries to search tables for matching records, but is it possible to get search criteria from the user (ideally from a search form they fill in) to form the query?
For example, I would like the user to be able to query the jobs by month and/or business area and/or supplier...is this possible?:confused:
I am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no.
For example
yes/no box1 - user 1 completed this task yes/no box2 - user 2 completed this task and so on
So when i look back i can see which user complete which task. I did a bit of research and saw that i can save a user that update a record. But since this is a daily task, each new record will be a new day.
I've designed an Access Database (using Access 2003) and assigned user-level security to it such that some users are read only and some are full access. Everyone requires a login and password to access the database. The problem is, once I copy/paste the database from my computer to the shared drive (where it will be accessed by all the users) the prompt for a username and password disappears.
I am trying to put together an form to be used in an academic administration database. Ideally, I would like to create a form that will allow a user to select criteria and get a list of all students fitting that criteria. For example: Show me all a) all Economics majors with b) 30-50 Credits who c) have not taken English 101. All of this data could be compiled into one query, but I would like to create a form that will allow a user to select what data he or she would like to see. (Maybe they only want to see graduates) I hope this makes sense. And I hope someone can help point me in the right direction.
I have a search form that looks up a value in a field and lets the user know if it is there or not, they have now asked to put in multiple values to search... eg. searching containers number, I will put user input box where they can put these numbers
NYKU023561 TRLU102356 TCNU123023
This will search my container number field and show a pop up message box saying.. Please note below NYKU023561 - has been found you cannot use this container TRLU102356 - has not been found please check internal system TCNU123023 - has beeen found you cannot use this container
Below is the basic search I had before which was all I needed.. how can I adapt this?
Code: Private Sub Command256_Click() If (CntSearch & vbNullString) = vbNullString Then Exit Sub Dim rs As DAO.Recordset Dim CNT As String
I have built a end user form with multiple toggle buttons with "Yes/No" properties. I am wanting to link the buttons together, so if all have been selected/pressed it will read "pass" in a text box, but if even one is not selected it will read "fail". I was successful with the programming for one but not sure how to link them.
