Author Topic: Database with web front end question  (Read 1687 times)

KnacK

  • Global Moderator
  • Autococker
  • Posts: 3039
Database with web front end question
« on: September 14, 2009, 05: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,

Zorchenhimer

  • Autococker
  • Posts: 2614
Re: Database with web front end question
« Reply #1 on: September 14, 2009, 08:59:34 PM »
You don't like MySQL?

KnacK

  • Global Moderator
  • Autococker
  • Posts: 3039
Re: Database with web front end question
« Reply #2 on: September 14, 2009, 09:16:17 PM »
I'm an MS shop.  I already have an sql server.

eMo

  • VM-68
  • Posts: 184
Re: Database with web front end question
« Reply #3 on: September 15, 2009, 12:29:46 PM »
I can only really think of ASP...
I use C# & ASP for all my web-page to database stuff.

Zorchenhimer

  • Autococker
  • Posts: 2614
Re: Database with web front end question
« Reply #4 on: September 15, 2009, 07:52:50 PM »
PHP can access SQL databases fairly easy, and it works with M$ SQL (I haven't tried myself though).

lekky

  • Autococker
  • Posts: 2449
Re: Database with web front end question
« Reply #5 on: September 19, 2009, 04:47:27 PM »
and grab a php framework with sql wrappers (ie codeigniter)