By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Mystery can't add new Records

P: n/a
When doing certain Data entries in a Database, the statement "you
can't go to the specified record "comes up in a message box. Yet in
other Data entries using the same procedure, this statement does not
occurr. Why is that and what can be done to solve the problem?
We have approximately 19,000 records. The relationships are set as
illusrated below. On my Custom focus form, the record source is a
query
One is made up of Business address information.
The other is made up of contact information with the appropriate
attributes.
The query is joined like: Population,*\/ tblcustomer,*\/ on a one to
one join (Inner join)

The data entries work fine for approximately 2000 records at a time.
However, once this figure is reached we have problems when it comes to
being able to add new records. Your help would be greatly
appreciated. Thank you.

Database: Population Box\POPULATION BOX1.3.mdb Page: 1
Properties
AccessVersion: 09.50 AllowBuiltInToolbars: True
AllowFullMenus: True AllowShortcutMenus: True
AllowSpecialKeys: True AllowToolbarChanges: True
ANSI Query Mode: 0 AppTitle: POPULATION BOX
Auto Compact: 0 CollatingOrder: General
ProjVer: 24 QueryTimeout: 60
RecordsAffected: 0 Row Limit: 10000
Show Values in Indexed: 1 Show Values in Non- 1
Show Values in Remote: 0 Show Values in Server: 0
Show Values in Snapshot: 1 Show Values Limit: 1000
StartUpForm: frmLogon StartUpShowDBWindow: False
StartUpShowStatusBar: True Transactions: True
Updatable: True Use Default Connection File: 0
Use Default Page Folder: 0 UseAppIconForFrmRpt: False
Version: 4.0
User Permissions
admin
Group Permissions
Admins
Users
:\Population Box\POPULATION BOX1.3.mdb Sunday, 8 August 2004
Relationships: All Page: 2
Relationships
Contact TypesPopulation
Contact Types Population
ContactTypeID ContactTypeID
Attributes: Not Enforced
RelationshipType: One-To-Many
MSysAccessStorageMSysAccessStorage
MSysAccessStorage MSysAccessStorage
Id 1 ParentId
Attributes: Enforced, Cascade Deletes
RelationshipType: One-To-Many
OrdersOrder Details
Orders Order Details
OrderID 1 OrderID
Attributes: Enforced, Cascade Updates
RelationshipType: One-To-Many
PopulationCalls
Population Calls
ContactID 1 ContactID
Attributes: Enforced
RelationshipType: One-To-Many
PopulationOrders
Population Orders
ContactID 1 ContactID
Attributes: Enforced
RelationshipType: One-To-Many

Relationships: All Page: 2
PopulationqlyTitle
Population qlyTitle
Title Title
Attributes: Not Enforced
RelationshipType: Indeterminate
PopulationtblCustomer
Population tblCustomer
ContactID 1 1 CustomerID
Attributes: Unique, Enforced
RelationshipType: One-To-One
tblTitlePopulation
tblTitle Population
tblTitleID Title
Attributes: Not Enforced
RelationshipType: One-To-Many
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.