David,
Thanks for your considerable attention. However this doen't work either. I've mailed Seagate, but they haven't been able to show me a programming example that is able to refresh a report using ab Access2.0 table/Vb5, and this should be a simple coding example. Their programmer said he...
Do you mean CR runtime? If so:
File:
New
Create Report
Create Report Expert
SQL/ODBC
Log On To Server
Type: "ODBC - MS Access Database"
- Prompts for name-
when picked, provides info:
Server Type: ODBC - MS Access Database
Server Name: MS Access Database...
Hi Dave,
I've updated the MSAcess 16 bit dll , have also tried all of the CR DAO dlls on my system (PDBDAO.DLL, PDCTDAO.DLL and PDIRDAO.DLL) , As a log on statement I've tried w/ variations:
dbNm is a string w/ path to mdb file; have also tried statement w/o the .mdb ext
the code stops at the...
Hi David,
Well.... I'm beginning to get it. I see your point. I've been scouring the Seagate website for an eg. of a valid MSAccess 2.0 logonServer statement. There is some stuff re: dll's & DAO vs ODBC , but no egs. Also, would a connect statement come after logonServer? Much obliged...
dcm,
No, I haven't logged on to the datasource in code before attempting to refresh. The report will load w/ old data as long as 'Save data w/ report' is checked. Are you saying that I have to log on for each refresh? The table recordset is an MSAccess query that is re-run, but each time...
I'm new to CR
When using an query recordset as the report table (VB5, CR4.6) I can't get the report to refresh. I also unchecked 'Save data with report' , but then I load the report from an ocx I get an error: Unable to connect: incorrect log on parameters. #20536. Since the recordsource is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.