Where to start...databases and ASP

[neillovell]

Hello,
I have a database that I've just copied to a network folder. I have a form which I've saved as a data access page, with the view to input and display data. Unfortunately this is not working due to the limitations of Data Access Pages.

What I think I'll need to do is to write some .asp pages that can

1) display certain records based on the current user
and
2) allow data entry



Where do I start? I've done very very little asp programming, and this project has to be completed ASAP - can anyone help?

 

[onpnt]

assumingly you have IIS to run the ASP pages
seeing as I have no idea where you really are here's some links in the stages you need to perform to connect to the DB and then show the data and modify it.

the connection string

http://mavweb.net/asp-samples/database-connection-strings.asp

view the records and input data

http://www.codeave.com/asp/code.asp?u_log=58

did you have anything started? or a spot in the process you are stuck on that we can focus on.
A language that doesn't affect the way you think about programming is not worth knowing.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[neillovell]

The project is almost finished but this one sticking point is the problem. In my queries I use CurrentUser() to filter only those records that have the current user's name in them. Unfortunately when you surf to a data access page and it runs the query to get the data, the function CurrentUser() is not defined according to the browser. If I set the query to return all records where name = 'neil-lovell' it would work, but because I use CurrentUser() it fails every time.

The database has been copied to a network folder and works perfectly, apart from this bit.