What type of connection are you using? Linked table or you connect on demand?
Osvaldo -----Original Message----- From: Patrick Kirk [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 7:32 AM To: Osvaldo Sommer Subject: Re: Using Access as client all fields are marked "#Deleted" Osvaldo Sommer wrote: > Hi > > 1.- Does all your tables have a primary key? > 2.- add a field type timestamp to all your tables and don't touch it. > > The problem is that access does not know if anyone has modify the record > > Osvaldo Sommer > Thanks but it seems to make no difference. Here's a small table example that requires me to do a hard refresh whenever I add a new record. CREATE TABLE `tblFolders` ( `F_ID` tinyint(255) unsigned NOT NULL auto_increment, `NAME` varchar(30) NOT NULL default '', `TITLE` varchar(30) NOT NULL default '', `BODY` mediumtext NOT NULL, `CLASS` tinyint(10) NOT NULL default '1', `TIMESTAMP` timestamp(14) NOT NULL, PRIMARY KEY (`F_ID`) ) TYPE=MyISAM COMMENT='THIS IS FOR PEOPLE WHO WANT TO BROWSE BY FOLDER' AUTO_INCREMENT=10 ; Does that timstamp need some kind of tweaking? --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 3/22/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 3/22/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
