Putting an Access Database online

[sheri]

Hi need your expert advice. I want to put my access database online
so different users in my company can use it. I can put in on a secure
directory on my website. Can you direct me the best way to do this?
Thanks,
Sheri

sh***@mbproducts.com

[sheri]

On Sep 9, 9:16 pm, [e-mail] wrote:

Hi need your expert advice. I want to put my access database online
so different users in my company can use it. I can put in on a secure
directory on my website. Can you direct me the best way to do this?
Thanks,
Sheri

[e-mail]

Would it work just by uploading the file to that directory?

[Rick Brandt]

sh***@mbproducts.com wrote:

On Sep 9, 9:16 pm, [e-mail] wrote:

Hi need your expert advice. I want to put my access database online
so different users in my company can use it. I can put in on a
secure directory on my website. Can you direct me the best way to
do this? Thanks,
Sheri

[e-mail]

Would it work just by uploading the file to that directory?

No. Access cannot be run over the internet. For a reasonably small number of
users you could set up VPNs and let them use Terminal Server to run the app.
Otherwise you need to re-write a web-based front end to replace the Access forms
and reports.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[sheri]

On Sep 9, 9:32 pm, "Rick Brandt" <[e-mail]:

[e-mail] wrote:

On Sep 9, 9:16 pm, [e-mail] wrote:

Hi need your expert advice. I want to put my access database online
so different users in my company can use it. I can put in on a
secure directory on my website. Can you direct me the best way to
do this? Thanks,
Sheri

[e-mail]

Would it work just by uploading the file to that directory?

No. Access cannot be run over the internet. For a reasonably small number of
users you could set up VPNs and let them use Terminal Server to run the app.
Otherwise you need to re-write a web-based front end to replace the Access forms
and reports.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

What would I use to write a web-based front end? Would upgrading my
database to sql server make it easier?

[Albert D. Kallal]

<sh***@mbproducts.comwrote in message
news:11**********************@o80g2000hse.googlegr oups.com...

>
What would I use to write a web-based front end? Would upgrading my
database to sql server make it easier?

You can pick any favorite web based development system you choose. asp.net
would likely be a good bet for you.

Remember, if you going web based, you really don't need ms-access anymore,a
nd in fact you NOT going to be using ms-access at all. So, wrong tool, wrong
newsgroup, and wrong approach.

You can't make the application web based, but you can STILL allow remote use
of the application OVER the internet. That is quite a different issue, but
one that would allow you to continue to use your current application. I
explain this process here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

If you need a web based system, then there absolute NO relation to
ms-access, and none of the code, forms, reports etc. can be used. Plain and
simple, ms-access is not a web system and is of no use if you need a web
based application.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

[AnandaSim]

On Sep 10, 11:46 am, [e-mail] wrote:

What would I use to write a web-based front end? Would upgrading my
database to sql server make it easier?

Your choice of web based front end is determined by:
a. your skill and knowledgebase in the language you choose
b. the availability of that framework on the server that you choose

There is no soft conversion from taking an Access Form or Report and
putting it in a magic box and out comes a server side web page.

See:
http://members.optushome.com.au/anandasim/asp.htm
SQL Server will do more multi-threading and service more per second
requests from more web visitors.

SQL Server offers you 24x7 database backup - Access files cannot offer
you that.

SQL Server is more powerful and more grunt but it is also more work to
master it.

Both SQL Server and Access do not offer you the equivalent of generic
HTML Forms on the Web.
However, SQL Server does offer you SQL Server Reporting Services which
similar in idea to a Report Writer.

[SmartbizAustralia]

You could try linking Access 2007 to SharePoint.

This works nicely and is very simple to do once SharePoint is
installed and setup for secure access (ssl)

If it's just reporting, then migrate your reports into sql server
reporting services.
This again depends on how complex your reports are, but it is a quick
and simple way of reporting over the internet.

Regards,
Tom Bizannes
Sydney, Australia

[Rick Brandt]

SmartbizAustralia wrote:

You could try linking Access 2007 to SharePoint.

This works nicely and is very simple to do once SharePoint is
installed and setup for secure access (ssl)

If it's just reporting, then migrate your reports into sql server
reporting services.
This again depends on how complex your reports are, but it is a quick
and simple way of reporting over the internet.

Regards,
Tom Bizannes
Sydney, Australia

This assumes that all users will use Internet Explorer as their web browser
though right?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[lyle]

On Sep 10, 5:57 pm, "Rick Brandt" <[e-mail]:

This assumes that all users will use Internet Explorer as their web browser
though right?

Rick

I am looking at my server's offering as follows:

"SQL Server Reporting Services (SSRS) is a server-based solution that
enables the creation, management, and delivery of both traditional,
paper-oriented reports and interactive, Web-based reports.

SQL Server Reporting Services supports many common data sources, such
as OLE DB and Open Database Connectivity (ODBC), as well as multiple
output formats such as Web browsers and Microsoft Office applications.
SQL 2005 Reporting Services can connect to SQL 2005 or SQL 2000
databases."

Will the "Web-based reports" run/show or whatever on any main-stream
browser such as Firefox, Netscape or Opera, ... or only on Internet
Explorer?

Will the web application from which the SQL reports have to be a .Net
application? (The server is .Net enabled but my application is classic
ASP).

Any comments, gotchas, whatever?

Lyle

[Rick Brandt]

lyle wrote:

On Sep 10, 5:57 pm, "Rick Brandt" <[e-mail]:

>This assumes that all users will use Internet Explorer as their web
browser though right?

Rick

I am looking at my server's offering as follows:

"SQL Server Reporting Services (SSRS) is a server-based solution that
enables the creation, management, and delivery of both traditional,
paper-oriented reports and interactive, Web-based reports.

SQL Server Reporting Services supports many common data sources, such
as OLE DB and Open Database Connectivity (ODBC), as well as multiple
output formats such as Web browsers and Microsoft Office applications.
SQL 2005 Reporting Services can connect to SQL 2005 or SQL 2000
databases."

Will the "Web-based reports" run/show or whatever on any main-stream
browser such as Firefox, Netscape or Opera, ... or only on Internet
Explorer?

Will the web application from which the SQL reports have to be a .Net
application? (The server is .Net enabled but my application is classic
ASP).

Any comments, gotchas, whatever?

Lyle

At our company we have only dabbled a bit with reporting services, but none
of the pages we have done so far work in anything besides IE. I don't know
if that is an absolute or just the way it has worked out for our particular
pages.

Up to now I have been assuming that RS was strictly an IE thing, but I would
be glad to be informed otherwise.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com