Webmaster Forum / ASP / Database Access / March 2006

I'm not sure what the right SQL statement would be.  
In 1 database there's a table of parent companies and a table of child
companies. The parents have a key in their table.  The childs have their own
key plus the parent key in another column.  

When I try to execute the code below in asp I get the following error
message:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.

I have been working on an ASP site www.middlesexccl.com on my localhost.  It
uses a Access MDB and DSNless connections - no issues.
I have uploaded the site and it seems everytime I upload an new version of
the database I am given this error.

I am trying to insert a record into my database but i get syntax error
INSERT INTO
CAn you help? the code is below
' *** Insert Record: construct a sql insert statement and execute it

I have developed an Application which opens an ADO Recordset on the Server
using the following :
Set adoConn=Server.CreateObject("ADODB.Connection")
adoConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data

Hi.  I am reading a foxpro .dbf file and displaying the results on an
asp page.  The page is working fine, but I did notice something
strange.  After the page is done loading the dbf file appears to be
locked for the next minute.  When I try to open it in FoxPro I get a

I have developed an application using frontpage and MS Access, all functions
work correctly on my development system.  Have published the web site to a
production server and all seemed to work.
However when functions add a record the a database table, asp reports that

I need to be able to update a record about 200 characters with a click
of a button.
The user will enter the new text in a textarea called NewsText and then
click on submit button. Right now when clicking on the submit button

I am upgrading from an NT4 IIS4 server to a new Server running 2003 and IIS6
and have a problem with date format in VB.  I have several web pages that use
the date command as part of SQL strings to read or write data to ether an
Oracle, SQL, PI, or Access databases.  The problem ...

Lets say I have an Access database named Database001.
I have a table called Table001.
In the table I have the following fields:
1: Date\Time (an automated date\time stamp when an entry is added)

I am having a problem getting my asp pages to connect.
My database is MS SQL 2000 sp4
MDAC is 2.8
IIS is 6 - Authentication is Anonomous

I am allowing users to save a .vcs file for an event coming from a database.  Everything works correctly except it is showing the incorrect time.  Does anyone have any clues on how to get this to show the time correctly, everything else is great!
------------------------- script ...

Coding an ASP application and I'm creating a Public Function to return the
results from a query. I've been told that it's better to return a recordset
containing the results than it is to return an array.
I'm not sure which would be better, or how I'd handle passing a real

Hi all, I am aware of how to insert into a database the old fashioned
way, but I am trying my hand asp.net and am SURE this isnt the right
way to do it anymore... I am a newbie here - so please forgive me if I
sound stupid... the query I am trying to run is...

I've done this with drop-downs where I loop through a recordset,
populated another drop-down and so forth. But I think this should be
easier, but I'm not sure. I have a table with states, cities and rates.
What I need to do is when a user selects a certain state from a drop