Database System, multi user, network ready.
need speed, especially on a network.(server, peer to peer, etc.) Store These fields: Important Note: do NOT use a grid for data entry, use text boxes 1. Name( in One Field) 2. Date(in one field)(month & day only)Example: 10-02 is 10th month, second day. always 5 charactors. 3. Age (as integer)( Use combo box to enter age from 1 to 100) 4. Notes as string of charactors up to 3000 (using textbox) 5. User name(one field) VERY IMPORTANT! i want to "Lock Out" the data from viewing or ANY use by ANY other database viewer(access, excel, etc.) give details on this feature if needed. this is very important. Show how how to create, empty a record and re-use it later when a new record is required. i also need to assign a number(numbers & letters combined) to each created record that would NEVER be deleted so they can be tracked by this record number. i need to track the total amount of records at all times. opening screen is for data entry\edit. (command buttons will take you to any other required features) i would want to scroll thru current records on the opening screen by using a vertical scroll bar and view\edit any or all fields at any time. display all data from all records in flexgrid W\command button Important Note: sort by date\day when loading flexgrid. example: the dates 10-12 would be listed after 10-11 and so on document ALL details of code purpose including what kind of forms to use Note: I would like to use standard Exe's if possible. also, tool(s) needed to load my existing "flat" file data into the new database. "Flat" file> i use the "Open", "Get", & "Put" statements Note: Flat files are too slow when i go above 5000 reports. 2500 records take about 5-6 seconds to load all into a flexgrid on a 1.6 ghz pent4, this is way too slow. even slower on a network system.(60-90 seconds) Note: I am very experienced with "Flat" files but have NO experience in the new database systems. I do not know if the the new systems have record numbers or if i have to add them so i need info pertaining to record id methods. anything that can increase speed when searching records or loading a flexgrid would be a plus. show how to add fields at a later time. needs to be able to handle up to 32,000 records and access\read them very fast when loading into a flexgrid. I need to know how to name the file for the database so i can attach the file year to the file name. Example: [url removed, login to view] is for the current year. Each year will start a new database, the previous year will have to be available for view\edit as required. each previous year database will be accessable with a combo box to select the previous year(s). i know how to do year selection with "Flat" files but i may need info to do it with this new system. show how to search any field in all records for a certain word, phrase or number and do it fast built-in edit Prevention system: each record will have a user name, i want to be able to prevent any user from editing the record UNLESS the current username matches the current record username. Note: i will have a variable: TerminalUserName that will contain the current user name, if it matches the current record "user name" then editing will be allowed of the current record. very basic printing of a single record 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Win98, Win2000, Xp Home & XP Pro, Xp Office, WinME.
## Deadline information
if the project is completed and approved BEFORE 12/24/02 then a $20 bonus will be given.