I have a website I just built. On the index.asp page I have an employee login section. When the employee inputs his username and password he is redirected to www.mydomain.org/employees/employeesonly.asp. how do I go about making the employees/employeesonly.asp require a password if someone was to paste www.mydomain.org/employees/employeesonly.asp into their browser? The way it is set up now anyone can paste the url into their broowser and access the page.
I have a site using Access 2K and ASP. The site uses frames and the ASP page appears in between two of the frames; so I have a limited amount of space to present the DB information. I want the ASP page to have a restricted number of characters showing horizontally and to automatically wrap if the line limit is surpassed. Can this formatting be set in the ASP code for particular fields?
Also, I'd like to indent some of the data that's being pulled from the DB.
I am designing an app with multiple users. User 1 logs in and navigates to a Page 1 where a page template is modified. When modifications are over User 1 saves the page and logs out of the system.
I need to block access to every other user to Page 1 until User 1 "releases" the page. At the moment I am using a field on my Access DB called locked that I set when any user enters Page 1, and upon saving locked field is cleared... Is there a more efficient way to do this?
Suppose I have one website www.mywebsite.com and I have one page in this sitte "myrestrictedpage.asp".
The page "myrestrictedpage.asp" should NOT be accesible from the hosted website (www.mywebsite.com) instead of that the page can only be accessible only from : 1) www.OtherWeb1.com/welcomeuser.asp 2) www.OtherWeb5.com/
how to open a mde file from a web page (asp,html,shtml,apsx) ? I know there is a security setting that don't allows web server to run/launch executable files but can it be turned off.
Supressing the "Save password" prompt: Are there any good approaches to keeping a password from being stored client-side if auto-fill is on? Ideally I'd like to supress the prompt. The only other option I can find is to use a timestamp as part of the form name and pass it (the name as well as the value) in a hidden field to the login script.
Unique concurrent logins: Are there any good ways to prevent userX from being logged in from 3 different locations simultaneously? -I can code for a 'logged in / out" field, but that relies on the user actually login out. And if I use a variation of the "who's online" approach the user may have to wait until the seeion expires befor logging in again (suppose thier net connection dropped for a moment and they need to get back online) - At least I think this assumption is correct.
I use the windows 2003 server with IIS 6 and my web pages are created with ASP script.I am trying to block some web pages (not all) that is created only for internal users like an intraweb.To do this, how can i control it and how should i block to prevent access from external users.
I have a problem with an asp page:some users get the error:Bad Request(Request Header Too Long) when accesing the page with IE (IE6) , but the same users can access the page using Mozilla Firefox...
I have a form on an .html page that I have a visitor submit the results from which redirects to an ASP script. The problem is the visitors are viewing the source of the page and going directly to the .asp file instead of filling out the form.
I'm trying to use the following script so the page can only be accessed if the user is sent from the form. If they try to access it directly, it will send them back to the page with the form. Here is what I'm using, but it keeps blocking access to the page wheter the form is filled out, or access directly:
If Request.Form("email") <> "Yes" Then Response.Redirect "http://www.domain.com/form.asp" End If
I developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks----- 1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields. 2) It has to go to the Home Page(which I already did) 3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<% set MyConn = Server.CreateObject("ADODB.Connection") set rs = Server.CreateObject("ADODB.RecordSet") MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html ewsecurity.mdb;" rs.Open sqlqry,MyConn,2,2 rs.AddNew rs("firstname") = first name rs("lastname") = last name rs.update
rs.close myconn.close %>
Can somebody please help me in figuringout if I am missing something.
Does anyone know how to access a WORD document using ASP? I have a few users that fill in fields in a WORD document and I need to be able to open that document and read these fields once the document is uploaded to my web server.
I've created a db field with Memo type, and I have stored some text with carriage returns (no html) So the 3 words start on a differnt line. In access this displays correctly ( each word starts on a new line). However when I display these on a web page all the words appear on the same line.
I need the words to be displayed on a seperate line.
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
I wrote a script to compact my access databases from my admin section. Everything is working except I get this error:
Provider error '80040e4d'
Authentication failed.
Is their some reason the JRO.JetEngine needs authentication? I don't have direct access to this server and was wondering how to get around this problem or how to fix it. It fails when this link is run:
None of the databases have a username or password. Would I have to have the host company setup an account for this action to take place? And why could I do everything except compact the database? Is their a vulnerability issue when accessing this function?
I got this message ' HTTP 403.9 - Access Forbidden: Too many users are connected Internet Information Services' on my testing page , I'm doing an ASP e-commerce website. I am not sure whats wrong. i am running on Windows Xp using IIS version 5.1 . how can rectify this problem? would really appreciate cos I cant seem to solve it.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
we have web users that have requested the web application access an existing excel spreadsheet directly.
Users have an excle spreadsheet with complex functions, macros, formatting etc. They have data in the database that is accessed via a web applciation. They would like to use the web app to get the data they want on screen and then click a button to get that data and put it into specifc cells in the spreadsheet. is this possible?
strSQL="SELECT * FROM MyTable;" rsSet.Open strSQL, adoCon ...do some stuff... rsSet.Close adoCon.Close
Set rsSet=Nothing Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access. Can I call these queries instead of using a string to specify the SQL command?
The above seems kind of verbose for making use of a database. Can it be simplified at all?
Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
I am trying to establish a connection in Dreamweaver MX 2004 and an Access database for a log in ASP page, but keep getting an error. I am trying to establish "Custom Connection String" and here's what I type into the boxes that pop up:
1) CONNECTION NAME: ConnectToMyDB (I know, here I can put anything) 2) CONNECTION STING: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:Documents_and_SettingsJohn_SmithMy_Doc umentsJohnsSitedbJohnsWeb.mdb;
(tried with and without quotes around this)
3) Dreamweaver should connect: Using driver on Testing server
4) When I hit "TEST" I get an error "An unidentified error has occurred"
I am using Windows 2000. The database is in a db folder in the my defined site (moved it there). Is it the path I am typing in Dweaver or my Win2000 settings?
Hope someone can tell me what I am doing wrong. Is it my path to the database?
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
how can i retrict user to only access the web page iif and only if they have the username and password, they neeed to login before can access the certain pages. How is the coding for that web pages?
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
I connected MS Exchange Server to MS Access database using Access link table function. I can open the database table and see the fields and data inside the link table. However, the table seems cannot be queried by SQL statement.
My situation is:
I'm building an intranet. I have a ASP login page for all staff in the company to login. Other people can't register or login the intranet. That's the reason I use the company email address to verify username login name.
After I made the link to the Global Address List (rename to StaffList), I can see the Alias field. I wrote ASP code to use Alias field to verify user login name. But, the ASP page seems experiencing difficulties. I always got the "Connection Timeout" Error. Code:
I've got a simple template based ASP page which pulls information in one of several different languages from an Access database.
The copy I have in the database is fine. All languages - including the Japanese are displaying correctly when I look at them in Access. However, when I pull the Japanese text from the database, each character renders in the browser as '???????'.
I've tried different HTML encoding, but nothing seems to make a difference.
Basically, I want to have an asp page that has a button where when you click on it, it opens up a file open dialog box where you can search for any excel file you want to import. Then, once a file is selected, I want to read all the contents of the excel file (from column A) to display into a listbox on the screen (so that each individual row from excel file would be a separate item in the listbox). Also, this data would have to be inserted accordingly into an access database .....