Digital Paint Discussion Board
Digital Paint Community => Other Stuff => Topic started by: KnacK on September 14, 2009, 07:33:51 PM
-
Currently I have several Access databases with (surprise! ) data. My users have a form built from within MS Access. So in order to access this data, you must have the front end mdb file with the form in order to do so.
There are also also 2 asp pages that can pull records from the database. It appears that these asp files are also calling vb pages to do the data queries.
Now here's what I want to do:
- 1. Convert the existing access db to a sql db (NO I AM NOT GOING TO USE MYSQL KTHX)
2. Go from the access entry forms to a web front end.
3. There is also a method of importing data via an xls spreadsheet in to the db so I need to look at that.
With that being said, any recommendations of a language to look at to write these web based data front ends?
I am a n00b when it comes to interfacing a web page to a data base so I'll listen to most advice. If there are any recommended "Dummy's Guides" I'd be interested in hearing about them.
Thanks,
-
You don't like MySQL?
-
I'm an MS shop. I already have an sql server.
-
I can only really think of ASP...
I use C# & ASP for all my web-page to database stuff.
-
PHP can access SQL databases fairly easy, and it works with M$ SQL (I haven't tried myself though (http://us3.php.net/manual/en/book.mssql.php)).
-
and grab a php framework with sql wrappers (ie codeigniter)