Access and Web solution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello -

I am not sure if this is the correct forum for this question, however, at
least there seems to be some traffic here!

I have a boss that wants me to develop a database that can be put on an
internal web. Is this possible? Actually, he wants me to take quite a few
Excel spreadsheets, put them into an Access database and have the UI from the
Access DB available to certain users on the web.

I have always deployed Access solutions by putting a shortcut on the desktop
for all users who needed to have access (no pun intended) to it . I am not
understanding what would be accomplished by making it available in IE, if
that is even possible.

At any rate, if it is possible, how do I go about doing it? Any help will
be greatly appreciated!!
 
Sandy said:
Hello -

I am not sure if this is the correct forum for this question,
however, at least there seems to be some traffic here!

I have a boss that wants me to develop a database that can be put on
an internal web. Is this possible? Actually, he wants me to take
quite a few Excel spreadsheets, put them into an Access database and
have the UI from the Access DB available to certain users on the web.

I have always deployed Access solutions by putting a shortcut on the
desktop for all users who needed to have access (no pun intended) to
it . I am not understanding what would be accomplished by making it
available in IE, if that is even possible.

At any rate, if it is possible, how do I go about doing it? Any help
will be greatly appreciated!!
Click to expand...

There are numerous ways to create web pages that can retrieve/manipulate data
from a database. When doing so you can choose to use an MDB file for the
database storage and use Jet (the default database engine in Access) for
programmatically interacting with the database. The creation of such web
applications has very little to do with Access though other than perhaps using
Access to build the tables.

So if your boss is thinking that you can use Access to build an interface
(forms, reports, etc..) and then just run that in a web page he is mistaken.
You would be building the application using a web-based technology like ASP,
ASP.NET, Java Server Pages, Javascript, PHP, (the list gets bigger all the
time).

The closest thing that there is to "taking an Acces app and putting it on a web
page" is to build Data Access Pages (Access 2000 and higher). These are pages
that you build in Access and they run in a browser and allow simple interaction
with the database. They are not the same as an Access form, but they can be
used in an intranet when rich features and security are not a concern.
 
Thanks Rick!
--
Sandy


Rick Brandt said:
There are numerous ways to create web pages that can retrieve/manipulate data
from a database. When doing so you can choose to use an MDB file for the
database storage and use Jet (the default database engine in Access) for
programmatically interacting with the database. The creation of such web
applications has very little to do with Access though other than perhaps using
Access to build the tables.

So if your boss is thinking that you can use Access to build an interface
(forms, reports, etc..) and then just run that in a web page he is mistaken.
You would be building the application using a web-based technology like ASP,
ASP.NET, Java Server Pages, Javascript, PHP, (the list gets bigger all the
time).

The closest thing that there is to "taking an Acces app and putting it on a web
page" is to build Data Access Pages (Access 2000 and higher). These are pages
that you build in Access and they run in a browser and allow simple interaction
with the database. They are not the same as an Access form, but they can be
used in an intranet when rich features and security are not a concern.
Click to expand...
 
Back
Top