I have written most of the easy ASP portion for a MS Access DB insert. In the database, I have about 15 checkboxes in it. Five of them represent a point total of 1 point, 5 of them at 2 points each and 5 at 4 points each. Over time this database will get quite big. In the database, I will mo...more >>

Hi, I am currently developing an ASP application that will be installed on multiple servers by a variety of different users. This application requires that JET 4.0 be installed on the server. I have written a script that checks various other configuration settings (parent paths, buffering...more >>

I was curious how each of you handle database errors instead of getting the OLEDB Micorsoft error screen. Do you have a way of creating userfriendly errors for your users or do you revert and let ADO handle those errors? Thanks, James...more >>

Dear All Expert, I am facing a problem now. I have two web-based application A and B, which using ASP and MS SQL2000 to implement. Sometime, I can login project A, but cannot login project B, the different between the connection of two projects are: in project A I am using ADODB.Conne...more >>

I see the following only works in SQL Server? 'conn.Execute "WAITFOR DELAY '00:00:01'" Is there a version of this that works in MS Access 2003? If not, do any of you have a server-side way to pause? Thanks! -- Scotter ...more >>

How would I integrate a join for the following sql query: SELECT DateTime, u_CurrentBrokerID, u_name, URLCurrent AS Page, COUNT(*) AS Hits FROM UserInquiry WHERE (CHARINDEX('@catamarans.com', u_name) = 0) GROUP BY URLCurrent, DateTime, u_CurrentBrokerID, u_name HAVING (D...more >>

With the help of Gary Jones I constructed a query and attmepted to use the DTS export facility to save and export the query into excel. However, on upon completing the final step in the process I am presented with a security error....Google has not helped...can anyone tell me why this simple ...more >>

Where can i find site about the answers of this group. Gérard. ...more >>

Hi all, thanks in advance. Ok, heres the story. What is happening...... -------------------------------- I've got an ASP page that loops. It loops in order to get data in different, sequential date ranges. I.E. from 9/1/2000 - 10/1/2000 then 10/1/2000 - 11/1/2000 etc etc etc. It calls SPs...more >>

This is on server 2003, access 2000 database, but the version of access doesn't seem to matter. At first I thought it was a general problem updating, but it turns out that this works: update auth_table set auth_level = 'administration' where auth_level = 'administration' and this doesn'...more >>

Could someone help me with a query to Count the number of times a url is selected by a registered user: Table: CurrentURL ------------- ID URL 1 /catamaranco/charter/Inquiry.asp 1 /catamaranco/charter/Inquiry.asp 2 /catamaranco/broker/christine/index.asp 2 /catamaranco/broker/christin...more >>

i'm in a bit of a bind at work. if anyone could help, i'd greatly appreciate it. i have a web app connecting to a sql server using sql server authentication. let's say, for example, my login/password is dbUser/dbUser. the web app however, is using windows authentication. so if I am logged...more >>

Hi all there, I have developed an ASP script that is able to read the structure of an Ms Access database ( via object objConn.OpenSchema(27) ) and to identify the foreign Keys columns and tables (via rstSchema("FK_COLUMN_NAME") and rstSchema("FK_TABLE_NAME")). I wonder whether there is a wa...more >>

Hello, I've a question and tried looking on google but it didnt' came up. I've a Access DB on my webhost, is there any way to protect the details from my host? I read somewhere 'nothing is foolproof', okay I accept. Let me know of *any* steps I can take to prevent, atleast to some extent,...more >>

The below example is a typical example of the problems I am experiencing with something that is probably very easy to resolve, but I just can't do it: Dim arrCheckMatrix ' == check if any selected players are injured strSQL = "select MYNAME from MYTABLE where MYFLAG=1" arrCheckMatrix =...more >>

Hello, I recieve this code on my browser screen "-2147467259 (0x80004005)" each time i load an ASP page; even the simplest one. I even get the error for the http://localhost/ System : Windows XP Pro SP2 , IIS v5.1 Any Clue ?! Thanks Onsi ...more >>

I am trying to get Connection Pooling to work in the ASP code (which runs on IIS 5.0 server) and have tried numerous permutations and combinations but all have failed. Listed are all the connection strings I have tried. However I cannot seem to get connection pooling to work ; I know this as the...more >>

Hi all, What's wrong with the code below? Everything is working fine except the Addnew and the Update lines? All names and paths are correct, when i just read the database there's no problem, it occurs when i want to add/update something. I checked the same code back in Visual Basic and the...more >>

I have an ASP page which connects to an Access database. In my asp page I build a query to return all records where the bandname begins with a selected letter. When I try to open the recordset I get the following error (the actual sql statement is also shown) SELECT Units.BandName, Units.Class...more >>

I have a pair of temp columns: id name 1 bob 2 ted 3 jim 1 jon 1 tim 3 mic 5 tim Any way to query them out to show all the ID=1 with the name in 1 row in an HTML table? id name 1 bob...more >>

After data has been put into a table, how do I then get it to return the unique ID assigned to that record? Regards David ...more >>

Hi! I am planning to migrate my MS Access Project to web based using ASP. The only problem that I see was the report module of ms access that needs third party software. I cannot design a report that can match the actual output from MS Access Report Writer. Can you suggest one that is cost eff...more >>

Hi All My subject question is more of a specific one in that is it best to have on Error resume next on your pages so that your chosen DB (ie MySQL, MS SQL, etc) doesn't blurt out an error message, which could have sensitive info such as table names, db names, etc, to your ASP page? I know ...more >>

Hi All I know the subject sounds strange, but please bear with me. Using ADO/ASP, I want to retrieve a list of pics from my db (which will be dynamic number of pics as a user will be uploading anything from 1 to 12 pics) and put them in a grid (table) of say 3 x 4 cells. I think this is e...more >>

Hi All I'm using .getRows() with a local var array instead of doing a recursive loop so that I'm being a good ASP newvbie and closing my object i/o's (the recordset in this case) as quick as possible. My problem is that I can't seem to use this to complete good effect because the IsArray st...more >>

Hi there, I'm trying to delete multiple records from a access table in ASP... using the recordsets Filter property and adAffectGroup command. It doesn't work, yet according to the reference book I have, it should. Since the reference does not of course say what to do if it doesn't! wor...more >>

Getting a bit confused on passsing params to a stored procedure. I have created and verfied a query that accepts one paramter, a text field, in MsAcces2000. INSERT INTO tblOrderDetails ( OrderID, GarmentType, Qty, Problem ) VALUES (1, [GarmentType], 5,'torn'); When trying to call the procedur...more >>

how do i call run or execute a DTS package from an APS (aspx) page? platform win2k iis (the one that comes with win2k) sql server 2000 - with a test dts package ready to be called ..NET framework 1.1 installed and working correctly web matrix is being used to create the files. would p...more >>

Hi, I have code where I would like to display the contents of HTML stuff if one condition is satisfied and not when the other condition is satisfied (but error message)i.e. when Session("authenticated") = False then I do not want to display HTML contents. How does one do that? Presently, the H...more >>

Hi... I went to the page http://www.aspfaq.com/show.asp?id=2126 to check how to connect to oracle... So my string looks like this... "Provider=MSDAORA.1;Password=PWD;User ID=HECTOR;Data Source=SRV-QUEORA1-DEV1;Persist Security Info=True" but when I try to connect, it gives me this messag...more >>

Hi - see if you can get your head around this one. In the db (access), got many tables interlinked. There are about a dozen departments, which they select on the previous page, where most of the data is entered into a table. Each department has a code - just a number from 1- 30 or something...more >>

Hi - see if you can get your head around this one. In the db (access), got many tables interlinked. There are about a dozen departments, which they select on the previous page, where most of the data is entered into a table. Each department has a code - just a number from 1- 30 or something. t...more >>

I posted this over in the SQL forum, but I think it was the wrong place. My apologies. SQL2K - I have a list that can be printed out in one column of company names and addresses, but they would like to have this in 2 column format. They don't want me to rewrite anything, just add a colum...more >>

Hi, I have part of a form as following: <tr> <td>Referee</td> <td><input TYPE="checkbox" NAME="chkReferee" VALUE="1"></td> </tr> In the above a checkbox is placed in a form which uses POSt method to write to database. The registrationconfirmation.asp page writes to the database after ...more >>

I have some code running in the field on a test server. It is an asp app executing a VB "dll". I have written stuff to the event log to debug my code which is not working. (Or I would not be bugging you all.) A sql string is create, SELECT... A recordset is opened from the string. Then I...more >>

Hi, I'm a new programer with asp, and my question is: I have an access DB in this DB one field is photograph, in this field is saved a photograph (image), When I try to do a report and i want show the field photograph a used response.write and the name of the field, but I got print som...more >>

I've just migrated my web development from Windows 2000 Pro to Windows 2000 Server. The file format on the W2K Pro was FAT32, while the W2K Server is NTFS. Using IIS for the web server for both. I'm now having trouble with multiple simultaneous connections to the ACCESS database, using the JE...more >>

Hi Guys, Since long time i am unable to connect my ms access database to my asp.net page, i have already uploaded my database to my server my asp.net page also but i am unable to connect it, i tried it with server.mappath way and in different ways but result is nothing sometime it does not gi...more >>

I have a 7000 record set in MS Access on a fast server. Broadband connection. Takes quite a bit of time to pull the recordset down to a browser. Makes sense. So... I set up paging and it still seems like it is reading the entire recordset just to display page 1 or page 2 or whatever. I've tri...more >>

I'm looking for a forum system I can run on my Windows2003 Server that uses SQL Server 2000 as it's backend database. A couple weeks ago I found one and I need to refind it. The thing that stood out with that system was: You install it once on your server and it has a control panel that you ca...more >>

Hi! I'm having problem in doing this. I have fields on my table that has a question mark (e.i. Cleared?) and when I try to include this on a SELECT statement on ASP. it gives an error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Dri...more >>

Hello. I am trying to write a function that will insert data into a table. The function will accept the field names as inputs of which there are eight. I keep getting a compilation error Function InsertLifeLine( Stepdate-, STep-, PN-, SN-, SO-, Pass-, Fail-, DrNumber- ) ------------------------...more >>

I have a basic page that returns a resultset of widgets (using an integer identity field amongst others) that i want to provide a better search for. currently i allow the user to seach on description: where widget_desc like '%text%' i also want to allow search on the exact widget_id if th...more >>

I'm trying to add a new record to a recordset, but I get the above error every time. The error comes immediately, rather than waiting the 30 seconds or 300 seconds I have the CommandTimeout set for. It occurs for every combination of LockType, CursorType and CursorLocation (and believe me, I'v...more >>

I have a stored procedure that receives an id from an asp page and deletes the records from three different tables. Do I need to handle errors in this with transactions? If I tried to delete from a table where there was no record it doesn't throw an error does it? I have removed a record fr...more >>

I am having one problem that I have researched and cannot figure out. The following is my scenario. I have part of a website located in the non-secure HTTP folder and the shopping cart part located in the secure HTTPS area. I have a database located in the secure HTTPS area. I am using th...more >>

Is it possible to show a generic error page when a user doesn't have access to the SQL Server? As it is now, if a user doesn't have permission to a DB on the SQL Server, and navigates to a page or app that uses that DB, it gives them a "Page cannot be found" error, with more abotu the error b...more >>

Hi, I have in my possession a large web application which I would like to port to another machine, the application will be set up with the same directory structure for the application but the databases connecting to the applications will reside in different directories. Now the problem is whe...more >>

Hi, I am wondering if this is possible. I have an ASP page that calls a stored procedure (MSSQL). I want to display the status on the ASP page as each process is executed on the Stored Procedure and ASP page. For example, when I connect to the database, show the user that a connection has been...more >>

Hi, I defined a query (name = myquery) in Access like this: SELECT IIf([wwk]='Maandag',[maandag],IIf([wwk]='Dinsdag',[dinsdag],IIf([wwk]='Woens dag',[woensdag],IIf([wwk]='Donderdag',[donderdag],[vrijdag])))) FROM daguur; When executing in Access and filling e.g. 'maandag' as parameter, it wo...more >>