I have developed an asp application to track the training of employee training records. I'm close to done but I have one nagging problem. Multiple users can log in at once of course, but I don't want more than (1) person to open a training record. So I put some code in: Code:
View RepliesI am having problems with some ms access mdb queries that used to work fine up to about two weeks ago. All they now do is lock the database (produce an ldb file) or say there are key violations.
Nothing has changed to the asp pages or the database so I am scratching my head (amongst other things) to work out what the problem is - any help much appreciated to restore sanity! I even get the same errors when I try the sql statements below on a local copy of the database (its about 50mb) on my local machine. Code:
I have an asp intranet app which allows users to download files from the
server.
It all works fine but now I have been told that in the case of Word and Excel files the user, after downloading or opening the file the file must be locked in some way so that other users cannot change it. On top of that I also have to allow users to save changes they have made to these files on the server.
I am having a problem with locking, and it is crashing our website. I suspect it is a locking problem because everytime the database goes down, I ftp into the site and see the dreaded *.ldb file. Access is susposed to support from 15 to 20 concurrent users, right? The log files show no more than two or three users accessing the database at the same time. By "same time" I mean within one second.
Below is the code which updates the database. Can anyone see anything wrong with this?
Also, if I wrote the information to a text file with the FileSystemObject instead to Access, would I solve the problem of locking?
BEGIN CODE .....
I know this is client side but this is coming from an asp page. Is there a way to lock two rows on a table so that when a user scrolls down a long table they always see the header row? Without using frames.
View Replies View Relatedi am having this problem with my webserver. everytime i run an asp application that will display pictures, my server will lock up. i used to this it was due to the asp itself, but whenever i run asp apps that display pics, it works fine.
this only happens when i access my websites from my personal computer within my network. whenever i access the sites from outsite my network, it runs fine. is this a problem due to my server or is it because of the data that flows through my network?? any thoughts?
I have a table at MS access database, and I want when I perform an insert action at that table to be locked, noone other to insert. maybe can do updates or see the values but no insertions values to that table via the asp application. Is that possible?
View Replies View RelatedI wrote this script which for now it works fine. The purpose of this code is to lock the account whenever a particular document comes to its expiration date. So, if I have a document that expired on 7/31/06, the it should lock the user's account once they'd logged in.
However, the problem I am having is that is locking everyone that has already an expired document. What I would like it for the code to check during the current month. If a document expired, say yesterday 8/9/06, lock the account, else let then user continue to access their account. Code:
I have an access database that used to be on 1 box and now is on another.
There's asp pages calling it. The gals that use it said they used to be able
to get into the access database at anytime and modify it without the asp
pages locking up. Does anyone know how this could occur?
I need advise as to how to do the following. In a asp page, the user can input
information via text boxes which goes to a database. If users click a check
box named final and submit the asp page, then next time they come, they will
not be able to change any information.
This means, I would like to grey out the text boxes so that users are unable to edit the values in the text boxes. The only way to allow edit is via adminstrator's intervention.
Using IIS 5.0 and sometime some asp pages (absolutely
randomly) showing as blank white pages. So far only one
way of fixing it - restart whole server. Restarting IIS,
or specific web server not helping, only whole server.
I enable server side and client side debugging, but no
errors showing up...
In view source pages always look like this:
-----------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1251"></HEAD>
<BODY></BODY></HTML>
-----------------------
Any idea why it can happened and how to fix?
I am always getting cached pages even contents of the page changed on the server but I am getting old page (data).How to solve this.
View Replies View Relatedis it possible to create pages using other pages. Here is an example... Can I make a page that has a menu on it, but the menu is actually a seperate page that I call with ASP?
View Replies View RelatedWe run a website with pages that are created using ASP. The website is
used by different people from different networks. For some people, the
pages are stuck. It looks like the were able to open the page, but it
is not displayed on their browser. We think that it might be something
to do with their proxy. Does anybody know how to solve this problem?
I had a 404 page set up in IIS 5.0 that would the the URL of the requested page from the query string. i recently upgraded to IIS 6.0 but it doesn't seem to put the requested URL in the query string as it did in IIS 5.0 and 3.0. Does anyone know how i can get the requested url property in IIS 6?
View Replies View RelatedI have a bout 5 different pages of which each will contain a form requiring users to complete. These forms are all related as one project. It is necessary that if the user was to only complete the first form they could theoretically quit, come back later (time not dependant) and complete the remaining pages. Therefore I think the best way to do this is to write the values to the database upon each click of the next button. The only other issue with this is that the user will also be receiving a pdf file at the end of the full form submission with all their information inserted into this pdf and finalized. Now. I am aware of pdflib in which I need php but my choice was to do this in asp. What are my options here? Should I combine them, should I draw all the info from the db at the very end with php and then create the pdf, should I use sessions during the entire process
View Replies View RelatedWhen asp.net pages are made in vs.net, loading on the
local host displays the labels all in the top left corner
of the screen. Also, all textboxes and image buttons are
not even displayed at all. If pages are made on a remote
server, they load perfetly fine, it is just the local host
displaying them incorrectly. Is this a common problem?? I
have iis 5.0 installed with windows 2000. i use the full
version of vs.net to make asp.net pages.
I have a web site I've recently moved to a new provider.It has
worked for years.On the new provider's servers ( Win2k Server .NET 1.1 )
my asp 3.0 pages often don't completely execute.
Here is what happens: Most of the page starts displaying in the browser,
then you see some HTML, then nothing.
If you refresh a few times, the page finally completely loads. There is
never an error reported during any of this.
I have installed IIS 5 on Windows 2000 Server and have applied all the neccessary updates and patches. I am unable to run any ASP pages on the local server. I am able to view the HTML pages though. I have checked everything but cannot seem to figure it out. I end up getting HTTP 500 for all the web pages.
View Replies View RelatedI am trying to setup a demo server for an asp.net web site that is working on my real website. The demo is Win2K and I have installed .net framework and IIS, both successfully,I think.
The problem is that when I try to access the demo site, the pages are not being served correctly - only lables are displayed, and not as configured. HTML pages display correclty. I tried to run aspnet_regiss, but get an unkown function error.
i can make a database, add entries to database, delete from database, but the only thing i want is "How to divide entries in Pages" like we can see in the guest-book etc Scripts.
This is an Example: Quote:
Entries: 500 Pages: 1|2|3|4|5
how to divide the entries in pages, like 10 entries per page..?
I've got a site that's been up and running for a couple of years.I've added some new stuff and it looks fine on my computer. However other people are seeing the old stuff.
I've tried a manual refresh of both my browser and theirs but nothing, the URL's are identical . This is a real problem as i'm away for a month as of Friday and the site is needed for a project.
Our website is in html format. I want to change it to asp. I have already created my index page and have it on the server as index.asp. When I load the website it brings it up with no problem. On this index page I have links to all the pages on the website which are basically articles of varying lengths.
I want to use the query string (i.e. page.asp?pageid= or authorid=) ect. to load that article. Do I need to develop a database to store these articles in? If so can I include the formating code in the database field for the article itself. My fields in the database (ms access) would have for example article_id, author_id, article_txt, ect. How much can I place in a particular field (txt wise)?
I understand that the information passed in the query string after the ? searches the database for a match. Once it finds a match how do I display the article and have my formatting included, ect.? I hope this makes some sense.
We have moved a web site from a development server running Windows 2000 and IIS 5 to a Windows 2003 server running IIS 6.0 Now the asp pages do not work correctly. For example, request.form() no longer returns data from the calling form.
I have turned web services extensions on to allow active server pages. The pages do work to some extent, I can even setup a connection to a database and retrieve stored procedure parameters, but some elements do not work. What else do I have to do to make an IIS 6.0 server run asp from a previous version of IIS?
I have IIS running and can get it to display htm pages, but not ASP. I get 401.2, invalid config on server. I've run authdiag, but can't glean the answer from its results.
View Replies View RelatedAccording to my last post (Error Handling) when I create an ASP (check.asp) page to handle 404 error (Page Not found) and I display data in this page according to the URL, this way I can make a site with infinite number of pages where those pages are not availble in reality. and I can create my own links in those to send to any URL in my domain.
Example: to display information about USA, I will make a link to a page called (USA.asp) and according to the name USA I can display data about it, and the URL will look great.
are dose links detectable by search engines?Will google index page http://www.site.com/usa.asp?surely USA.asp is not availble, but the link will display data
I would like to know if it is possible to set this property in way it can be for example in Visual Basic. How would you set tabbing to go the way I want it to go rather and how would you make the first field have the cursor/focus when users log in and get to the page where you can start submitting.
the reason why I need this is so that user can scan through all the fields almost without needing to use the mouse, so the first field to have the cursor inserted and ready to go and the rest of fields to give the tab number the way I like it. Can it be done and how would you do it?
I want to know what's the best way to debug ASP pages? Now, I just put the
following code when I got run-time error, but sounds like not efficient.
I'd like to set-up an ASP page that emails shoppers 30 days after they've purchased an online product.
Constructing an ASP page that searches the database and if the datediff of the order date and now() = 30 to send out an email shouldn't be that difficult. But is there a way to have it run automatically?
i need help about restricting pages other than home page
i have a project inserting resume details here
i have 4 pages include home page
if i want to restict all the pages except home page
while starting
how to write asp code for that one
I have a site that I need to distribute to various locations around the country. Each of these sites has they're own developers so I want to lock the code to prevent them from seeing it. Is there anything I can do?
View Replies View RelatedI have 2 seperate sites - Employee Site and Admin site. Only difference between the 2 is - Employee site is displayed based on the employee ID who logged in. So they can see only their information. Admin Site is displayed only to the admin users who can see anybody's information.
Admin users have a textbox and a submit button at the top where they enter the employee ID and then they can see that employee information. (Typically, the employee information seen by the admin user would be the same as seen by the employee.)
Both pages have NT authentication where I grab the "Logon_User".
The goal is to combine the 2 pages into one page.
Once I do that, I need to validate if that NT ID exist in the tables against that Employee ID of the person who logged in.
However employee's information is in the Employee Table.
Admin user's information is in the ReportViewers table.
I also need to check the error message I need to return back if the person;s NT ID does not exist in the table. Code:
I have got a selection list. How do I make the selected value accessible by many pages??
View Replies View Related