Access backend

[Russ9517]

I'm writing a microsoft access database which will be used by 70+ users but access can't handle that many users well. Is there another program i can use to store the table which will work better?

 

[KenHigg]

I think MS Sql Server would be my first choice.

 

[DCrake]

Simple Software Solutions

When you say 70+ users how many will be logged on at the same time?
How much data to you intend to capture?

CodeMaster:

 

[Russ9517]

it will have around 50 in at a time but running a frontend database from the users harddrive but linking to a database on a network

 

[DCrake]

Simple Software Solutions

This may sound a bit like locking the gate after the horse has bolted, but how far into the development of the application have you reached? A good programmer will have anticipated future/ intended usage.

As mentioned you could export all your data to MS SQL Server and if your MS SQL skills are up to it write stored procedures and view to interrogate the data. Other than that have you backend point to SQL Server via ODBC connections using a system DNS.

Refer to your data using ADODB as opposed to DAO.

CodeMaster: