Webmaster Forum / ASP / Database Access / June 2004

Working with an MS Access database from an ASP webpage and I'm getting an
Exception error...
Error Type:
(0x80020009)

I have a form where a user enters their name, date etc.
i also want them to be able to click on a browse button and select a
file which will then appear in a textbox. when they press submit i
want the file name and path to be put into the database. e.g.

Applies to: Microsoft Front Page 2000, Microsoft Access 2000
Operating System: Windows 2000 Professional
Web Server: IIS 5.0
I've created a very basic registration page called register.asp which consists of a form requesting a username & password, I then used the database wizard ...

Any one has Idea, How to use Server.Transfer and Server.Execute, When I
tried to use these methods I got an eror:
Server object error 'ASP 0230 : 80004005'
Server.Transfer Error

What syntax would you use to dupe a record?
Thanks!

I need to fetch a value in an Access db, so i use a form to pass the
parameter for the SQL statement fromVB client to ASP. After the submit line
in VBscript, i expect the value in order to test it and go further in
VBscript. But my problem is when clicking on the button, that the VB ...

When I use ADOX to get columns(fields) of a table, they are *auto-sorted
alphabetically by name*.
I need to get the list of field names as they appear when I open the MDB
file and view details of the table, *not* sorted by field name

I have a decimal datatype set to precision 5 and scale 2.  When I try to
insert a new record via ASP using a stored procedure, my numbers are rounded
with no decimals (e.g., 2.2 becomes 2, 2.6 becomes 3, etc.).  How can I make
sure the values being entered on my web page are ...

In 'test.htm', there are two Select, one visible, the other invisible. The
second becomes visible only if the number of records in a Access table <2.
There is also a button to start the VB-procedure. I choose first a value
into the first Select (sel1), then i click on the button to ...

I need an input! I am working on an ASP web application that allow
customers to order products from the web site. The products pages show
only 20 products at a time, I would like to avoid to requery the table
every time the user to navigate between pages (I do not know big the

When I use ADOX to get columns(fields) of a table, they are auto-sorted
alphabetically by name.
I need to get the list of field names as they appear when I open the MDB
file and view details of the table.

I have an ASP application with MS Access 2002 backend.
This application I have 20 copies of running on the same server.
Each application is a different web site.
When I come up with a change - usually adding a field to one of the tables

I am wanting to change the web site for the company i work for into a
database driven web site.  This isn't a problem as i have created several
ASP areas for the web site.
What i want to do is re-write the website so it is easier to manage.  It

I have one table with two field in sql server 2000.
Table data looks like this:
Field1   Field2
Admin    Active

I have a form with ship to customer and  bill to customer fields.  Both of
these are required fields.  I want to put a check box in the form and if the
check box is checked then the value of the ship to customer is loaded into
the bill to  customer.  I need this to happen before the ...