Insert Into statement WHAT?

[Guest]

I added a filed to a linked table and then ran my macro to uplard all info
from one db to another. Now the macro runs fine on my PC but when other
employess try it they get this message. The INSERT INTO statement contains
the following unknown field name..available online..make sure you have typed
the name correctly. I dont get what is going on. It works on my PC just fine.
Any help is appreciated.

 

[John Vinson]

I added a filed to a linked table and then ran my macro to uplard all info
from one db to another. Now the macro runs fine on my PC but when other
employess try it they get this message. The INSERT INTO statement contains
the following unknown field name..available online..make sure you have typed
the name correctly. I dont get what is going on. It works on my PC just fine.
Any help is appreciated.

Please post the SQL of your query. It sounds like it contains some
extraneous information - the text string "available online" in
particular - in some context which Access cannot interpret. Do you
have [Square brackets] around all your fieldnames, especially those
fieldnames which contain blanks?


John W. Vinson[MVP]