Web access to a database

[Guest]

I need to have an Access database that can be accessed through the web. It
needs to be dynamic so individuals can change their own records and can also
perform searches.

My colleagues say Access is too difficult to do this and are pushing a Lotus
Notes solution. I know Notes workds fairly easily, as i have developed
web-enabled databases using this software. I am, however, looking more for a
Microsoft solution.

 

[Guest]

Hi fog1,

Lotus Notes is NOT a relational database. My advice would be to steer clear
of it if you are after a database.

What sort of database/web solution are you after? Is it to reside on your
intranet, or on an internet site? How many users? These are the questions
you need to answer. If you want an MS solution and it outgrows Access,
there's always ASP.NET/SQL Server etc.

Of course, if your clients are all going to access it on the same LAN, then
why not just client/server with a split Access Database?

These questions and more, just waiting to be answered!!

Damian.

 

[Guest]

This recent thread may have some information useful for you:

http://www.microsoft.com/office/com...979097-8900-4755-87ea-5aba7b6b3b24&sloc=en-us

I agree with Damian's comment if you are all using the same LAN. The easiest
in that case is to just go with a split Access application.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

The database is not going to be accessed through an intranet, it is going to
have access on the internet. As far as numbers of users, it will be about
150. In essence the database is going to be used by doctorial students to
add information to their profiles as they progress through their studies.
Each student will have about a page worth of information, so the database
will not be very large. So basically, while I can create the database, I
need to know how to make it web accessible.

By the way, while Lotus Notes is not considered a pure relational database,
i sure use relational features in every one that i create. Likewise, I don't
plan to argue about the merits of one database over the other. Whateve the
client desires as the software platform is what I use.

Thanks!

 

[Rotsey]

Why not use SQL Server 2005 Express. It is free to use and has all the
concurrent access functionality you need.