Input to database via web page?

[Guest]

I'm working on a ticket writer database. Currently, it has about 4-6 ticket
agents using it simultaneously. There is also a read-only 'ticket portal'
which users may use the retrieve a ticket. This is an 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. Has
anyone done anything like this? What considerations come into play? Will the
LDB file still reflect current users?

 

[Arvin Meyer [MVP]]

The LDB fileill always reflect the 1 user that's writing to the database,
that being the IIS user (I_USR). A DSN (datasource name) gives the asp page
the path to the database. All data is written using Insert statements from
the asp page.

 

[Aaron Kempf]

Microsoft is going to announce 'SQL Server Forms Services' soon from what
I've heard

until then; it is best to stick with Access Data Projects since this will be
the only product that is compatible with SSFS