Search results

Hi Gemma, Thanks for the post. My fault - there was another foreign key constraint which was the problem - I just made the assumption that the error related to my autonumber field. That'll teach me! Thanks all for the help. Regards, Gordon

Thanks for the replies. Unfortunately the append doesnt work - access complains about key violations. Not a good feature of the database but its a pita to have to rework it just to get this record in. Regards, Gordon

Hi all. I have inherited a database which contains a table of tasks and where the TaskID is an autonumber. Quite a bit of code has been written that refers to specific values but unfortunately one of those is not contained within the table (for background the reference is 10 and where the...

Thanks for the reply. Read-only within Access is exactly what I want to achieve in the database but if this is true for .txt files that doesnt explain why the .txt file is locked when a form associated with the file is open.

If I understand the database structure correctly, then a row in tblClass relates to only one row in tblAccounts i.e. one class is attached to only one account although an account may have many classes. I am also assuming that a row in tblClass can only have one row in tblAccountsClass. If so...

I have a fixed length .txt which I am linking into a MS Access 2002 d/b. My options are set to : default open mode -shared default record locking - no locks Open database using record level locking is unchecked the (datasheet) form is set to: allow edits/deletions/additions - no recordset type -...

The one to many relationship is perhaps best understood in a real world example. Take a purchasing system - you would have one table for the header row which typically holds details of the customer number, order date etc. Another table would hold the individual items being ordered. The link...

Hi Pat! Thanks for the reply. I should have said I was just viewing the data in datasheet mode from 'tables'. It just intrigued me that the datasheet view automatically refreshed existing rows with any changed data but simply ignored new rows being added. Perhaps I should explain what I am...

Good morning all! I have an ODBC link in an Access 2002 d/b to an AS400 table (with the ODBC refresh interval set to 10 seconds) and as the data changes, the data in form view changes just fine and dandy, thank you very much. However, when a new record gets added to the AS400 physical file...