Good day all.
I have created an access database for the Railway industry to do the following.
1. Register assets. (on Track, Off Track and Structures)
2. Capture and manage Safety inspections. (On 23 Asset types)
3. Capture and manage Condition Inspections (On 14 asset types)
4. Capture and manage Emergency call outs.
5. Plan and manage job cards. (Plan work, Material, teams)
6. Reports (about 68 standard reports)
This is only the main purpose of the database. The Access database is currently 13008KB in size (empty).
Because Access is limited to the size of the database I am now forced to redo or convert to another application. On average our clients will need about 10gig annually.
I do not know what to do and our IT guy suggest that I think of a web based application done in Java. I do not have any knowledge and do not know how this will work, and I would like to know what you guys think and suggest. What will be the best way to go?
I have created an access database for the Railway industry to do the following.
1. Register assets. (on Track, Off Track and Structures)
2. Capture and manage Safety inspections. (On 23 Asset types)
3. Capture and manage Condition Inspections (On 14 asset types)
4. Capture and manage Emergency call outs.
5. Plan and manage job cards. (Plan work, Material, teams)
6. Reports (about 68 standard reports)
This is only the main purpose of the database. The Access database is currently 13008KB in size (empty).
Because Access is limited to the size of the database I am now forced to redo or convert to another application. On average our clients will need about 10gig annually.
I do not know what to do and our IT guy suggest that I think of a web based application done in Java. I do not have any knowledge and do not know how this will work, and I would like to know what you guys think and suggest. What will be the best way to go?