Web-based data input

[Guest]

I'm working on a ticket writer database. Currently, it has about 10-15
ticket agents using it simultaneously. There is also a read-only 'ticket
portal'
which users may use the retrieve a ticket. This is an classic ASP web page
on our
internal network and uses OLEDB to access the Jet database via an ADODB
connection. The database is not on a web server but is on a shared network
drive. The owners now want to be able to write to the database via the
portal. This would be implemented with .Net. Has anyone done anything like
this? What considerations come into play? Can the table being updated this
way also be updated via the Access database or can it only be viewed? How
does the LDB file behave regarding the web-based accesses.

 

[Guest]

Your main problem will be populating the DataGridView. This is similar to
the "Table View" in a MS ACESS Form.

..Net 2.0 uses a different way of populating data.

They use a TableAdapter and other objects to link a db table to the form.

There are some nice tutorials out there to help you get started.

Also, newer versions of ASP work differently than the old ASP. The old ASP
had HTML and ASP code in one page. ASP 2.0 has one HTML page and a
"Code-Behind" ASP page.