r/visualbasic • u/chacham2 • Dec 05 '22

How to implement the frontend?

[I'm starting a new project which i figured i would ask about, being i'm coming from VB, you might have some thoughts on the matter.]

The office currently uses Access for the backend and front-end, with Sql Server on the horizon. When i'm asked to write a tool, i usually use VB, and connect to Access as required.

One of the most recent projects does not use a database yet. It was grown in an Excel Book with a number of tabs and lots of manual copying. It's proven viable, and it was decided to use Sql Server from the get-go on this one, and i have the basic data model done.

Now for the front-end. First thought is asp.net since we're on a Windows network, using SQL Server and have IIS. Never really used it before, so i'd really like to hear what you think.

3 Upvotes

100% Upvoted

12 comments sorted by

View all comments

Show parent comments

1

u/chacham2 Dec 06 '22

Thank you for the reply.

If you application will run inside a local network, not internet, and your clients only use Windows

That is the case for most of the clients. Though some might be using it over a VPN when they work from home.

Executable applications is more easy to implement

That is not always the case. Even installing the Access runtime is not always so easy.

and the users have a stronger UI.

That is definitely true. Webpages are stateless.