Завершено

MDB Update in the client with ADO

I need a routine to update a MDB with the new MDB structure in ADO. I have a MDB in the client. When they update the [url removed, login to view] the program detect the new version off the aplication and make the changes in the current mdb from one blank mdb structure or from one array or code of the new estructure. I need the actual mdb update and all the current data equal. Evidently If I don't delete fields, etc. If one field change of type or lenght the new estructure preserve the information like it's posible. My application is in VB6 & MDB Access 2000. I work with Microsoft Activex Data Object 2.5 Library One Coder try it to make it like this with ADOX but the problem are the relationship's. I thing is better this system : 1º Whe send a empty mdb with the new strucuture (all tables, indexes, relations and one special table called version with only one field with the number of exe version) 2º The routine verify the version off the table version in [url removed, login to view], if is not equal than the exe the update begin. 3º The routine copy the [url removed, login to view] to [url removed, login to view] 3º The routine apend all the data from [url removed, login to view] to [url removed, login to view] 3º Rename the [url removed, login to view] with [url removed, login to view] 4º Rename the [url removed, login to view] to [url removed, login to view] Ok it's simple but I make this consideration's : 1º I think the routine can automatic append the table's from customer that they are in [url removed, login to view] 2º The routine need to control the relationship to make the append's or inserts ? 3º What need the routine to insert records preservating the autonumeric fields ? 4º Is need anything control to ensure the correct update? foreign keys, etc 5º What happend with the international fields like money? I think this is all I need, any suggestions?

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.

## Platform

W95/98/ME/2000/XP

Квалификация: Техника, Microsoft Access, MySQL, PHP, Архитектура ПО, Тестирование ПО, Visual Basic

Показать больше what is data structure in c, what is a data structure in c, what are the application of data structure, type of data structure in c, tables in data structure, in vb6.0, distribution international, data strucuture, data structure problem, data structure in array, data structure in, data structure array, c data structure library, array in data structure, array data structure, application of data structure in c, application of array in data structure, and in vb6, what is client, client deliverables

О работодателе:
( 1 отзыв ) Barcelona, Spain

ID проекта: #2895025

Поручен:

joaovw

See private message.

$127.5 USD за 14 дней(-я)
(15 отзывов(-а))
3.6

11 фрилансеров(-а) в среднем готовы выполнить эту работу за $105

hassan2000vw

See private message.

$127.5 USD за 14 дней(-я)
(12 отзывов(-а))
4.4
alokgarg

See private message.

$85 USD за 14 дней(-я)
(69 отзывов(-а))
4.2
georgegraff

See private message.

$85 USD за 14 дней(-я)
(20 отзывов(-а))
4.0
nabeelaJ

See private message.

$94.35 USD за 14 дней(-я)
(16 отзывов(-а))
3.9
digertisoftec

See private message.

$85 USD за 14 дней(-я)
(22 отзывов(-а))
3.6
vw203484vw

See private message.

$85.85 USD за 14 дней(-я)
(17 отзывов(-а))
3.3
vw669616vw

See private message.

$127.5 USD за 14 дней(-я)
(3 отзывов(-а))
3.0
kazikhalidvw

See private message.

$127.5 USD за 14 дней(-я)
(0 отзывов(-а))
0.0
knightxi

See private message.

$126.65 USD за 14 дней(-я)
(0 отзывов(-а))
0.0
jaxchristian

See private message.

$85 USD за 14 дней(-я)
(0 отзывов(-а))
0.0