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 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 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 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 Replies View RelatedI 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.
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
Can a php file be executed inside an asp file? I need to execute a php file in another asp file but i'm not so sure it's possible.
My server can run both asp and php and they run without any problems... I just need to find a way to include the execution results of the php file in the asp one.
Is it possible to use SSI and include the executed php file and then the executed asp file in a main ssi file?
I have installed PWS in windows 98 in each of the system at various places and put my Sales program files in the WWWROOT directory in all the branches. I'm afraid that the users may tamper my ASP files. Is there any way of converting .ASP files to .exe files so that the dont see my program.
View Replies View RelatedI was wondering how some sites let you search by using a form, then present the results as static .htm files.
The reason I ask is that I tend to use ASP to process form information, then give the user a list of results presented on an .asp page. The list is simply drawn from a database in real-time and formatted into a template page.
The problem with this is that search engines can't see any of the information in the database, since they can't do the form submission. Is there a way around this?
When DLLs are compiled in VB, in addition to the dll, there are also
exp and .lib files created. Can somebody tell me what these are for?
Do I need to include them when I deploy my application?
I want to include just the result of a PHP file within an ASP file. <--#include won't work, it just imports the text.Is there an alternate way to do this?
View Replies View RelatedChecking our IIS log files we often get the chinese bots probing our sites. My only concern at the moment is that when an item is called by ID (i.e. select category from table where categoryid = id) and the id is called from either a querystring or a form request, I use CLng (i.e. CLng(request.querystring("id")) to convert the id to a long int to prevent the bots injecting the variable with any non-numeric characters.
View Replies View Relatedhow can i do a ftp function to upload and downlaod file to the server without using a 3rd party component?
View Replies View Relatedcan somebody advise me, how to put a few text files into zip archive on IIS5
on user request on some asp page?
IYHO, if I have say 10 different product categories that extract their data
from say 10 text files or an Access DB, is it more efficient to have an ASP
for each product category to query each section or 1 which parses the lot??
The only reason I am asking is for multiple user access I have this strange
belief that if 1 page is getting requested and queried by 10 simultaneous
visitors then 'spreading the load' on different pages would help.
Is my logic correct or do the ISP fairies have this in hand??
when the user submit a form, all the form data's will be saved
as a pdf file
is it possible?
yes means. by what way we can get this..?
For doing this we have to use any third party tools..?
I would like to capture the data from a textarea box and save it to a file.
View Replies View Relatedi want to know what is the difference between using a .asp include file and .inc include file.I know how an Asp Include file works , but some place i have seen .Inc as Include file. What is the difference?
View Replies View RelatedDoes anyone know of a COM object, or if it is possible to display content in the browser of a file in a zip file.
In other words, I have a zip file with like 100 images. I have a script that will knows which zip to look at and what the file name is inside the zip. What I want is to display in my browser the image that is in the zip file .Not sure if this is possible or not, I've been searching the web for a way to do this. Any help would be great.
I wanted to know whether we can zip files on the fly without using any
components.
i have just installed windows server 2003 standard edition
but when i try to run any asp files it gives this error :
The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.also i couldn't log in my hotmail account
si i searched the help files i found some issue about the security level so i changed the security level and i could log in my hotmail account
how to use ASP for working .DBF files ?
View Replies View RelatedI'm looking into ways of creating zip files on my server without components to install. It's so I can let users of my site select files they would like to download and zip them up on the fly and download.
View Replies View RelatedI just upgraded to Office 2003 and none of my .mdb files open! Double-clicking an mdb file opens Access, but the database never opens. No error messages. No hourglass This happens to any mdb file I try to open.
Does anyone know what could this be caused by?
One site I've written allows the user to install an IE extension menu (notmalware at all) by downloading/merging a short .REG file. Worked like a peach on Win2K Server, now that I upgraded to Server 2003, it returns a 404 file not found error.I'm positive the file is there/spelled right.I changed it to .txt and it displays the text in the user's browser.
So there's little question that this is some "security" addition,to help keep us safe from the functionality we're used to. I could see browser-end warnings/protection, as long as it can be adjusted for trusted zones, but server-side content filters that block serving certain extensions? WTF?
So, after the obligatory scan of msdn, I looked for mappings to 404.dll,mime types and other seemingly quasi-relevant configs...found nothing that referenced .REG.Does anyone know how to disable this "protection"?Are there any other dastardly extensions it will "save" me from?
what .UDL files are and how they're supposed to be used.
View Replies View RelatedI need to read from a html file. I know you can read from a text file with OpenTextFile But is there one for html? or if i do OpenTextFile, will it go and return it anyways? I have to go, that's why I don't try it myself(and I'm scared of what could happen to the other site .
View Replies View RelatedAnyone think of a better way to run a VBS file from in ASP than this example? (Goal is to run VBS files that use 'wscript.echo' without having to re-write to use 'response.write'.) Code:
View Replies View Related