Some Advice Please

G

Guest

Hi All,

I need some advice please. I have very good knowledge of MS Access, Excel
etc, reasonable knowledge of VBA and some very basic knowledge of VB6 and
virtually non-existant knowledge of web based 'stuff'.

I wish to build an application which will allow the user to enter a company
and some information about it, once certain information is added, it will
allow the user to run certain reports. This information needs to be stored
and linked to that user, so next time he/he enters the app, they can look at
a list of their own clients but nobody elses. I could do this quite easily in
MS Access but i want to take it a step futher.

I want it to look really professional, so i think i need to build something
with an Access backend and a VB front end. I also want the ability to make
the application either stand alone or run it from a web site.

I may be wrong here but do i use VB.net to do this? i.e. write a stand alone
app in VB.net and then publish it on our web site (i have a web guy who could
probably do this bit for me) and it would work in exactly the same way?

Is it possible to write something where, when the app is standalone, the
user has to either log in (or uses their windows ID to know who they are) and
when it is on the web it uses their web login to know who they are?

I have seen VB.net and Visual Studio 2005, which is the more up to date,
which one should i use for this? Should i still use an MS Access backend to
store the data? Can i use Word to show the reports to my user? The reports
would contain data and calculations from the app or MS Access backend
(whichever is the most sensible)

Can anyone recommend any good websites or books i can buy to teach me how to
do this sort of thing, or even any templates i could use and then change to
my requirements.

I'm sorry if, i'm very vague and you might think i'm biting off more than i
can chew, but i'm quick to learn and i like a challenge!

Thanks very much for any advice you can give me.
 
V

Vayse

By run from a web site, do mean that the data and the front end will be
stored on a web site? So that all users are looking at the same mdb, which
is stored on the website?

Just some thoughts:
1) If everything is to be stored on the website, you'll need to use ASP. ASP
pages can be written using vb.net . Haven't done this myself.
2) Another option is to distribute the frontend, and store the user setting
locally. Use the vb frontend to access data on the web. Have done this,
where the web based sql server will feed the program XML files.
3) For reporting, I'd recommened the Microsoft Reportviewer. Check out
www.gotreportviewer.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top