ALLOWING DUPLICATE VALUES IN THE SAME COLUMN OF THE MS ACCESS TABLE

[gin1906]

PLEASE HELP,
I am developing an application software called the Summer Art auction project.i have used J2ee and using MS Access table as the Database.i mean to say i am linking J2EE and MS Access with JDBC Driver.
Now the problem is with this.. there is this common table of storing information abt payments done.. for eg payment by cash, payment by check or payment by creditcard..
there is this one particular column called the Bidder No. it is supposed to save the information of bidder no everytime a payment is made.but this table doesn't take duplicate values.infact i have tried changing the design values so that it accepts duplicates.. but it doesn't! so far it just accepts a particula bidder no entry once and then the other times it just enters "0".i have also removed the default value..
please help.. i am in urgent need of this to be fixed.. I have very less time..
Thanks..

 

[KenReay]

Hi

Open table in design view, carefully check the Indexes, looking for any on Bidder No which have allow duplicates set to no



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[BNPMike]

In don't think it can be that, Ken. At the moment the table is not preventing duplicates. It is turning them into duplicate 0s.

My advice would be to try and do the problem transactions in Access. You can probably use just datasheet views. If necessary build a form. Then you can see whether it is Jet that is causing the problem or your J2EE code. Access will give error messages we can more easily recognise.