Creating an application website with MS Access on a Windows 2000 Server. I have a page where the user can enter in a "startdate" and "enddate"; these become parameters in a saved parameter query, and it works quite well (thanks especially to Bob B for his help with this issue). Since the ...more >>

I have setup a database to record our IP Account from ALL of our routers in a form. It's very slow and sometimes times out.. which is NO GOOD.. I was looking for a better way to manage this data. See below : Sample from one router table data looks like this : source destination packe...more >>

What is the best way to rename a table without breaking esxisting Stored Procs that are dependent on the table....? Thanks Jason ...more >>

Hello, Is such select sql statment allowed? " SELECT * FROM Photo_SubCategory Where (Status = 1 And Session("id") <> "") or (Status = 0 And session("id") <> "" )" Status is a field in the table. Basically I want to selct a record that satisfy when the field Status = 1 and session("id...more >>

I need to know how to group like parts, then count them in asp. I have a table with 60,000 + part numbers that I need a total of each one that is the same. For example. Table: 000000-cpq 000000-cpq 199888-001 199888-001 244166-001 Results: 000000-cpq = 2 199888-001 = 2 24...more >>

Hello, I am creating dynamic images with corresponding checkboxes by pulling data from an Access database. The onchange event of the checkboxes calls a javascript function which basically stores the image name taken from the database into an array. Unfortunately I am having a problem doing ...more >>

Hello I have one field Dt_Time in sql server 2000. I want to insert current Date (if possible then DD/MM/YYYY)and Time in that field..What should be the SQL for that? Any help would be appreciated.. Thanx Dave...more >>

I am new to ASP.NET . I am currently using file dsn to locate my ms access database using ASP. Is this also possible for ASP.NET? If yes, can you help me with the code? Mark ...more >>

I have three tables: class - table of classes ---------- classID className classtypeID classtype - table of class types -------------- classtypeID classtype desc ctrlClass - control table to combine class and class type ----------- classID classTypeID Say a person adds a clas...more >>

ok here is my predicament - i have an asp page that calls a dts package to decrypt a file, then the asp processes the decrypted version of the file. my problem the asp is looking for the decrypted version of the the file but can't find it because the dts package hasn't finished doing its wor...more >>

Hi, I have a blank field in the database for Address. How do I refer to that? For ex: Set hrRS = Server.CreateObject("ADODB.Recordset") hrQuery ="SELECT DISTINCT Division,Description,Code,Address FROM tblEV3Location ORDER BY Division,Description;" hrRS.Open hrQuery,adoCon,2,2 ...more >>

In my app I am uploading a text file to the IIS server. I then use a stored procedure on the SQL server to import the text file into SQL. IIS and SQL run on seperate computers. Currently they are in a workgroup configuration. The problem I am having is the SQL server does not have access to th...more >>

I use code like this in order to create a recordset and enter data into the recordset: strSQL = "SELECT * FROM InventoryItemList WHERE Desc LIKE '%red%';" set conn = Server.CreateObject("ADODB.Connection") conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Server.MapPath("database.md...more >>

In ASP (vbscript) is there a way to check to see if a SQL server is online before trying to open a connection? I have a situation where we have a SQL server that may be offline for a couple minutes and right the ASP page returns: Microsoft OLE DB Provider for SQL Server error '80004005' ...more >>

Hi All Bit of general one this, but apart from using Secure Trading or WorldPay for on-line credit card transactions - what are the options for business to accept payments? I've seen the method whereby the order never actually leaves the secure area and the merchant logs in to print the ord...more >>

Trying to retrieve a recordset using a saved parameter query in Access. the query is named "resultsq1x" works fine when i run it within access: SELECT Results.ref, Results.commodity, IMPACTWEB.Field5, IMPACTWEB.Field20 FROM IMPACTWEB RIGHT JOIN Results ON Results.ref=IMPACTWEB.Field5 WHERE...more >>

I am pulling a decimal value from SQL server and trying to use the format currency and format number function. I am using these values in a large string of HTML to be used in a CDONTS Email. If I use the code fragment below the price variable, which is 3.92 in the database, shows up as £392. Whe...more >>

Hi, The name of the field is in variable 'a'. How can i use it into SQL? This doesn't work: <% a="name" set obj = Server.CreateObject("ADODB.Connection") obj.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source =c:\db.mdb") sql="select '" & a & "' from mytable;" set rs=Server.CreateObjec...more >>

I'm struggling with this problem waaaaay to long... i want to generate a letter when a button is clicked on my page. Ms Word should be opened and you should be able to see the document filling up as the code executes... this is the script i wrote: <script language="vbscript"> dim objw...more >>

Hi ! I'm running IIS on windows 2000. I was working on a webapplication using ASP, and everything was working fine. but now all of a sudden it's not working. when i click on a link that leads to an asp-page the file-download window pops up. i've encountered this before, but i can't remember wh...more >>

I'm working with a customer who has an NT Server (I think it's SP3) running IIS 4. We just converted the databases to Access 2000 and loaded Access 200 onto the server (we need to make occasional direct fixes right on the server). After making sure we were using the Jet 4 driver for the ODBC DS...more >>

I have a small ASP/MS Access app that was developed on a laptop (P4 1.6 w.256 MB RAM). On the notebook the database access times are about 2-7 seconds for a custom report. The same report page executed on teh server (IIS 5) takes upwards of 30 seconds. The server is a Dual P4 Xeon, 2GB RAM. ...more >>

Hi, I have recently installed my PC with xpPro / IIS 5.1. I am having alot of problems writing to the hd/DB (Access2000) from ASP pages. I have played with the windows permissions but with no success. Can anyone point me to a good FAQ / Tutorial on setting up permissions in IIS J ...more >>

Can you help me find an asp code that will upload a file from my PC to web server? Mark ...more >>

Hi, The Access table "dayoff" contains following dates: 8/4/2004 till 8/14/2004 (in dd-mm-yy format). 'dat1' and 'dat2' contains dates coming from two combo-boxs. When 'dat1' contains "8/4/2004" and 'dat2' contains "8/9/2004", no problem: there are deleted. When 'dat1' contains "8/10/2004" a...more >>

Trying to convert a page that adds records to a table. Have successfully done it (to a point) using the "saved parameter query". At first it didn't work, kept getting a "page not found" when submitting the new data, so i went back and started revising the query and the asp page to add one par...more >>

Hi, Can i have the Connection object being passed as the parameter from the Component(Dll) i am using to connect to the databaese to the ASP page. Thanks. Syed Khan...more >>

I have created a DB in Access 2000. The Date Field (clientdate) is currently a MEMO field. The date is being entered as: 10 June 2004 21 January 2005 09 September 2004 How would I display this in Date order ? I have tried changing the field type to Date/Time, and setting it to long ...more >>

I am picking up a strange exception error for the following statement: If Rs.EOF OR DATEDIFF("d",rs("DateTime"),NOW()) Then '// End If Is there something wrong with my function ...more >>

I'm using MS-Access and was wondering if there's a way to DELETE a table and reset the primary key which is an AutoNumber field. If I do "DELETE FROM table_name" then all the rows are removed but the AutoNumber isn't initialized; thus, the next the AutoNumber field after the next INSERT is not...more >>

Dear friends, I am working on a App. at my work place, now wanting to set it up at home but for some reason I keep getting this error : ADODB.Command I did some research on the NEt but I am still unable to figure out why I cannot connect to my db. My code: I set up a Vi...more >>

I'm getting the infamous "Cannot update. Database or object is read-only" error, however I'm very unsure as to what could be causing it. My best guess is the db seems to becoming locked for a shortwhile as the problem seems to rectify itself after a while. If I wasn't using access I'd guess i...more >>

I'm trying to import data from an Excel spreadsheet, and write it into a SQL Server database. I know how to read the data from Excel and how to write the data to SQL Server. The part I'm struggling with is moving the data from Excel to the DB. I'd like to just open a recordset from Excel, the...more >>

Hi, I have a command button to print the web page. However, not everything on the page is printed. For an example, my data are organized into tables and that table is big so not everything on the right side gets printed. Is there a way to shrink everything so that everything can be p...more >>

Hi Sorry if I'm off topic but I am a touch desperate We make use of a mysql 4.x hosted by a third party and we use ASP to access this data Our Connection string looks like this: xDb_Conn_Str="DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxxxxxx/xxxxx xx};uid=xxxxxxx;pwd=xxxxxxxxxx;...more >>

Hi, I am using MS Access as database. I need to update the table on the 1st day of every quarter. Is there anyway to achieve ASP or MSAccess. or should I have to make my script as a scheduled job of my OS Regards, Vasanth ...more >>

Hi All, We've written a couple of functions which, when run in VB6 work fine and allow AD users to be updated. When we include the code into an ASP Page and try and update a users information (i.e. Mobile Phone Number) we get a failure as below... Error Number:- -2147467259 Automation erro...more >>

Is there a way to do the SELECT and INSERT in a single SQL statement in MS-Access? ...more >>

I have a application in ASP w/ access db and is the time to transfer all data to a SQL dbs what I have to change in the code to work with SQL and how can I pass the data to SQL Would somebody here give me a guide or steps to start, give me a help or link thank you ...more >>