Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data updated did not synchronize with other user

Status
Not open for further replies.
alvintse

alvintse

Programmer
Aug 1, 2003
66
US
Actually, I posted this under the forum "Access other topic" but no one reply this. I guess I must posted in the wrong forum.
I have just upsize my Access database (Access 2003) to SQL server 2000. I keep the Access as front end so I do need to change anything.Everything looks fine after the migration.
However, I found out that whatever data updated or input from one machine will not updated to other machine, not even after you move back from next record. Unless you closed the form and reload it again. (it doesn't happen before I upsize the database to sql server. Any change from one machine will display on the other machine after 1 or 2 sec when both are viewing the same record).
Any idea how to fix this?

Thanks.
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
878
strongm
strongm
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
778
dhookom
dhookom
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
877
serino
serino
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
482
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top