Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queries got broken in split DB

Status
Not open for further replies.
LesK

LesK

IS-IT--Management
Feb 24, 2001
6
US
I have a working A97 DB with a form that uses a query to display data. Users can add a record in this form by clicking a button which then does docmd.GoToRecord , , acNewRec. This has worked fine for a long time. Recently I split the DB. It seems that since then records are still added but other queries do not see the new records.
I.e., there are several other queries which select data from the same table and related tables and pass it to reports for display.
Running these queries directly shows the new records are not included.
Any suggestions what's wrong and how to fix it?
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
765
TheresAlwaysAWay
TheresAlwaysAWay
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
227
mikrom
mikrom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
762
TheresAlwaysAWay
TheresAlwaysAWay
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top