PC Review


Reply
Thread Tools Rate Thread

Access and Web Development

 
 
FatMan
Guest
Posts: n/a
 
      27th Aug 2008
Hi all:
I have a database program that I would like to add a web interface for.
That is to say I would like users to be able to navigate to my database
through the web, log into the interface and add/modify/delete records that
pertain only to them.

The database and code is ready to go but I would like to hear what peoples
thoughts and opinions are as to what programming language is best to use for
the web interface and why? Should I use Java, C, C++, C#, etc.

All replies are greatly appreciated.

Thanks,
FatMan

 
Reply With Quote
 
 
 
 
Rick Brandt
Guest
Posts: n/a
 
      28th Aug 2008
FatMan wrote:
> Hi all:
> I have a database program that I would like to add a web interface
> for. That is to say I would like users to be able to navigate to my
> database through the web, log into the interface and
> add/modify/delete records that pertain only to them.
>
> The database and code is ready to go but I would like to hear what
> peoples thoughts and opinions are as to what programming language is
> best to use for the web interface and why? Should I use Java, C,
> C++, C#, etc.
>
> All replies are greatly appreciated.


What is already in place? Do you already have a web server or will you be
setting up a new one? If an existing one you will need to see which of
those it will support and which would require changes.

Which technology/language are you already familiar with? That would be the
best choice. If you are familiar with none of them I'm sure
representatives/advocates of each would provide many reasons why their
preferred platform is the one you should use. I imagine that ASP.Net would
be among the easiest to learn from scratch. At least for someone already
famiiar with other MS development tools.

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


 
Reply With Quote
 
FatMan
Guest
Posts: n/a
 
      28th Aug 2008
Rick:
Thanks for the comments.

Yes, it is a new web server and whatever language will be used to complete
the interface between the web and my existing access database will need to be
learnt. I have done some searches at the local (Canadian)
universities/colleges and have found courses being offered in Java, C, C++
and C# but not ASP.net. As I have said I have searched Canadian
universities/colleges for online courses but do not/will not limit myself to
Canadian schools if someone knows of a good language and course to go with it.

Do you know of a good course in ASP.net?

Thanks,
FatMan

"Rick Brandt" wrote:

> FatMan wrote:
> > Hi all:
> > I have a database program that I would like to add a web interface
> > for. That is to say I would like users to be able to navigate to my
> > database through the web, log into the interface and
> > add/modify/delete records that pertain only to them.
> >
> > The database and code is ready to go but I would like to hear what
> > peoples thoughts and opinions are as to what programming language is
> > best to use for the web interface and why? Should I use Java, C,
> > C++, C#, etc.
> >
> > All replies are greatly appreciated.

>
> What is already in place? Do you already have a web server or will you be
> setting up a new one? If an existing one you will need to see which of
> those it will support and which would require changes.
>
> Which technology/language are you already familiar with? That would be the
> best choice. If you are familiar with none of them I'm sure
> representatives/advocates of each would provide many reasons why their
> preferred platform is the one you should use. I imagine that ASP.Net would
> be among the easiest to learn from scratch. At least for someone already
> famiiar with other MS development tools.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>

 
Reply With Quote
 
Alex Dybenko
Guest
Posts: n/a
 
      28th Aug 2008
