URGENT! - ASP pages error when RecordSet is applied?!?

Please help, I have a project with a short deadline and I'm already running
into errors. First off... I'm not a programmer, I'm a designer... i do know
a little bit here and there... but I ran into a problem.

I have an Access database file with 7 fields. I setup the ODBC and setup the
database in dreamweaver... everything loaded in fine. When I create a new
asp page I can f12 the page just fine.. everything shows up (if i put
anything on it) but the second i apply a recordset to the page i get a "this
page can not be displayed" error... it's really frustrating and i don't have
any clue what the problem is???

Oh yeah, i have iis setup on my machine and i have it listed as the testing
server... but if i view the asp files (with the recordset in place) on the
testing server, they show up with just code!? like a text file?

Again, I'm not a programmer.. so if anyone can dumb it down for me that
would be great!

Thanks!
dylan

Turn off Friendly Errors in IE to see what the actual arror message is.

--
__________________________________________________ __________
UltraSuite Extension Packages: http://www.ultrasuite.com/
The *most popular* suites of DMX and UD4 Server Behaviors
for ASP, ASP.Net, ColdFusion, JSP, and PHP_MySQL
__________________________________________________ __________

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/yotshop/TMPeqhk7j14sn.asp, line 8


Still no clue? I'm not sure why the file is called "unknown" it's saved as
view.asp ... but of course it's one of dreamweavers weird temp files that
won't show up. If i open the actual .asp file in internet explorer... it
just looks like a bunch of code... I have other asp files that open fine...
so I don't know what the deal is?

PS. there is no other "user" accessing the file... I even re-opened
everything on my pc and it get's the same error.




"Dylan" <dylandebusk (AT) hotmail (DOT) com> wrote

Please help, I have a project with a short deadline and I'm already
running
into errors. First off... I'm not a programmer, I'm a designer... i do
know
a little bit here and there... but I ran into a problem.

I have an Access database file with 7 fields. I setup the ODBC and setup
the
database in dreamweaver... everything loaded in fine. When I create a new
asp page I can f12 the page just fine.. everything shows up (if i put
anything on it) but the second i apply a recordset to the page i get a
"this
page can not be displayed" error... it's really frustrating and i don't
have
any clue what the problem is???

Oh yeah, i have iis setup on my machine and i have it listed as the
testing
server... but if i view the asp files (with the recordset in place) on the
testing server, they show up with just code!? like a text file?

Again, I'm not a programmer.. so if anyone can dumb it down for me that
would be great!

Thanks!
dylan

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/yotshop/TMPeqhk7j14sn.asp, line 8

There are several things that can cause this. Take a look at this Tech Note for the most common causes and fixes.
http://www.macromedia.com/support/ultradev/ts/documents/8004005_cannot_open_unknown.htm

Still no clue? I'm not sure why the file is called "unknown" it's saved as
view.asp ...

The '(unknown)' isn't in reference to your asp file. It is referring to he database file. It can't be accessed so there is no file name to reference, therefore it's 'unknown'

If i open the actual .asp file in internet explorer... it
just looks like a bunch of code... I have other asp files that open fine...
so I don't know what the deal is?

It sounds like the web server is not running or isn't configured properly. See http://www.macromedia.com/support/dreamweaver/ts/documents/app_server_test2.htm

Also, make sure that the very first line of code on the page is

<%@LANGUAGE="VBSCRIPT"%>

--

Dave
-----------------------------------------------------------------
If I were half as smart as people think I am...
I'd be twice as smart as I was before I forgot everything.
(Official victim of CRAFT Syndrome)

Yay it works.. it was the permissions... thanks!


"David R. Wheeler" <dont-want (AT) no (DOT) spam> wrote

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/yotshop/TMPeqhk7j14sn.asp, line 8

There are several things that can cause this. Take a look at this Tech Note
for the most common causes and fixes.
http://www.macromedia.com/support/ultradev/ts/documents/8004005_cannot_open_
unknown.htm

Still no clue? I'm not sure why the file is called "unknown" it's saved as
view.asp ...

The '(unknown)' isn't in reference to your asp file. It is referring to he
database file. It can't be accessed so there is no file name to reference,
therefore it's 'unknown'

If i open the actual .asp file in internet explorer... it
just looks like a bunch of code... I have other asp files that open
fine...
so I don't know what the deal is?

It sounds like the web server is not running or isn't configured properly.
See
http://www.macromedia.com/support/dreamweaver/ts/documents/app_server_test2.
htm

Also, make sure that the very first line of code on the page is

<%@LANGUAGE="VBSCRIPT"%>

--

Dave
-----------------------------------------------------------------
If I were half as smart as people think I am...
I'd be twice as smart as I was before I forgot everything.
(Official victim of CRAFT Syndrome)

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/yotshop/TMPeqhk7j14sn.asp, line

This means you have a table open in design view in access and it doesn't
like it. Try closing all the tables in access - that should fix it.

Grant

Your welcome. Glad it's working for you.

--

Dave
-----------------------------------------------------------------
If I were half as smart as people think I am...
I'd be twice as smart as I was before I forgot everything.
(Official victim of CRAFT Syndrome)