On Dec 22, 10:59 am, Ian <ian.sex...@ntlworld.comwrote:
I have an Access 2000 database split front back end, what I want to do
is have some kind of web based front end so users can logon via the
internet and:
1. Enter new records, edit records in the database
2. Apply a filtering systems where records on a report can be limited to
those matching a criteria, then print or PDF this filtered report
including associated pictures.
Several people have given advice about this, some say I should look at
VB.Net, others say look at Alpha Five, I have never used these programs
and don't know much about them. What I am really looking for is a
starting point, what program should I be looking at?
I am sure this question has been asked many time before and is somewhat
complicated but any advice would be appreciated.
I think you will have to have a web site to host the "web based front-
end".
If you haven't got this already, it's likely you will "rent" one.
If you do you, can put your backend on the site and create the front
end on the site with ASP or ASP.NET or other technology.
Or you can rent additionally an internet enabled MS-SQL Server
database as your backend and create the front end in the same way (ASP
or ASP.NET or other technology).
..
An advantage to this is that by using an ADP, or an MDB or ACCDB
(2007) with ODBC, you can maintain an alternate Access front end (for
yourself or other power-user or developer types to whom you give
permissions) linked to that (same) MS-SQL Server backend that your
other users may be interacting with in a more limited manner via the
technology of your choice. From an ADP you can create or modify the
tables, views, stored procedures etc in the backend fairly painlessly.