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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: BrendaCowell
- Order by date
-
Using MSQuery to reference a db with a reserved word name
Skip, We are able to access the db that way. We won't be using this as a workaround in this case, however, as we are trying to limit points of failure in a process often broken due to workarounds used in the past. Wish I could go back in time to the person who named this database and suggest...- BrendaCowell
- Post #7
- Forum: Microsoft: Office
-
Using MSQuery to reference a db with a reserved word name
Thanks for the suggestion.- BrendaCowell
- Post #5
- Forum: Microsoft: Office
-
Using MSQuery to reference a db with a reserved word name
My position here has a limited duration. I'm initially setting up a few reports for them, but want "to teach them to fish" so they can modify these reports, and create new ones as the need arises.- BrendaCowell
- Post #3
- Forum: Microsoft: Office
-
Using MSQuery to reference a db with a reserved word name
We are trying to set up some queries using MSQuery to read a database named "OPEN". Because OPEN is a reserved word, I get the error: "Incorrect syntax near the keyword 'OPEN'. Statement(s) could not be prepared." If I modify the sql statement to add brackets to OPEN (i.e. [OPEN]), the query...- BrendaCowell
- Thread
- Replies: 6
- Forum: Microsoft: Office
