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!

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

Linked Tables

Status
Not open for further replies.

bob120579

Programmer
Feb 9, 2005
42
US
I have several linked tables from MySQL in Access. Only two of the tables, which are updated from access show all deleted data in the columns when I open the tables in access. But when I open them in MySQL the data is fine. Anyone have any insight to this?

Bob
 
I am not experienced with this but do your tables all have primary keys? Do any of the primary key fields allow nulls? Do you have timestamp type field?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top