TopSpeed Db and Lotus Notes ODBC
TopSpeed Db and Lotus Notes ODBC
(OP)
We have a program commercially written using topspeed. Using MS Access to write SQL and using the ODBC drivers was OK for simple 'select * from tablename' type queries which are really no good to anyone. Anything more complex from Lotus Notes seems to have kittens.
I have found that for Crystal reports the default SQL syntax is incorrect. Is there a similar problem with Lotus Notes and how do I fix it.
Thanks in advance for your fixes
Gordon
I have found that for Crystal reports the default SQL syntax is incorrect. Is there a similar problem with Lotus Notes and how do I fix it.
Thanks in advance for your fixes
Gordon
RE: TopSpeed Db and Lotus Notes ODBC
I have a working MS Access\VBA program that I want to use the data from a clarion file. My normal method is to output a delimited file that I import into the necessary tables in MS Access. I have not found a way to do this that creates a clean file without any extra bad characters.
My next thought is that I would like to use an ODBC type of connection. The only problem is that the files are not a .TPS extension. It is a .DAT.
Can anyone help?
Thanks in advance.
Spencer