Choice of Server / Front end Database structure (1 Viewer)

[Adigga1]

Hello everyone,

We are planning to covert an existing access database to accommodate 300+ users; we are looking at using SQL server as the backbone but are unsure of the Front-end for the users:

-Some may be accessing the database from outside the intra-network, should we go with a .net front end, java or use an access front-end?

Thanks in advance
A...

 

[wazz]

i don't have a lot of experience with this but i would say go with java if users might be accessing the app from many types of (non-windows) systems, otherwise go .net, or asp.net (web app).

p.s. is that 300 concurrent users? how many might access it at one time?

 

[Adigga1]

i don't have a lot of experience with this but i would say go with java if users might be accessing the app from many types of (non-windows) systems, otherwise go .net, or asp.net (web app).

p.s. is that 300 concurrent users? how many might access it at one time?

thanks wazz, I'm anticipating a high number of users accessing at the same time.. hope that helps?

Thanks again for reply.

A...

 

[HiTechCoach]

I would use Access for the front end. For remote users, use Terminal Services to run the Acces front end.

 

[CameronM]

With 300 users hitting the application, including some remotely, I would suggest you're looking at a web application. Microsoft have the free Visual Web Developer (VWD) that offers most of the functionality of the paid versions of Visual Studio. It also supports Access and SQL Server databases straight out of the box.

 

[CameronM]

Also, don't forget the free SQL Server version - called SQL Server Express. You would be hard pressed to find a better alternative for most web applications - although you may want to check the file size limitations if you are planning on processing a huge amount of data. You can also use the Upsizing Wizard in Access to migrate your data across.

 

[SQL_Hell]

I would use Access for the front end. For remote users, use Terminal Services to run the Acces front end.

WTF, are you serious?

 

[SQL_Hell]

I agree that a web appplication is clearly whats needed here