AccessVandal,

In the macro yes those settings are required and the other options are not
an option. The subject line is kind of deciptive because those queries he
is referring to are actually, make table and update queries. Oddly, enough
the macro runs in one database FE/BE set-up but not the other. He sent me a
copy of the database and I was looking for some reference to a table or
query that existed in the one database but not the other and after reviewing
MANY queries, found one. So now I am as stumped as he is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"AccessVandal via AccessMonster.com" u18947@uwe wrote in message
news:a0e5bd16150f5@uwe...
Gina,

I notice the macros OpenQuery "View = Datasheet" and "Data Mode = Edit".
Are
these necessary? It's already in datasheet. Not all joint query is
Editable.

As far as I know, if you open the Append (Action Query) in DataSheet View,
the Append query will not modify the records, it will only show the data
of
the records of the Append query.

Try to remove these, see if it works.

Gina Whipp wrote:
Allan,

I looked at evey query attached to that macro, ummm and there were alot,
and
I see no reason why they would fail. I am now as stumped as you are.
There
snip...

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200912/1