Access Certain Pages
I'm writing a CMS for my new web site and there will be around 4 users using it to update the site but I don't what all the user to accessing all of the pages. I want to be able to set which pages the can access.
So far there are 15 pages and growing to the CMS, I have made a login script and which user has there own account.
Now I was thinking I could add each file name (eg. page.asp) to a field in the database and when the page loads it checks to see of the filename is in that field of allowed pages. But a database field can only hold 255 Characters and my page file names are around 15-20 characters long so by the time I add more pages to the CMS it is going to exceed 255 characters.
Anyway I hope you have a understanding on what I want to do, so does anyone have any ideas on the subject
View Replies
ADVERTISEMENT
I'm doing a web page with Admin rights to a MS Access database. So far when the admin logs in they are directed to the admin page. However if someone knows the name of the admin page they can still type it into the address bar and it will pop up with no restriction. Any ideas how to restrict this access to administrators only?
View Replies
View Related
We were using asp pages to mine data from our ms access dbs. Now have upgraded to 2003 ms access. I tried the data access pages and am able to of course query data on the website from the db elsewhere.
Do you HAVE to have ms access on the machine to access the data this way? We tried of course and got "data provider could not be initilized". Is there a way around that?
View Replies
View Related
A freshly installed IIS on my Windows XP SP2 does not allow anonymous
acces to the default ASP file (localstart.asp). I just used default
configuration for installation, which enables anonymous access. But
when I load http://localhost I just get a login box. A simple
index.html placed manually for debugging purpose loads without login
prompt.
I am testing the same thing on a Windows XP (w/o SP2). ASP works for
anonymous access like a charm.
View Replies
View Related
We have an issue where we need to control access to specific web pages e.g. if one user is editing a purchase requisition another user shouldn't be able to perform any actions on it.
I presume we could lock the purchase requisition for editing by a specific user when an edit button is pressed. Only that user would then be able to edit the document. However can anyone think of any better approaches to this issue which I presume must be quite common in other application domains.
View Replies
View Related
I am working on a CMS website which uses a access database.
When a user adds a page a record is added to a table in the database. The user choses the page style from a selection of 7 or 8 layouts.
I have been asked to find out if I can password protect one of those pages??
I have tried a few sites but not found much. The it has been done before is to add a password protected layout and build a login area into the site.
The effect i want is for the user to click the page and a username and password box will apear?
View Replies
View Related
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?
View Replies
View Related
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 Related
is 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 Related
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies
View Related
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies
View Related
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
View Replies
View Related
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies
View Related
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
View Replies
View Related
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
View Replies
View Related
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies
View Related
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies
View Related
We 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?
View Replies
View Related
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 Related
I 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 Related
When 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.
View Replies
View Related
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.
View Replies
View Related
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 Related
I 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.
View Replies
View Related
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..?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 Related
According 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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related