Access backend and VB.net front-end

  • Thread starter Thread starter Rick Westin via AccessMonster.com
  • Start date Start date
R

Rick Westin via AccessMonster.com

We use custom excel workbooks and post them on our intranet with minimal
functionality. Is it possible to use VB.net as the front-end to an Access
database? I'd like to post the VB.net form to our intranet.

Any thoughts / solutions would be appreciated.

Thanks,
Rick
 
Yes, it is possible. Not sure what thoughts/solutions you're looking for
here, though? Did you have a specific question?
 
This will be a VB.net form to click 4 drop downs. From the value in the
drop-downs, the form will display a results set.

Right now the excel solution is slow due to the many hits from the
intranet.

What is your experience with performance with VB.net in the front and the
backend being MSAccess / and possibly later MS SQL Server? Any browser
version can access it right?

I'm also learning Macromedia. Which do you think is a better solution.

Thanks,
Rick
 
The performance of a data-centric application tends to depend much more on
appropriate indexing and careful query design than on what was used to build
the front end.

In my (still limited) experience, it is certainly possible to build a
responsive data-centric application using ASP.NET, but that does not
necessarily mean that replacing your Excel app with an ASP.NET app is going
to automagically improve performance.

If you use ASP.NET, the code executes on the server, and only HTML is
returned to the browser, so yes, it should work with any browser.

I have no experience of Macromedia, so I can't comment on that.
 
Back
Top