saving database with forms as Data Access Page, or, Active Server Page with functioning code?

saving database with forms as Data Access Page, or, Active Server Page with functioning code?

Post by RCGU » Tue, 14 Jul 2009 22:10:51


I am using Access 2003 and I have a database with Forms with lots of
complicated code. I would like to use a browser interface to replace
the forms. I know that with Access 2003, when I save as a .asp,
Active Server Page, or Data Access Page or some sort of web page, the
form looks good but none of the code transfers / saves / works. Or,
sometimes, the code seems to be embedded in the Data Access Page but
it doesn't seem to work.
Does anyone know if this is still the same with Access 2007? Or, will
the code save and function in A2007? Or, is this possible with Access
2003 and I am just missing something?
Thanks
 
 
 

1. Access 2007 will code save when Forms are saved as .asp or web page?

2. Updating a MS-Access database using Active Server Pages


have been having trouble with updating records in my recordset using the
connection.update method. When I attempt to update the record, I get an
error stating that the database or object is read-only. I've checked the
properties on the database and the directory and am coming up with nothing.
Below is the code I am using to try to update the recordset. Can anyone
offer any assistance?

Set dbConnect2 = Server.CreateObject("ADODB.Connection")
dbConnect2.Mode = adModeReadWrite
dbConnect2.Open "followups"
Set dbFollowups2 = Server.CreateObject("ADODB.Recordset")
Session("FUdbSearch") = "SELECT * FROM followups WHERE Status='Open' AND
Agent='" & Session("UserName") & "' ORDER BY FUDate"
dbFollowups2.Open
Session("FUdbSearch"),dbConnect2,adOpenDynamic,adLockOptimistic
If dbFollowups2.BOF = True and dbFollowups2.EOF = True Then

Else
Session("FollowUpCount") = 0
Do until dbFollowups2.EOF
Session("FollowUpCount") = Session("FollowUpCount") + 1
If Request.Form("FUIndex" & Session("FollowUpCount")) = "on" Then
dbFollowups2("Status") = "Closed"
dbFollowups2.Update
End If
dbFollowUps2.MoveNext
Loop
End If
Set dbConnect2 = Nothing

3. Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net

4. Database Interface -- Form or Data Access Page?

5. Form with PieChart is EMPTY when Saved as Data Access Page??

6. Save/As Form to a Data Access Page

7. Saving forms as Data Access Pages

8. When Paging to Last page then first page some pages are missing data

9. Why can't i edit data in data access page when i set a page's dis.

10. US-TX-Austin: Programmer, MS Access, VB SQL Server, Active Server Pages; DH (45357714410)

11. US-TX-Austin: Programmer, MS Access, VB SQL Server, Active Server Pages; DH (45358757607)

12. US-TX-Austin: Programmer, MS Access, VB SQL Server, Active Server Pages; DH (45358132402)

13. US-TX-Austin: Programmer, MS Access, VB SQL Server, Active Server Pages; DH (45359332409)