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