Mike Tope
mike.tope at dsl.pipex.com
Tue Jan 13 19:14:22 CST 2004
Thanks Brett, I thought as much. This is a database of archives, so it looks like it'll have to migrate to a later format rather than trying to persuade various coming and going users to get used to (not) pressing a particular button. No rush, though. Mike Tope ----- Original Message ----- From: "Brett Barabash" <BBarabash at tappeconstruction.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: 14 January 2004 00:12 Subject: RE: [AccessD] Access v2 on XP Find First > 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. > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >