Em Andamento

Access 2000 DB Maintenance

This is a maintenance project on an existing test database. I need a utility program that will clean up the database of duplicate values and test for relational integrity. I have provided a test database; however, this utility will be run against the production database after the program is verified.

The main table is the Drugs table. Every other table, with the exception of one, is related to it by the key GenericName. There is a total of 12 tables in this database.

The first task is to have each "child table's" Drug foriegn key tested to make sure that it exists in the parent table Drugs. If not, that record needs to be deleted.

The second task is to remove duplicate key values so if there is not a compound primary key defined in the table, this will be able to be accomplished.

The one table that is a little different is the Drug_Instructions table. It will be linked to from the Drug_StrengthVehicle table. Therefore, the same tasks are performed as before except using the Drug_StrengthVehicle table as the parent table.

I'll provide more information upon acceptance of the job.

## Deliverables

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) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

This will need to run on a Win32 platform against an Access 2000/XP database. I STRONGLY prefer the program be coded in VB6. However, I will consider accepting a program in either [url removed, login to view] or C#.

Habilidades: .NET, Programação C#, Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Ver mais: vb6 job, maintenance job, maintenance, compound, c maintenance, access 2000 database, duplicate table, run database maintenance, access linked table, access form record, software maintenance, table linked access, visual basic access project, clean access project, clean database access, access database clean, access existing database form, record vb6, little vb6 project, table vb6, production acceptance test, clean vb6, vb6 record database, clean table access, vb6 tables form

Acerca do Empregador:
( 6 comentários ) United States

ID do Projeto: #2995395

Premiar a:

gribfritz

See private message.

$34 USD em 5 dias
(490 Avaliações)
7.6

10 freelancers estão ofertando em média $27 para este trabalho

sreeyavw

See private message.

$34 USD in 5 dias
(31 Comentários)
5.1
barreiro04

See private message.

$17 USD in 5 dias
(22 Comentários)
3.7
techjunc

See private message.

$38.25 USD in 5 dias
(21 Comentários)
3.6
captainjoe

See private message.

$21.25 USD in 5 dias
(13 Comentários)
3.4
axivw

See private message.

$21.25 USD in 5 dias
(16 Comentários)
3.3
vnicky

See private message.

$25.5 USD in 5 dias
(15 Comentários)
2.8
stolevw

See private message.

$17 USD in 5 dias
(28 Comentários)
2.6
thewyzard

See private message.

$42.5 USD in 5 dias
(3 Comentários)
0.0
catatonicvw

See private message.

$21.25 USD in 5 dias
(1 Comentário)
0.0