Database doesn't work.

[victoria61485]

Hello,

I have inherited an old database that I converted to an Access 2003 database. In the database you enter batches and then you enter refund checks within the batch. If you enter the first batch you can then enter your checks and it works. But if you then enter a second batch you will get an error message that says that you are creating duplicate data in an indexed field. I think that the current date is stored somewhere and has to be changed manually when you print the checks. I would like to know if anybody can help me? I have limited knowledge of the programming side to Access. I think that the file is too big to attach. If there is anyway to email it please let me know. If this is too much please forget it. But if there is a simple answer please let me know. Thank you very much in advance.

 

[Guus2005]

You could first make a backup and then remove all but two records in each table then compact it. This should reduce the size of your database. Zip it and attach it to the next post.

I believe your problem is to specific to provide you with a meaningfull answer at this stage.

HTH

 

[gemma-the-husky]

guus is right, but it sounds like in the second check you are creating, you are entering some duplicate information (eg maybe the check no you are using has already been used)

 

[WIS]

Hello,
duplicate data in an indexed field.

Look @ the tbl in which the data is being inputted. It must have a fld with Indexed Yes No Duplicates - ie a Primary Key (PK). The data you are trying to input is attempting to enter records into the PK with those records having the same value as existing records in the PK.

file is too big to attach.

Make a backup and then run Compact and Repair. Winzip the file and see if is within the size limits for that type of file.