data access page

[mr moe]

cbearden, did you fiqure out how to do it. I"m trying to do the same, I want a simple way, what I want is to place the database in a folder on the network. I'm trying to create a DAP page with a query. Thanks.

 

[cbearden]

cbearden, did you fiqure out how to do it. I"m trying to do the same, I want a simple way, what I want is to place the database in a folder on the network. I'm trying to create a DAP page with a query. Thanks.

not really. I did export the query as an ASP(active server page). I was going to make a link to the ASP on the DAP. It did work...sorta. The page came up with a table and the headings that i wanted but it didn't have the results. It was like it wasn't connected to the database. That's the problem i'm having now.

 

[mr moe]

Inorder to be able to save as asp what software should you have. I just exported my qry to asp but the file shows as a window icon meaning I can't run it. Please advise.

 

[cbearden]

Inorder to be able to save as asp what software should you have. I just exported my qry to asp but the file shows as a window icon meaning I can't run it. Please advise.

open it with Internet Explorer
right click it
Open with...
browse for internet explorer

that should work. did for me.

 

[Kodo]

open it with Internet Explorer
right click it
Open with...
browse for internet explorer

that should work. did for me.

ASP is a runtime language. A browser alone cannot execute ASP code, only HTML. In order for ASP code to be executed, it must reside on a web server that supports ASP, namely IIS (Internet Information Services). IIS is a component install for Windows 2000/XP/2003.

 

[mr moe]

Well I have windows 2000 does that mean that it should work. When I save as a query as asp I get a window asking for info for example data source name, what should I type?????????

 

[cbearden]

windows 2000 here too.

when i create one, it comes up with "Output Options"
under The datasource name i put the location of my database.

perhaps this is an area where i'm possibly doing somehting wrong.

 

[Kodo]

Well I have windows 2000 does that mean that it should work. When I save as a query as asp I get a window asking for info for example data source name, what should I type?????????

Don't make any ASP pages with ACCESS. The other thread you posted has a link to lessons on how to program with ASP.

I know some people may look at me funny when I keep suggesting that people steer clear of DAP, but DAP is just so.. butt ugly and inflexible. Take a look at the lessons (Posted again below).

Trust me, it's rather quick to learn if you're familiar with VBA.
http://www.haneng.com/Lessons.asp

If you have Windows 2000, you have the ability to install IIS. Add/Remove in the control has an option on the left to install windows components. Listed as one of the components is IIS. You may need to read about how to configure a website using IIS and it's quite simple really.

TIPS: WHen you install IIS, a user is added to your system called IUSR_[machinename] where machine name is the name of your machine. That user must have MODIFY rights to any directory that it will write to. That means the directory in which the database resides must have modify rights assigned ot it for IUSR_. Note Rights assignments are only required for NTFS filesystem.