A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Quick question



 
 
Thread Tools Display Modes
  #31  
Old April 24th, 2006, 09:18 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old April 25th, 2006, 03:08 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.