A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Accessing database through web



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2005, 10:10 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Accessing database through web

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
  #2  
Old November 21st, 2005, 10:16 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Accessing database through web

Jay wrote:
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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #3  
Old November 21st, 2005, 10:31 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Accessing database through web

Sorry, I should have made that clearer.

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

Jay

"Rick Brandt" wrote:

Jay wrote:
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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



  #4  
Old November 21st, 2005, 10:41 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Accessing database through web

Jay wrote:
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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #5  
Old November 22nd, 2005, 07:57 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Accessing database through web

"Rick Brandt" wrote in
om:

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.


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Users from differant sites accessing the same Database Matt Database Design 9 May 25th, 2005 10:12 PM
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 11:04 AM
Accessing Database problems Jim Krebs General Discussion 2 November 22nd, 2004 05:25 PM
Archiving A Database PC User General Discussion 2 November 3rd, 2004 12:16 AM
Images in a database Franz General Discussion 10 October 7th, 2004 09:35 AM


All times are GMT +1. The time now is 08:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.