How Many Users Connected To Db
Jun 20, 2007How can we know that , how many active connections or users are using database at some specific time..
View Replies
ADVERTISEMENT
General :: How Many Connected Users In Database
Dec 4, 2014I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ?
Is there an easy way to know that?
Modules & VBA :: Users Connected To Split Database
Sep 30, 2013I have an project with a split database. The data is stored in the database_be.accdb
I want to know which users are connected tot this database.
Who Is Connected
May 2, 2006hey gus....How can i know Who is connected to the db?
thx, Max.
Open Blank Form When Connected To Table?
Mar 21, 2005I have a form that is connected to a table - when I open the form it loads the first record in the table. How can I make it open a blank form, ready to add a new record?
View 1 Replies View RelatedTables :: Connected Views Deliver Incorrect Data
Mar 26, 2014Front end access 2010, back end SQl-server 2008 R2.I have all talbes and views connected to the server and due to incorrect results I found out, that the views from the server deliver incorrect data.Of course I refreshed the views in the access front end I even deleted them and connected them for new, but the incorrect data, even a different field sequence (!) remain.in a certain field there can be two different values: 1 and 2.
If opening the view I can only see 1, on the server the view shows 1 and 2, in the records, whatever is the value.This is not a calulated field.When checking this in a query in access I can select on value 2 (although I cannot see it!!) and I get the correct records but in the field itself the values still show as 1 !!
Same with other values in other fields. When I take the same SQL from the view in a stored procedure and execute is from access I get the correct data!!On both, view and sp I have the same permissions on the server!why views show incorrect data?
Modules & VBA :: Send Command To Device Connected Via RS-232 Serial Port
Feb 10, 2014Using Access 2010
How do I send the command "^G" to a device connected via serial port (RS-232) number 3?
Forms :: Query Show A Combo Box To Select What Is Connected To Data
Dec 10, 2013I'm trying to set a query with 6 fields.
My question is: Is it possible that the query shows me a combo box to select what is connected to this data.
Example fields:
HospCode; HospName; Dept; ModName; SerialN; DatInst
I'm looking to select name of a hospital from "HospName" from a list box. If no, then at least to write the name and the rest I'll get it associated with the name.
Then I need to know if I can put this in a form so the form asks same criteria?
Question About: A Table Of Users Who Have Relationships To Other Users??
Feb 21, 2006Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
Requery Subform From Another Subform Both Connected To Main Form
Aug 8, 2014I have a main form that has two subforms, subform1 and subform2, both connected to the main form. When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.
I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.
Me.[subform2].Form.Requery
Does not work. It errors and says it cannot recognize subform2 as a field. I have tried a field name on subform2 but I still got the same error.
Multiple Users
May 9, 2005All,
I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.
How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:
debo
Number Of Users
May 16, 2005If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?
View 1 Replies View RelatedMultiple Users
May 26, 2005Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
View 3 Replies View RelatedControl Users.
Jun 23, 2005When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
Thanks.
MDE And Multiple Users
Jun 29, 2005I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:
1.3 people (max) will be accessing the database, is that a problem or not?
2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?
Thanks.
Groups And Users!
Jun 30, 2005I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?
View 3 Replies View RelatedMultiple Users?
Aug 18, 2005Hi,
I am trying to create a database that MULTIPLE users can log on and view the data.
Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details.
I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them.
Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once.
Can MS Access do this?
if it cant, would a vb front end located on each computer help?
Thanks for any suggestions!
Jon Cheah
DAPs For Users
Oct 6, 2005What the user front-ends required in order to run/view my DAPs that put on the web?
Do they really need to have Access installed (any versions is OK?) ....
or anything else?
Thanks
Track Changes By Users
Mar 8, 2006What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
View 13 Replies View RelatedKick Users Out Of DB
Feb 19, 2007Hey guys,
I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can
1) Kick a user off
2) Send them a message
3) Send a user a message and then kick them off
Multiple Users
Mar 12, 2007i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time.
Any help will be highly appreciated.
View Users
Aug 17, 2007Hi
Just a quick question
Is there any way that I can view which users are logged onto the database?
Thanks
Chat To Users
Aug 23, 2007Hello
Has anyone ever made a code to enable users to chat to each other in real time to help with transfering calls etc within the organisation?
Many thanks
Paul S
Users And Passwords
Feb 12, 2008This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.
Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?
I am pretty much self taught so nothing too technical if possible!!
Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.
Thanks in advance for your help with this.
Emma
Too Many Active Users
Mar 9, 2008Hi Again guys,
I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.
Thanks for any help.
Multiple Users
Mar 21, 2008Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email.
o.k first i will tell you what we will have:
Three networked pc's running xp prof, and access 2003.
Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating.
Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc.
thanks in advance..
Rob