Web Bases Front End

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.

Re: Web Bases Front End

On Dec 22, 10:59 am, Ian wrote:
> 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.

Re: Web Bases Front End

lyle wrote:
> On Dec 22, 10:59 am, Ian wrote:
>> 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.
>
Look at these two web pages:

http://webpages.charter.net/bobalston/Documents/Access-WebCo nversionSoftware.htm

http://webpages.charter.net/bobalston/Documents/Microsoft%20 Access%20Developer%20Transition%20to%20Internet.htm

Bob

Re: Web Bases Front End

Ok it seems like it should be developed in ASP or ASP.NET or Visual
Sudio.net, does anyone have a preference?

Anyone got experience with Alpha Five, a friend keeps telling me its
perfect for the job and easy to develop?

Regards




Ian wrote:
> 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.

Re: Web Bases Front End

Ian wrote:
> Ok it seems like it should be developed in ASP or ASP.NET or Visual
> Sudio.net, does anyone have a preference?
>
> Anyone got experience with Alpha Five, a friend keeps telling me its
> perfect for the job and easy to develop?
>
> Regards
>
>
>
>
> Ian wrote:
>> 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.
BE sure you take a look at Iron speed Designer. There is a somewhat
limited free version. It will take an Access database and create an
entire application automatically. From there you can customize. But it
does not convert Access Forms.

Bob

Re: Web Bases Front End

On Dec 22, 8:40 pm, Bob Alston wrote:
> Ian wrote:
> > Ok it seems like it should be developed in ASP or ASP.NET or Visual
> > Sudio.net, does anyone have a preference?
>
> > Anyone got experience with Alpha Five, a friend keeps telling me its
> > perfect for the job and easy to develop?
>
> > Regards
>
> > Ian wrote:
> >> 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.
>
> BE sure you take a look at Iron speed Designer. There is a somewhat
> limited free version. It will take an Access database and create an
> entire application automatically. From there you can customize. But it
> does not convert Access Forms.
>
> Bob

That's so scary! I guess it's the end of all independent development
work as we know it. Why spend a few thousand to hire Lyle Fairfield
when you can spend that same few thousand and have your own unique web
application created for you, over and over again? It's OK for me cuz
I'm seventy and have been trying to retire for a while anyway, but I
feel sorry for the rest of you guys. And I guess we can roll up the
CDMA carpet as well? Maybe we should make Dec 31 the official end and
have a big party at some central location (maybe David's place?) to
mark the crossing of the bar.

The old order changeth, yielding place to new,
And God fulfils himself in many ways,
Lest one good custom should corrupt the world.