Excellent - that code snippet was spot on.
Before you replied, I tried changing "PWD=" to "Password=" which gave an alternative error, but that's irrelevant now, thanks.
Apologies if this should be in an ASP forum, I wasn't sure so I tossed a coin and "Access Other.." won.
I've got an Access DB which I'm trying to connect to via an ASP page. The DB has a password, but no username and opens fine locally - it prompts me for a password, then opens the...
Thanks,
That makes a bit more sense now. My code is now dropping the table prior to re-creating it but it's a shame I can't access the Stored Queries directly without writing additional SQL in my ASP.
In addition to the above, when I run the SQL code for the sample query directly in my ASP code I get the following error:
Microsoft JET Database Engine error '80040e14'
Table 'H&S_Accidents_Data' already exists.
The query is trying to re-create the specified table by overwriting it with a...
I've got a standalone Access DB (with Forms, code, etc) that I need to create an ASP frontend for.
The problem is that the existing Tables, Fields and Queries don't have very forgiving names, with spaces used throughout. I've also encountered problems with SQL that doesn't seem to be standard...
Sssh - and there I was thinking someone had a constructive reply!!
I've gathered some more information on the array and what's happening/desired output, etc, so please bear with me.
Column orientation should be fixed, but content should be ordered vertically by a given row.
Two-dimensional...
I've been following an example for sorting a two dimensional array using QuickSort (from the 4Guys website) but the sorted result is coming through as Rows,Columns where I need to sort by Column,Rows.
The example can be found at http://www.4guysfromrolla.com/webtech/012799-3.shtml and I...
That'll be a "no" and "thanks" ;)
GetFileName seems to be what I'm after, but I'm not sure on how to perform the pattern matching as it seems the method needs to be supplied with a complete path and filename (the path can be up to 5 levels deep).
Any more info on this...
I need to be able to search through x number of folders and sub-folders, searching for a particular string within a filename (not interested in the content of the file at all) and I wondered if anyone's got any examples they can point my way?
The project uses descriptive filenames with product...
I had a major problem with Session_OnEnd the other day and I came to the conclusion that the Response and Request objects are not available for Session_OnEnd and neither is the MapPath function.
My script was to connect to a DB to perform some tidy up operation. As the DB was in the same...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.