Search results
-
N
Bug in Linked tables?
Hi, I have an Access 97 database containing two tables: a linked table, and a local Access table. The link points to an SQL Server 2000 table with 12000+ records. These two tables must stay more or less in sync, so I run a "Find Unmatched" query regularly against the local Access table, so I... -
N
Very serious bug in Access with Linked tables?
Hi, There seem to be a serious bug in Access 97, and I want to know if anyone has encountered this before. I tried to describe the problem as best as I can, I also included a flash video to describe everything, here it is: http://naderchehab.googlepages.com/linkedtablebug.swf (~1 MB) My... -
N
Weird IIF problem
Hi, I have a table with two fields: CustomerName and OrderNumber. Some order numbers have dashes, for example: 123-4, 123-5, 123-6 etc. I wrote a query to strip those dashes from these ordernumbers, but only for 3 specific customers: Mark, Mike and Jane. This is the query: SELECT...