Website Form to Access Database (Not ASP)

[LikeLinus]

I've got a website that needs online forms that send the info back to an Access Database. It's a unix based server so I cannot use ASP (the only way I've done it!). The server has CGI. What is the easiest or best way to have a form submit to an access database with this setup? Is there a way to utilize CGI or what would I need?

 

[notfred]

the DBI module with the ODBC driver for Perl will let you connect to an Access database on a windows machine. Writing CGI in perl is very common.

I have a script that does this exact same thing running on one of our machines. i don't think there's any way to do this without a windows box involved, though. I don't think there's anything that will let you just drop the Access file on the unix machine and edit it from a unix application.

 

[LikeLinus]

Originally posted by: notfred
the DBI module with the ODBC driver for Perl will let you connect to an Access database on a windows machine. Writing CGI in perl is very common.

I have a script that does this exact same thing running on one of our machines. i don't think there's any way to do this without a windows box involved, though. I don't think there's anything that will let you just drop the Access file on the unix machine and edit it from a unix application.

Yeah thats what I was worried about. I can't find any online forms that allow you to append directly to an Access database. They all are either flat file databases or MYSQL.

It seems so simple yet I can't find a way to make it work. It's just a simple online form that needs to be stored in an Access Database

 

[znaps]

You can't do it that way, at least the same issues exist with Java. You can't edit or modfy an mdb file programmatically without an MS API in between.

 

[notfred]

Originally posted by: LikeLinus

Originally posted by: notfred
the DBI module with the ODBC driver for Perl will let you connect to an Access database on a windows machine. Writing CGI in perl is very common.

I have a script that does this exact same thing running on one of our machines. i don't think there's any way to do this without a windows box involved, though. I don't think there's anything that will let you just drop the Access file on the unix machine and edit it from a unix application.

Yeah thats what I was worried about. I can't find any online forms that allow you to append directly to an Access database. They all are either flat file databases or MYSQL.

It seems so simple yet I can't find a way to make it work. It's just a simple online form that needs to be stored in an Access Database

The problem is that the only people who have the API for Access are at Microsoft, so you have to go through thier software to edit an Access file.