Solved

Accessing MSAccess db with ODBC - column titles format

Posted on 2000-05-02
2
202 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now