Access backend and VB.net front-end

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Westin - 15 Apr 2005 19:57 GMT

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

Reply to this Message

Brendan Reynolds - 15 Apr 2005 21:22 GMT

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

Signature

Brendan Reynolds (MVP)

> 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
[quoted text clipped - 4 lines]
> Thanks,
> Rick

Reply to this Message

Rick Westin - 15 Apr 2005 21:59 GMT

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

Reply to this Message

Brendan Reynolds - 15 Apr 2005 22:21 GMT

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.

Signature

Brendan Reynolds (MVP)

> 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.
[quoted text clipped - 10 lines]
> Thanks,
> Rick

Reply to this Message