Access Database interface conversion to Web base PHP/Dynamic Database

Cancelado Publicado Oct 9, 2012 Pagado a la entrega
Cancelado Pagado a la entrega

**Scope of Work

Project: Sunrise Services Access to PHP

Date: Oct 8th 2012

Situation: Sunrise Services Currently has a DataBase that is MS Access created, recently hosted on an SQL server. This is accessed by most the company, and is used both on the local LAN, remote VPN and/or Terminal Server. There is a major issue in reponse from any user outside the local LAN or Terminal Server. The Data Base is old, it is very static, and has some bugs that need to be fixed. It is locally hosted on a In house SQL server, it is accessed via MS Access with direct file mapping, both locally and VPN. The Version is MS 2000-2003.

Mission: Create a fully web interactive PHP / IIS hosted interface that is only active on the server, give the end users a fully hosted experience with no lag or massive data transfer between Server and User. This new interface would interact directly with the SQL server, and Existing Database. The Access User interface needs to be a web based, SSL secured and access with any device and location. It must use the Active Directory User Authentication that is currently in place, hosted locally. All existing flow and function error in the interface must be fixed. It must also have the ability to add addition and field for future growth and change. **

## Deliverables

**Scope of Work

Project: Sunrise Services Access to PHP

Date: Oct 8th 2012

Situation: Sunrise Services Currently has a DataBase that is MS Access created, recently hosted on an SQL server. This is accessed by most the company, and is used both on the local LAN, remote VPN and/or Terminal Server. There is a major issue in reponse from any user outside the local LAN or Terminal Server. The Data Base is old, it is very static, and has some bugs that need to be fixed. It is locally hosted on a In house SQL server, it is accessed via MS Access with direct file mapping, both locally and VPN. The Version is MS 2000-2003.

Mission: Create a fully web interactive PHP / IIS hosted interface that is only active on the server, give the end users a fully hosted experience with no lag or massive data transfer between Server and User. This new interface would interact directly with the SQL server, and Existing Database. The Access User interface needs to be a web based, SSL secured and access with any device and location. It must use the Active Directory User Authentication that is currently in place, hosted locally. All existing flow and function error in the interface must be fixed. It must also have the ability to add addition and field for future growth and change.

Execution: This is a three part project:

1) Convert the existing access database into a fully working PHP dynamic Database. Create new front end PHP page for end user interacts to replace existing Access Database.

2) Setup and Create servers and log on ability install the roles of hosted IIS and the front end of this database. Perform Network changes that will direct users to the front end web pages. Configure SSL certification and link to Https:// front end

3) Testing and fixing all visual and functions bugs

Administration / Environment: The current network environment of Sunrise Services is about 200+ users, same amount of PC's. 2003 Active Directory Microsoft environment. Server are hosted locally. There is two (2) free server to perform any role needed (standard 2003). The SQL server is new and running fine. The DB size is about 1gb in size: The access interface is 58mb. It is a standard 2000/3 version. All equipment is Dell, All Network is Cisco, There is a 5 pair bonded T1.

Command Control: **

**Brian Lewis; Trading Sphere Platform, Project Executive;**

**The on staff IT team of Hyung Low, and Erik (don't know his last name).**

**Database Engineer:**

Ingeniería Arquitectura de software Verificación de software

Nº del proyecto: #2783738

Sobre el proyecto

1 propuesta Proyecto remoto Activo Oct 31, 2012

1 freelancer está ofertando el promedio de $1000 para este trabajo

hassana19

See private message.

$1000.45 USD en 20 días
(15 comentarios)
4.2