PeteJohnston
Programmer
I've got an Access front end that links to a Sharepoint back end. In the table one of the fields is called
[Requestor / Contact] - Note the spaces
When I use query designer to select this field and run it from within query designer it shows Okay. When I save the query it changes it to
[Requestor/Contact] - NO SPACES!!!
Then when I run it it fails because it is looking for the field without the spaces which doesn't exist. If you look at the query in SQL view it has dropped the spaces.
Any ideas? I wasn't in control of the Sharepoint setup and don't have authority to change anything so I can't fix it by changing the name.
PeteJ
(Contract Code-monkey)
It's amazing how many ways there are to skin a cat
(apologies to the veggies)
[Requestor / Contact] - Note the spaces
When I use query designer to select this field and run it from within query designer it shows Okay. When I save the query it changes it to
[Requestor/Contact] - NO SPACES!!!
Then when I run it it fails because it is looking for the field without the spaces which doesn't exist. If you look at the query in SQL view it has dropped the spaces.
Any ideas? I wasn't in control of the Sharepoint setup and don't have authority to change anything so I can't fix it by changing the name.
PeteJ
(Contract Code-monkey)
It's amazing how many ways there are to skin a cat
(apologies to the veggies)