Accessing database through web

[Jay]

Hi all,

I posted a similar question a few weeks back, regarding web publishing an
Access database. I did use the conversion feature in Access 97 and it
completely butchered my forms. I was warned that using the conversion
feature required a lot of additional work.

So I'm wondering what if I just started from scratch to create my forms
using another program? And access the DB through that?

Does anyone have any suggestions/horror stories regarding appropriate
programs to allow access to an access 97 BE through the web?

What I'm hoping I can do is eliminate any version issues that users may have
as the DB is Access 97 and users have different versions on their computer.
It would save me from having to compile a new MDE for each version.

Any suggestions are welcome, and if you have any articles to refer me to
PLEASE pass them on. I'd rather have some official looking references when I
go to the bean-counters. =)

Thanks!
Jay

 

[Rick Brandt]

Hi all,

I posted a similar question a few weeks back, regarding web
publishing an Access database. I did use the conversion feature in
Access 97 and it completely butchered my forms. I was warned that
using the conversion feature required a lot of additional work.

So I'm wondering what if I just started from scratch to create my
forms using another program? And access the DB through that?

Does anyone have any suggestions/horror stories regarding appropriate
programs to allow access to an access 97 BE through the web?

What I'm hoping I can do is eliminate any version issues that users
may have as the DB is Access 97 and users have different versions on
their computer. It would save me from having to compile a new MDE for
each version.

Any suggestions are welcome, and if you have any articles to refer me
to PLEASE pass them on. I'd rather have some official looking
references when I go to the bean-counters. =)

Thanks!
Jay

You have to understand how web "apps" work. The tool that will be accessing the
database is going to be running on the web server, not on the client PC so what
software the user has should be irrelevant. All they should need is a web
browser.

 

[Jay]

Sorry, I should have made that clearer.

I meant what development software would you recommend. ASP, JSP, etc.

Jay

 

[Rick Brandt]

Sorry, I should have made that clearer.

I meant what development software would you recommend. ASP, JSP, etc.

Generally the best one to use is the one with which you are most familiar. If
you are not familiar with any of them then it's difficult to say. My web app
experience is with Java, but ASP and ASP.Net are popular and I'm sure work very
well.

 

[Tim Ferguson]

Generally the best one to use is the one with which you are most
familiar. If you are not familiar with any of them then it's
difficult to say. My web app experience is with Java, but ASP and
ASP.Net are popular and I'm sure work very well.

Hate to mention it in a MS newsgroup, but PHP (+/- MySQL) has a huge
cooperative user base; will port straight onto a unix webserver if that is
the way you go; and, of course, it's free!

Just a thought


Tim F