If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Quick question
It turns out that the database is storing the information for the new records
into the main table. But for some reason, it's not updating the other two tables that are linked to it. The keys for the main table are set to random so the record is placed into a random section of the table. So my questoin becomes, is there either a way to ensure that all 3 tables are updated, when the secondary tables' keys are numbers and the main table's key is a random 'Autonumber'?? "Klatuu" wrote: Here are a couple of experiments you can try to isolate where the problem lies. First instead of the form, open the query. Try to enter data directly into the query. If that is successful, there is something wrong at the form level. If you can't enter records in the query, go directly into the main table and see if you can add a record. If you can, it means the query is an unupdatable recordset. If you can't, then the problem is really serious. Which brings me to another question. Is this database split? Is the back end database or if it is not split (it should be), is the database on a server. If so/ do you have write permissions to the server? And, is there Security on the database and do you have permission to write data? "One confused underwriter" wrote: Even with the Me.Dirty = False, I am unable to add records to my database. This is why you don't give someone who doesn't have much experience a database with issues such as these =) Thank you, everyone, for your help and suggestions. The struggle continues for another day... |
#32
|
|||
|
|||
Quick question
Well I finally got the database up and running. Thank you to EVERYONE who
gave me suggestions and answered my endless questions. I couldn't have done it without your help!! Thank you!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick Excel formula question before I go on holiday tomorrow! | Pheasant Plucker® | General Discussion | 2 | October 5th, 2005 06:34 PM |
Have a quick question about borders and images help please | joedrifter1 | New Users | 2 | September 9th, 2005 09:41 PM |
Quick Little Formula Question | Naoki | General Discussion | 7 | August 16th, 2004 07:39 PM |
Quick question | General Discussions | 1 | August 5th, 2004 05:14 PM | |
quick question about PivotTables | Dominique Feteau | Worksheet Functions | 1 | June 14th, 2004 09:55 PM |