Access 2007 Web Front end

  • Thread starter Thread starter OD
  • Start date Start date
O

OD

I Have a Access 2007 database, using Access Database(Jet). I would like to
expose some of it to the web. The question is what product should I use, to
setup after I setup a web server. I can move the database to the webserver,
so I can reach back from the website.

Thanks
OD
 
OD said:
I Have a Access 2007 database, using Access Database(Jet). I would like to
expose some of it to the web. The question is what product should I use, to
setup after I setup a web server. I can move the database to the webserver,
so I can reach back from the website.
Click to expand...

Access 2010? Just announced today.
http://channel9.msdn.com/shows/Access/Microsoft-Access-2010-Demo/

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
OD said:
I Have a Access 2007 database, using Access Database(Jet). I would like to
expose some of it to the web. The question is what product should I use, to
setup after I setup a web server. I can move the database to the webserver,
so I can reach back from the website.
Click to expand...

!) Unless you are doing read only with very few updates you should not
be using Access to store data with a web server accessing the data.
Consider upsizing the data to SQL Server. The free SQL Server Express
will work well too.

2) Consider putting only those portions of your app on the web that
customers or external clients need to see. Leave the rest of the
functionality in Access linked to the SQL Server database. After all
why go to all that extra work if you don't need to.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Yeah baby! Now we're rockin'

Tony Toews said:
Access 2010? Just announced today.
http://channel9.msdn.com/shows/Access/Microsoft-Access-2010-Demo/

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
Click to expand...
 
Definitely ASP.NET. Check out this video:
http://www.asp.net/learn/videos/video-49.aspx

That's a small sample of what you can do with a DB and ASP.NET.

You can get ASP.NET for free here:
http://www.microsoft.com/express/vwd/


This product is good too:
http://www.hkvstore.com/aspreportmaker/
http://www.hkvstore.com/aspreportmaker/features.asp

It is easier to learn and you can do some really cool stuff with it. I
think it costs $100, or so.

In the long run, learning ASP.NET will help you much more. You will have a
better skill set, and it will transfer much easier to other jobs, roles,
tasks, etc. ASP.NET takes MUCH longer to master than aspreportmaker. That's
the rub. So, you decide. Is this a one off, or a routine that you will do
over and over?

HTH,
Ryan--
 
Tom van Stiphout said:
The OP said "to the web" which for most people means "to the www"
rather than "to the intranet".
If that's the case, don't forget to mention that A2010 requires
SharePoint, which if you want it to be web-facing, is very expensive:
http://office.microsoft.com/en-us/sharepointserver/FX102176831033.aspx
Click to expand...

Hmmm, very interesting. Never having worked with Sharepoint I didn't
realize it was that expensive for Internet access. Yowzer.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
On Wed, 21 Oct 2009 13:23:00 +0400, "Alex Dybenko"

Sure, but don't keep your breath on getting this flagship product for
free, or anywhere near the price of Access or Office.

And I did not mention that in web-facing SharePoint installations one
would typically use Forms Authentication and SharePoint could be
configured to use a SQL Server back-end. That's another 5 digit cost
if Express Edition (which it ships with) is not enough.

-Tom.
Microsoft Access MVP
 
Yeah, Tony hit the nail on the head. Use SQL Server Express if you are using
ASP.NET; forgot to mention that. You can set up Select, Insert, Update, and
Delete queries, via the browser, and it will run just as smooth as if you
were in the app. itself. I worked as a consultant once, and used Access 2002
as a BE and ASPReportMaker as a FE, and it worked fine. The setup was only
for reporting; I was the only person making changes and hundreds of people
viewed the changes. If you want hundreds of users to make changes, use SQL
Server Express 2008; you can get it for free here:
http://www.microsoft.com/express/sql/default.aspx

Good luck,
Ryan---
 
I did read somewhere that there's an app that will take forms in Access and
convert them to ASP.NET equivalents.
 
David C. Holley said:
I did read somewhere that there's an app that will take forms in Access and
convert them to ASP.NET equivalents.
Click to expand...

This hasn't been updated in some time so it's likely out of date now.

Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET
http://www.granite.ab.ca/access/accesstovb.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
If that's the case, don't forget to mention that A2010 requires
SharePoint, which if you want it to be web-facing, is very
expensive
Click to expand...

Hold on -- does A2010 require SharePoint for any operation or just
if you want to use SharePoint or take advantage of the new web
integration?

If it's the former, then that means I will say goodbye to Access
development entirely, except to support my legacy clients.

I can't imagine it would be true, and that it's just that you've
worded your post ambiguously.
 
I did read somewhere that there's an app that will take forms in
Access and convert them to ASP.NET equivalents.
Click to expand...

I've looked at every one of those products that has come to my
attention and not a single one of them is worth the vice presidency
(i.e., John Nance Garner's comment that is cleaned up to say "not
worth a warm bucket of spit").
 
I did read somewhere that there's an app that will take forms in
Access and convert them to ASP.NET equivalents.
Click to expand...

And to add to my other comment:

A 1:1 translation of an Access app to a web interface would be
bloody stupid, because the UI tools and conventions that work for a
bound application simply can't work for a stateless application (as
is the case for all browser-based apps). It's not just a matter of
being bound, since an unbound Access app won't translate, either.
It's that you just have to break down the processes completely
differently for a brower-based front end than you would for an
Access front end.

In other words, you should never convert an existing Access app to a
browser-based front end. Instead, you should start from scratch and
design a completely independent application interface. The only
thing in common would be the back end database. None of the Access
design would be useble in the browser. None.
 
On 22 Oct 2009 01:53:32 GMT, "David W. Fenton"

Hi David,
Traditional Access development is still available, and in fact it is
improved as well; Tony is talking about new expanded functionality
which requires SharePoint.

-Tom.
Microsoft Access MVP
 
On 22 Oct 2009 01:58:51 GMT, "David W. Fenton"

Amen to that.
I once considered creating such a conversion utility but it can only
work in limited cases. If you have a thorough knowledge of both
environments you'll understand why the general case cannot be solved.

Rewrite it, and take advantage of the best the platform has to offer.

-Tom.
Microsoft Access MVP
 
What I will expose to the internet is view only. I have ms visual studio 2008
stand edition. I will take another look, at asp.net.

Thanks
OD
 
I Have a Access 2007 database, using Access Database(Jet). I would like to
expose some of it to the web. The question is what product should I use, to
setup after I setup a web server. I can move the database to the webserver,
so I can reach back from the website.

Thanks
OD
Click to expand...
as it is not possible to use Access forms in the web ;-((((

I suggest have a look at http://www.ironspeed.com/
for creating web based forms for accessing your data
in Access (or SQL Server ) databases

Greetings

Klaus
 
Klaus-Dieter Gundermann said:
as it is not possible to use Access forms in the web ;-((((
Click to expand...

Actually you could using Terminal Server or Citrix.
I suggest have a look at http://www.ironspeed.com/
for creating web based forms for accessing your data
in Access (or SQL Server ) databases
Click to expand...

Why that tool specifically? What other alternatives exist? Do you
work for that company?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top