Access backend and VB.net front-end

  • Thread starter Rick Westin via AccessMonster.com
  • 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
 
B

Brendan Reynolds

Yes, it is possible. Not sure what thoughts/solutions you're looking for
here, though? Did you have a specific question?
 
R

Rick Westin via AccessMonster.com

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
 
B

Brendan Reynolds

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.
 
Top