Closed

Read/Write to DB on 2 servers

A local company has a new server, and wants to use the old server as a backup domain controller. This company has about 20 Access databases and several VB applications referencing those db's. All were written by employees that are no longer there. The manager wants all of the code to read and write to an identical duplicate of each database on the second server AT THE SAME TIME as writing to the first primary server. At first, I thought this wouldn't be that difficult. Just set new database references pointing to the second server also, and add a few lines here and there. However, the more I think about it, the more mind-boggling it gets. What about references to currentDB, dlookup functions, linked tables, etc.?? Using the exact same Access mdb or VB app on EITHER server, and having it write to both servers simultaneously is not going to be very easy, I am finding out. I have been thinking about replication, or just copying the Access tables from server 1 to server 2 periodically, but the manager has it in his head that his method of writing to both simultaneously is the way he wants it done. I have never done anything with replication. Does anyone have any thoughts or suggestions?? If you do and this is possible, I will be willing to hire someone to assist me.

## Deliverables

Right now, I am just looking for guidance. If it turns out to be just a matter of time-consuming code-writing, I will be willing to hire someone to assist me.

## Platform

Servers are Windows 2000. Most workstations running the apps are NT 4.0 or Windows 2000.

## Deadline information

Initially, I would like responses to determine if this is feasible at all. If so, I would like to have someone assist me within the next few weeks.

Skills: Database Administration, Engineering, Microsoft, MySQL, PHP, Software Architecture, Software Testing, SQL, Visual Basic, Windows Desktop

See more: writing code for apps, what are references, someone hire me to write, right to hire, looking to hire employees, hire thinking, hire someone to code, hire servers, hire me to write, copying someone's writing, windows servers, visual basic for apps, servers, read and, hire write, hire someone to write for you, Hire employees, php mdb read, read write server using, read lines

About the Employer:
( 0 reviews ) United States

Project ID: #2852139

8 freelancers are bidding on average $228 for this job

vw391686vw

See private message.

$8.5 USD in 14 days
(49 Reviews)
6.3
richardryerson

See private message.

$800 USD in 14 days
(3 Reviews)
2.5
ckingvw

See private message.

$340 USD in 14 days
(1 Review)
0.0
aurigatechn

See private message.

$84.15 USD in 14 days
(1 Review)
0.0
davidponda

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0
trodeck

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
gianpaolosa

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0
shaileshsan

See private message.

$425 USD in 14 days
(0 Reviews)
0.0