data access page

cbearden

Registered User.
Local time
Today, 03:29
Joined
May 12, 2004
Messages
84
does anyone here know much about it?
 
what do you want to know about them?
 
well... i need for someone to be able to run a query from it. i tried to add a cmd button to it like i did on a form but it doesn't have the option of running a query. I also need for the results to be put into a report.
With the query, i tried exporting it to another DAP and it worked, but it only gave me one code(the query searches by codes(y, n, s, p)) and it isn't updated.
 
lets get behind this a bit more. What is your reason for using DAP's. I ask because I typically recommend building an ASP page instead of using DAP's which can be a PITA to work with at times.
 
i am creating this for someone who does not have access to Access and will not get access to it. The DAP will be for them so they can enter info into the database and the query/report so that they can search for codes w/o having to get into the database.
 
cbearden said:
what's asp?
Sorry for the long wait.. been busy.

ASP or even ASP.NET is a web based language that will allow you manipulate data in the database without having to have direct access to the database. DAP is sort of the bastard cousin to ASP.
 
is there a way for them to run a query and get results on a DAP?
 
websites? books?
can someone offer some suggestions that might help me w/ my problem.
thanks.
 
are you hosting the DAP files on a web server? That is to say, hosting them on a real web server, not a workstation with IIS installed. If so, I would highly recommend skipping DAP's and picking up ASP. It's not much different than VBA and you will be able to pick up the language within a few weeks time, maybe less.
 
Last edited:
it'll be accessible on a network. I'll place it in a folder for someone.
 
The only way I know how to do it is by using ASP. You see, the DAP's use DHTML so they'll load in the browser with out having to use a webserver. That pretty much makes it static, with the exception of the ActiveX control they use for navigation etc. To pass a variable on the web, you need to post. You can't POST to an HTML page. So if you want to do something like dynamic SQL by passing a variable, you'll need to POST and to do this you need to use something like ASP on IIS.
 
i did try the ASP...and it is what i want. Thank you!
but...it comes up with "enter code" which i do adn then nothing comes up. The headings "loan date, acct, name, etc." comes up but nothing else. LIke if there was nothing in the table.
 
make sure the datasource is accurate.
 
cbearden said:
how can i edit the page? through access?
You can edit it through access or any text editor.
But in order for your page to connect to the database it must be placed on a webserver using IIS. That is the only way that ASP can be processed.
 
i see iis on my computer. how do i place it on a webserver w/iis?
 

Users who are viewing this thread

Back
Top Bottom