database

[winstonmckoy]

I am in charge of taking my current database in access and convert to be use in a internet server for access through the net allow many user access to there personal data.
I would like to know is this possible and if so what type of server is needed and what type of other software that can help me with this task. The database will be access by many from the internet to see there personal data and the backoffice need access to update information on a daily bases. Other team member want too use SQL statements and I like the features in access97 for development. Is access the soultion or should I look at another ave to deploy this task. Thanks

 

[culshaja]

Depends on the amount of data, users, and hits on the database.
Whatever you want to do, you need an NT Server with IIS and ASP. ASP is used to access the database via VBScript and ADO.
If you are using access then you just put the database on that server. You do not need Access installed unless you want to run Access on that machine rather than access the data remotely.
If there is going to be large amounts of data and/or users and hits on the database, then you would probably want to upsize to SQL Server. The best method of doing this is to have a second NT server, and install SQL Server 7/2000 onto it. You can then access this data via an Access front end within your LAN using linked tables and ODBC.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305