Multiple Users
I am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
View RepliesI am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
View RepliesWhen more than one user tries to access my system, one user gets his page processed, and the other users recieve an error message stating:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/processweb/html/cpr/admin/sel_sc.asp, line 25
I am using ASP 2, MS Access 97 and IIS 4. Any ideas why only one user is allowed to access the database simultaneously? The database file itself is closed.
I have a hunch it may be because the IUSR_[machine name] user account on the web server does not have access to the *.ldb database locking information file... Does this sound like a plausible reason?
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I have 3 tables
members, pubs, favepubs
favepubs contains
favepubID, UserID (from members), PubID (from Pubs)
I'd like to join all 3 and maybe count the users?!
basically i want to show in my list of pubs how many users like that pub
Example:
The Red Lion (4 members - click for more details)
The Royal Oak (2 members - Click for more details)
or
The Red Lion (Jarv, Test, Admin, Shelly)
I'm hosting a couple of ASP applications on my server. How can I tell the number of users currently logged on, and can I get any details about them ?
View Replies View RelatedHow do we have a track of users who have logged in? I want to have a table of record with usernames and the status(logged in or logged out).
Whenever the user logs in, the status shud indicate he is logged in and when he logs out the status shud change accordingly. Does anybody know how to do this???
is this a permissions issue that happened at the server side
When I go to one of the .asp pages it brings up the "malicious code" prompt,asking whether I should open or save the file.
How do I make it so it just executes the file?
My database tables uses two users, namely dbo. and viss.
so in sql server 2005, every table has the following name structure:
dbo.members
viss.customers
etc
In source code, sql queries are used without adding usernames. Like,
INSERT INTO members
UPDATE customers
Now I get sql erros as 'invalid tablename members' to solve this I add username to query, like dbo.members. That would solve the problem, but is there an easier way to solve this? Because I'm working with a complicated application and it has allot of files, adjusting each query is an option but any other solution? Code:
I have a database that is setup with a messages table... I have been asked to modify the following script to do the following...
Message ALL Users or Message All Admins or Message Individual Users (with the option to select multiple users - such as 2 or 3) or Message Individual Admins...
The Database is designed with a User table and each user is assigned a "Type" such as "admin" or "user" - can anyone look at the following and give me an idea how to implement this function?
It needs to be setup where the admins and users are seperated so its ok to have two Options boxes that display a users section and a admin section..
Here is the code:
I have an intranet which all staff have access to. All staff can log in to the intranet to amend their own personal info. Currently staff have seperate passwords for logging on to their machines (ie ACL on network server) and logging on to the intranet.
Is it possible to have someone automatically logged in to the intranet based on their windows username and password for the domain?
Just wondering if anyone else has tried this. I think I saw this as an option in ASP.NET but my intranet is built using ASP.
I want to create a page in ASP language which gives me information about
currently logged users. I thought to do it by this way: when somebody
will log in to page, there will be a value of this user id stored in the
table among the other fields in the form which are filling in. After
clicking on the button "Log off" the value of the user id will be
deleted from the MS SQL Server 2000 database. I would do it, but I don`t
know how to solve the problem when somebody will close the Internet
Explorer window by clicking "x". Then the procedure of deleting a value
of user id will not call, and this value will be still stored in the
database, so I will not have actual state of currently logged users.Maybe there is another possiblity to do it?
I attempt to acceed to ASP files. I use IIS. In Netscape the error Too Many Users Connected HTTP 403.9 (defined in IIS).
View Replies View RelatedDoes any one know how to detect if a user is using IE on a Mac so i can route them to another page.I have tried the following:Code:
strUA = Request.ServerVariables("HTTP_USER_AGENT")
But how do i parse this info to determine whether they are a MAC IE user ?
is this possible? AD being active directory...
View Replies View RelatedI need to display information a list of Active users on a web site.I can do the count using the global.asa but need to display individual information about each "active user" without writing it all to a database and then pulling it out again.Info I need :
IP Address - Request.ServerVariables("REMOTE_HOST")
The page they are on - Request.ServerVariables("SCRIPT_NAME")
the page they were on - Request.ServerVariables("HTTP_REFERER")
Can I write this stuff into sessions and call them all out?
I need to authenticate users to enter in a NTLM-protected virtual directory,but I can't pop up a NT-login dialogue box - I can only do a web-based username/password form (my client is a "usability" firm!). After searchingand searching, I finally found up with this solution to use ADSI to authenticate users transparently:
http://www.eggheadcafe.com/articles/20010126.asp
I tried the script and I am able to authenticate that the user exists with the correct password, but when I redirect the user to the virtual directory,the popup box is still popping up! I think what is happening is that I am not actually passing the username/password to the NT server.
Is anybody familiar with using ADSI for NT log in's?Am I on the righttrack?And if so, how do I actually do this so that the NT login boxdoesn't pop up?
would it go something like: viewmember.asp?=ID
I want to make this a link to this users profile:
Code:
<%=(rsReply2.Fields.Item("rsCommentby").Value)%>
I am trying to create a website for students where they have to log in before they can access any of the materials on the site. Therefore the login will be done on the homepage. Providing log in is successful, I then want to be able to track which student downloads which materials. I know how to deal with the login code but am not sure when I create the session variables to track the users. Is this done on the following page? Also do I need to use the global.asa file?
does the session on start event happen the minute the student arrives at the homepage or can I tell it to start once the students have logged in? any advice will be gladly received.
i would like to automitically log when a user signs in, presumably using a seperate Access database. Can anyone point to to a simple way of accomplishing this?
View Replies View RelatedWe have an extranet located on one server that users access via a redirect on a URL. To access the extranet, they click on a link and have to enter their windows network logon details.
They then access the extranet which is based on Microsoft Sharepoint Services. I have written customised ASP pages, located on a second server on the same network, but want to use the same windows logon details.
how I create a login page which authenticates users against the servers user manager. I want the login to be a form in my website not a pop up window. I am currently running IIS 5 on a windows 2000 member server.
View Replies View RelatedI'm developing an online shopping cart. Usually the site administrator modifies products etc in the "Store". I want a mechanism for the administrator such that he should be
able to view or at-least count the customers or visitors in my "Store" (only in store), users of the other sections should not be counted.
Whenever a user in my store signs out or closes the browser (not properly sign out) or even leaves the "Store" the count should decrement.
I am trying to work out how to set up two counters on my site, one to track guest users and one to track registered users, like most forums show. There are loads of examples showing how to use the global.asa file to do a single active user count, but I can't find anything for my needs.
Has anyone come across such a script, or give me a clue how to write my own? All registered users are marked by a session variable called userLogged - which is true if they have logged in.
How should i code my file uploading asp script if i want the user to be restricted to only upload one kind of file format, example *.doc?
View Replies View RelatedI have a login button on all my pages so that users can can login from any page they happen to be on. This is placed on the page using <!--#include file="left.asp"-->
At the moment the actual login page always returns the user to the home page. It would be far better if after they had logged in sucessfully that they were sent back to the original page.Can anyone explain the best way to do this?
I have an asp page, I want to kick out other viewers when I view the site and redirect them into another page.
View Replies View Relatedhow can i display user ISP in my page ?
View Replies View Relatedhow can i tell how many users are browsing ?
View Replies View RelatedI have a login page, wherein the users login to our system. I want to know the number of users that are currently logged in to the system.
View Replies View Relatedi am trying out the asp pages on PWS. since my comp is stand alone, desktop PC. i was wondering if i place these on a server and i provide appropriate link to my main asp page then how many users can access the same main page simultaneously? should a code be written for that too? is it only one user can access the (lets say) login page or many users can simultaneously access and query the database as they want to.
View Replies View Related