Hi,
you can also consider using SharePoint server and then link its tables to
access. no need to program at all.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"FatMan" <(E-Mail Removed)> wrote in message
news:6EFCAFD2-3EC5-404E-B429-(E-Mail Removed)...
> Rick:
> Thanks for the comments.
>
> Yes, it is a new web server and whatever language will be used to complete
> the interface between the web and my existing access database will need to
> be
> learnt. I have done some searches at the local (Canadian)
> universities/colleges and have found courses being offered in Java, C, C++
> and C# but not ASP.net. As I have said I have searched Canadian
> universities/colleges for online courses but do not/will not limit myself
> to
> Canadian schools if someone knows of a good language and course to go with
> it.
>
> Do you know of a good course in ASP.net?
>
> Thanks,
> FatMan
>
> "Rick Brandt" wrote:
>
>> FatMan wrote:
>> > Hi all:
>> > I have a database program that I would like to add a web interface
>> > for. That is to say I would like users to be able to navigate to my
>> > database through the web, log into the interface and
>> > add/modify/delete records that pertain only to them.
>> >
>> > The database and code is ready to go but I would like to hear what
>> > peoples thoughts and opinions are as to what programming language is
>> > best to use for the web interface and why? Should I use Java, C,
>> > C++, C#, etc.
>> >
>> > All replies are greatly appreciated.

>>
>> What is already in place? Do you already have a web server or will you
>> be
>> setting up a new one? If an existing one you will need to see which of
>> those it will support and which would require changes.
>>
>> Which technology/language are you already familiar with? That would be
>> the
>> best choice. If you are familiar with none of them I'm sure
>> representatives/advocates of each would provide many reasons why their
>> preferred platform is the one you should use. I imagine that ASP.Net
>> would
>> be among the easiest to learn from scratch. At least for someone already
>> famiiar with other MS development tools.
>>
>> --
>> Rick Brandt, Microsoft Access MVP
>> Email (as appropriate) to...
>> RBrandt at Hunter dot com
>>
>>
>>


 
Reply With Quote
 
FatMan
Guest
Posts: n/a
 
      28th Aug 2008
Alex:
Are you saying that I can use SharePoint server on a server that is
available to my users (outside of the company) so they can gain access to my
database program? What would the meechanics be to accomplish something like
this? I have no experience with SharPoint server.

Thanks for your comments,
FatMan

"Alex Dybenko" wrote:

> Hi,
> you can also consider using SharePoint server and then link its tables to
> access. no need to program at all.
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
> "FatMan" <(E-Mail Removed)> wrote in message
> news:6EFCAFD2-3EC5-404E-B429-(E-Mail Removed)...
> > Rick:
> > Thanks for the comments.
> >
> > Yes, it is a new web server and whatever language will be used to complete
> > the interface between the web and my existing access database will need to
> > be
> > learnt. I have done some searches at the local (Canadian)
> > universities/colleges and have found courses being offered in Java, C, C++
> > and C# but not ASP.net. As I have said I have searched Canadian
> > universities/colleges for online courses but do not/will not limit myself
> > to
> > Canadian schools if someone knows of a good language and course to go with
> > it.
> >
> > Do you know of a good course in ASP.net?
> >
> > Thanks,
> > FatMan
> >
> > "Rick Brandt" wrote:
> >
> >> FatMan wrote:
> >> > Hi all:
> >> > I have a database program that I would like to add a web interface
> >> > for. That is to say I would like users to be able to navigate to my
> >> > database through the web, log into the interface and
> >> > add/modify/delete records that pertain only to them.
> >> >
> >> > The database and code is ready to go but I would like to hear what
> >> > peoples thoughts and opinions are as to what programming language is
> >> > best to use for the web interface and why? Should I use Java, C,
> >> > C++, C#, etc.
> >> >
> >> > All replies are greatly appreciated.
> >>
> >> What is already in place? Do you already have a web server or will you
> >> be
> >> setting up a new one? If an existing one you will need to see which of
> >> those it will support and which would require changes.
> >>
> >> Which technology/language are you already familiar with? That would be
> >> the
> >> best choice. If you are familiar with none of them I'm sure
> >> representatives/advocates of each would provide many reasons why their
> >> preferred platform is the one you should use. I imagine that ASP.Net
> >> would
> >> be among the easiest to learn from scratch. At least for someone already
> >> famiiar with other MS development tools.
> >>
> >> --
> >> Rick Brandt, Microsoft Access MVP
> >> Email (as appropriate) to...
> >> RBrandt at Hunter dot com
> >>
> >>
> >>

