How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Chatroom Needed Immediately
By blaster998 on Sep 30
Max Bid: $500


Fix link tracking program
By blaster998 on Sep 30
Max Bid: $75


Install TOMCAT on FreeBSD(repost)
By Kevbob on Sep 30
Max Bid: $100


Stormpay IPN Urgent Help Needed
By rohit123 on Sep 29
Max Bid: Open to fair suggestions


Spyware Application/ Spyware Scanner
By GuyB on Sep 29
Max Bid: $500


Web module in PHP/MySQL
By RXL on Sep 29
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(175 open)
   Access 
(53 open)
   MySQL 
(113 open)
   Oracle 
(11 open)
   SQL Server 
(72 open)
   Other DB 
(28 open)
Documentation / Tech Writing 
(26 open)
   Language (Human) Translations 
(10 open)
Data Entry 
(37 open)
Game Development 
(26 open)
Graphics / Art / Music 
(60 open)
   Graphics 
(64 open)
     Adobe AfterEffects 
(7 open)
     Adobe Photoshop 
(32 open)
     Adobe Premiere 
(6 open)
     3d Animation 
(21 open)
   Art (Misc.) 
(13 open)
   Music 
(7 open)
   Photography 
(5 open)
   3d Modeling 
(15 open)
Language Specific 
(121 open)
   Assembly / Machine language 
(15 open)
   ASP 
(65 open)
   ASP .NET 
(72 open)
   C# 
(75 open)
   C++ / C 
(162 open)
   Carbon (Mac OS) 
(5 open)
   Cocoa / Obj-C 
(5 open)
   Cold Fusion 
(11 open)
   Delphi 
(56 open)
   Java 
(102 open)
   JSP 
(21 open)
   Perl 
(47 open)
   Python 
(6 open)
   PHP 
(117 open)
   XML/XSL 
(33 open)
   Visual Basic 
(161 open)
   Visual Basic .Net 
(108 open)
   Other 
(78 open)
Misc 
(48 open)
   Middleware 
(3 open)
   CAD 
(3 open)
MultiMedia 
(28 open)
   Video Editing 
(5 open)
Network 
(34 open)
   Network Design 
(8 open)
   Network Implementation 
(7 open)
Platforms 
(80 open)
   Windows 
(195 open)
     MS Exchange 
(9 open)
     MS Office 
(28 open)
     Other 
(15 open)
   Darwin 
(1 open)
   Embedded Systems 
(16 open)
   Hand Held/PDA Programming 
(21 open)
   Internet Browser 
(47 open)
   Linux 
(63 open)
   Lotus Notes / Domino 
(3 open)
   UNIX 
(33 open)
Requirements 
(16 open)
Security 
(34 open)
Testing / Quality Assurance 
(22 open)
Web 
(171 open)
   Page Design 
(92 open)
   Flash 
(54 open)
   Marketing 
(15 open)
     Search Engine Optimization 
(12 open)
     Marketing (Other) 
(10 open)
   Web Services 
(91 open)
   Web (Other) 
(104 open)
Training 
(16 open)
   Computer Based 
(14 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

Database system
Bid Request Id: 37580
Bookmark in my 'To Do' list
Posted by: RockinRon (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 0.00%
Buyer Security Verifications: Good
Approved on: Nov 29, 2002
2:46:17 PM EDT
Bidding Closes: Dec 13, 2002
2:59:51 PM EDT
Viewed (by coders): 464 times
Deadline: 1/6/2003
TIME EXPIRED
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Small Business Project: $100 (USD) +
Bidding Type: Open Auction
Categories: Windows, Database, Language Specific, Visual Basic, Network, Other DB
Enter chat room for this bid request
(0 active users at Sep 30, 2003 6:46:22 AM EDT)

Description:
Database System, multi user, network ready.



Deliverables:
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: Icd02.dat 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.



Platform:
Win98, Win2000, Xp Home & XP Pro, Xp Office, WinME.




Must be 100% finished and received by buyer on:
Jan 6, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.

Special Conditions / Other:
if the project is completed and approved BEFORE 12/24/02 then a $20 bonus will be given.




Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
This bid was accepted by the buyer!
mdougan
(3 ratings)
in New York, New York
United States
Bid id: 409,125
 
$200 (USD) Nov 29, 2002
5:43:30 PM EDT
 10
(Excellent)
   
I could do this easily by the December 24th optimistic date. The platform would be Visual Basic 6.0, Access 97 (would also work with Access 2000).

Unfortunately, to distribute a database application you also need to distribute the Microsoft Data Access Components which is 7.5 mb of data! (unless you know that all of your users will already have the mdac installed - I believe that with XP this is the case).

A Visual Basic application requires more than just the EXE, it also requires several additional DLLs, an OCX or two, and the MDAC I described above.

A couple of points on your requirement. It's very hard to totally secure a database that is anything less than a full implementation of SQL Server or Oracle.

In Access the things that can be done are these:

Secure the database with a Password so that it can be opened only with the correct password.

Encrypt the contents so that even if the password were provided, the contents would not be readable.

Still, someone could conceivably delete the .mdb file or if they were able to break the password, they could change the contents or delete records even if they couldn't read the contents of the fields.

Message me back if you have more to discuss about this aspect of your requirement before you accept my bid.

I'd suggest that you only have one database, even for all years. Year can be an additional column in your database and you can limit the data selected by year for viewing. This allows the user to switch to different years and review the data without managing multiple database files. Speed should not be an issue. If it is, alternate designs are possible with archival tables.

Your comment about blanking out records and re-using them is not clear. Normally, in a database environment, you will either Update a record by typing over it, Insert a new record, or Delete an existing record.

As far as loading from a flat file, it sounds like that is an administrative function that only needs to occur occassionally? Once the data is loaded into the db, the normal user will be reading and updating the database, not the flat file, correct?



 
 
 
 
  There are 13 private replies to/from mdougan. Click here to view them.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Securenext
Rated a 9.96 on 127 jobs 
Buddies
Rated a 9.86 on 97 jobs 
Codman
Rated a 9.97 on 159 jobs 
hernest
Rated a 10 on 122 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
D-N-S
Rated a 9.93 on 40 jobs 
markesh
Rated a 10 on 24 jobs 
GribFritz
Rated a 9.89 on 158 jobs 
PSergei
Rated a 9.78 on 112 jobs 
ASP.NET
Rated a 9.86 on 62 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.