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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving a query in Access 2002 kicks me out of the DB

Status
Not open for further replies.
alexisb

alexisb

Programmer
Apr 5, 2001
100
US
I converted about 8 Access 97 dbs to Access 2000. Some had VB code and some did not. I haven't experienced any problems. I converted 2 of the Access 97 dbs to Access 2002. In each of the two 2002 db's,I found one query (so far) in each db that, when I make a change and save, I get kicked out of the db and the changes were not saved. In one of the db's, I removed the "Totals" column from the query and the problem went away. In the last db I converted, there is no totals column in the query that is kicking me out when I save. Has anyone ever heard of this before?
Thanks!
Alexis
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
482
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
974
strongm
strongm
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
606
rashmibala
R
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
417
OzFoxy
OzFoxy
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino

Part and Inventory Search

Sponsor

Back
Top