>
>

 
Reply With Quote
 
Alex Dybenko
Guest
Posts: n/a
 
      28th Aug 2008
Hi,
not exactly. With SharePoint you can create tables (called lists in
SharePoint) and make web forms so users can enter information there.
Then you can link access mdb to that lists, so same time you can enter data
in access.
of course there are some limitations with these lists.
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"FatMan" <(E-Mail Removed)> wrote in message
news:C021DFB4-B764-40A5-BB77-(E-Mail Removed)...
> Alex:
> Are you saying that I can use SharePoint server on a server that is
> available to my users (outside of the company) so they can gain access to
> my
> database program? What would the meechanics be to accomplish something
> like
> this? I have no experience with SharPoint server.
>
> Thanks for your comments,
> FatMan
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> you can also consider using SharePoint server and then link its tables to
>> access. no need to program at all.
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>> "FatMan" <(E-Mail Removed)> wrote in message
>> news:6EFCAFD2-3EC5-404E-B429-(E-Mail Removed)...
>> > Rick:
>> > Thanks for the comments.
>> >
>> > Yes, it is a new web server and whatever language will be used to
>> > complete
>> > the interface between the web and my existing access database will need
>> > to
>> > be
>> > learnt. I have done some searches at the local (Canadian)
>> > universities/colleges and have found courses being offered in Java, C,
>> > C++
>> > and C# but not ASP.net. As I have said I have searched Canadian
>> > universities/colleges for online courses but do not/will not limit
>> > myself
>> > to
>> > Canadian schools if someone knows of a good language and course to go
>> > with
>> > it.
>> >
>> > Do you know of a good course in ASP.net?
>> >
>> > Thanks,
>> > FatMan
>> >
>> > "Rick Brandt" wrote:
>> >
>> >> FatMan wrote:
>> >> > Hi all:
>> >> > I have a database program that I would like to add a web interface
>> >> > for. That is to say I would like users to be able to navigate to my
>> >> > database through the web, log into the interface and
>> >> > add/modify/delete records that pertain only to them.
>> >> >
>> >> > The database and code is ready to go but I would like to hear what
>> >> > peoples thoughts and opinions are as to what programming language is
>> >> > best to use for the web interface and why? Should I use Java, C,
>> >> > C++, C#, etc.
>> >> >
>> >> > All replies are greatly appreciated.
>> >>
>> >> What is already in place? Do you already have a web server or will
>> >> you
>> >> be
>> >> setting up a new one? If an existing one you will need to see which
>> >> of
>> >> those it will support and which would require changes.
>> >>
>> >> Which technology/language are you already familiar with? That would
>> >> be
>> >> the
>> >> best choice. If you are familiar with none of them I'm sure
>> >> representatives/advocates of each would provide many reasons why their
>> >> preferred platform is the one you should use. I imagine that ASP.Net
>> >> would
>> >> be among the easiest to learn from scratch. At least for someone
>> >> already
>> >> famiiar with other MS development tools.
>> >>
>> >> --
>> >> Rick Brandt, Microsoft Access MVP
>> >> Email (as appropriate) to...
>> >> RBrandt at Hunter dot com
>> >>
>> >>
>> >>

>>
>>


 
Reply With Quote
 
David W. Fenton
Guest
Posts: n/a
 
      28th Aug 2008
=?Utf-8?B?RmF0TWFu?= <(E-Mail Removed)> wrote in
news:F3D8A7A2-109A-497F-B429-(E-Mail Removed):

> I have a database program that I would like to add a web interface
> for. That is to say I would like users to be able to navigate to
> my database through the web, log into the interface and
> add/modify/delete records that pertain only to them.


Are you sure that hosting it on Windows Terminal Server and allowing
them to run it via Remote Desktop would not be a much, much easier
approach? There are RDP clients for even non-Windows OS's. For those
users, it would be a bit more complicated for the users than using
their browser, but it would require no development work whatsoever
to deploy it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 
Reply With Quote
 
