08 August 2003, Access2000,Message for Duplicate Values

[Sham Yemul]

Hello,

I developed one application which has tables having no. of records like
60-70 thousand. Each day about 400 records are added.
One of the fields is BarCode number, if a number is repeated I need to echo
message to user.
At present I wrote code that checks for barcode value entered by user thr' a
recordset with where cluase, if the recordset returns nothing it means there
is no duplicate record otherwise it echos message.
But this logic is bit slow. Any suggestions. User has to wait for each
entry.

I can not use no-duplicate constraint becuase user wants to enter duplicate
values if needed.


Other Details :
2 PCs with Network, tables linked to FrontEnd. Both Backend and Front end
are in Access2000.
PC Pentium II 750 Mhz
OS : Windows 98
Access2000.

Regards.
[Sham Shrinivas Yemul]

 

[Rebecca Riordan]

Make sure you're using a query object, not creating the SQL on the fly (it
isn't clear from your description), and that you have an index on the
BarCode field.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...