Brett Barabash
BBarabash at TappeConstruction.com
Tue Jan 13 18:12:59 CST 2004
We are running A2 applications here on Win2k machines, and have the same problem. I just told the users to use the Find Next button (which is hilighted by default anyways). AFAIK, there is nothing you can change that will fix this. Nothing is wrong with your db or app per se, just a quirk of the 16-bit VM that runs MSACCESS.EXE (or MSARN200.EXE), I guess. -----Original Message----- From: Mike Tope [mailto:mike.tope at dsl.pipex.com] Sent: Tuesday, January 13, 2004 5:52 PM To: accessd Subject: [AccessD] Access v2 on XP Find First Dear All I believe there are people on this list who persevere with Access 2 - I've hit a little snagette and wonder if anyone else has ? In Windows XP with Office XP installed, the user is running Access 2 from a file server. The find box (the binoculars button) is failing when you use Find First. This is on a primary key field. Occasionally it gives a syntax error (no details); more usually it reports "Search succeeded" but continues to display the record you started on. Using Find Next is a much more effective option that usually achieves the required effect (maybe always, if the record truly exists). I've tried this same database from the same shortcut in NT and 2000 with Office 2000 installed, and both have no problem with Find First. And it has worked on Win 95/Office 97 machines for many years. I've repaired and compacted. I've fiddled with fields and primary keys to remove the index and rebuild it. It remains the case that the XP machines can't operate Access 2's Find First in any reliable fashion. Any ideas ? Would service packs be relevant ? TIA Mike Tope PS late night (GMT) user only due to child on Nexus ... _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.