Rick Brandt
Guest
Posts: n/a
 
      29th Aug 2008
FatMan wrote:
> Rick:
> Thanks for the comments.
>
> Yes, it is a new web server and whatever language will be used to
> complete the interface between the web and my existing access
> database will need to be learnt. I have done some searches at the
> local (Canadian) universities/colleges and have found courses being
> offered in Java, C, C++ and C# but not ASP.net. As I have said I
> have searched Canadian universities/colleges for online courses but
> do not/will not limit myself to Canadian schools if someone knows of
> a good language and course to go with it.
>
> Do you know of a good course in ASP.net?


Well with .net you would be programming in one of the CLR languages of which
C# is one so a C# class would aid you in developing an ASP.Net solution.

When dealing with web development you are actually learning a whole
collection of new skills. The programming language being just one of those
things.

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


 
Reply With Quote
 
FatMan
Guest
Posts: n/a
 
      29th Aug 2008
Dave:
Thanks for the input I appreciate it.

I guess a Windows Terminal Server would be much easier to implement but how
would we handle the printing of reports. I would most likely have 50 users
and they will want to run the reports and print them at their remote
location. How does Terminal Server handle the printing back to the client?
You also mentioned non-Windows OS's RDP clients...can you name a few or point
me in the correct direction?

Thanking you for your help.
FatMan


"David W. Fenton" wrote:

> =?Utf-8?B?RmF0TWFu?= <(E-Mail Removed)> wrote in
> news:F3D8A7A2-109A-497F-B429-(E-Mail Removed):
>
> > I have a database program that I would like to add a web interface
> > for. That is to say I would like users to be able to navigate to
> > my database through the web, log into the interface and
> > add/modify/delete records that pertain only to them.

>
> Are you sure that hosting it on Windows Terminal Server and allowing
> them to run it via Remote Desktop would not be a much, much easier
> approach? There are RDP clients for even non-Windows OS's. For those
> users, it would be a bit more complicated for the users than using
> their browser, but it would require no development work whatsoever
> to deploy it.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
>

 
Reply With Quote
 
David W. Fenton
Guest
Posts: n/a
 
      29th Aug 2008
=?Utf-8?B?RmF0TWFu?= <(E-Mail Removed)> wrote in
news:7ECCF522-2D99-4FEE-94A5-(E-Mail Removed):

> I guess a Windows Terminal Server would be much easier to
> implement but how would we handle the printing of reports. I
> would most likely have 50 users and they will want to run the
> reports and print them at their remote location. How does
> Terminal Server handle the printing back to the client?


The server has to have a printer drivers installed on it that are
compatible with the local default printer. If that's already in
place, the user does nothing -- by default the printer on the server
gets mapped to the local default printer. The problems come when you
have to support users with a bunch of exotic and various printers.
In a satellite office situation, it's much simpler, as you know what
the local printers are and can easily install the drivers for them
on the terminal server.\

> You also mentioned non-Windows OS's RDP clients...can you name a
> few or point me in the correct direction?


The MS website provides the downloads for non-Windows OS (just as
they do for Windows).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 development in Access 2010 Macsmasher Microsoft Access VBA Modules 3 24th Apr 2010 05:50 PM
Re: Where to go from here w/ MS Access and Web development ? Spero Microsoft Access Form Coding 1 29th Nov 2009 11:53 PM
Access development =?Utf-8?B?Y20=?= Microsoft Access VBA Modules 21 5th Jul 2007 05:10 PM
Should I use Access for development =?Utf-8?B?R3JlZW50aHVtYg==?= Microsoft Access Getting Started 6 9th Jan 2005 05:25 PM
Access Development =?Utf-8?B?cHJlZHdpbmU=?= Microsoft Access 3 9th Dec 2004 09:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:05 PM.