Solved

Accessing MSAccess db with ODBC - column titles format

Posted on 2000-05-02
2
205 Views
Last Modified: 2013-12-18
Hi all,
I'm having problems accessing particular columns in a MSAccess db table, if the column titles contain gaps, commas etc. For example, to retrieve data from column called "Ready for T/O" I'm using the following formula:
@DbLookup("ODBC";"U2STAT";"";"";"sh1";"Ready for T/O";"p3";"684" )
and notes returns an error. The only way how to make it work I found, is to go to the Access db and rename the column into "Ready_for_TO". It is pretty annoying when the db contains some queries, forms etc... - you have to change them as well and the owner of the database is not always willing to do that..... Is there any trick how to enter the column title into the formula, so that notes would accept it?
Thanks a lot!
0
Comment
Question by:koze767301
2 Comments
 

Expert Comment

by:brooklynegg
ID: 2769466
I'm just starting to do this myself so I'm not sure of your answer, but I have some suggestions.  See if @DBColumn works. If so, have the administrator set up a query that places the information in a table, then query the table row and column number.  That way you won't have to keep asking for design changes.

If @DbColumn does not work, I can get you a copy of an LotusScript agent that I am adapting to import an archive into Notes.  It uses this technique, which you should be able to adapt for this purpose.  Let me know.
0
 
LVL 3

Accepted Solution

by:
Simon_Hendry earned 50 total points
ID: 2771239
You need to place quotes around the filed name , but as this is script you should use \"

so your line should read

@DbLookup("ODBC";"U2STAT";"";"";"sh1";"\"Ready for T/O\"";"p3";"684" )

0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus Notes 8.5 1 149
Lotus notes email code 2 123
Add a cc field to email code 3 111
Lotus Domino 9 web server 6 91
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question