J
John Glaeser
i've created a tool w/ access that involves some very long
SQL statements...i was working at home in my notebook
where i have access 2002 with the access objects library
10.0. the thing worked just fine. when i brought it to
work and tried to use it on their machines, i got errors
saying that the "Setting for this property is too long".
the line of code that was highlighted
was "Graph2.RowSource = strSQL" (where strSQL is my
lengthy SQL statement). at work, we have office 2000
which supports the 9.0 library. what do i do?? is there
some way to get the 10.0 library?? the office i work in
does not have office 2002.
TIA,
John
p.s. if i should be asking this question somewhere else,
let me know
SQL statements...i was working at home in my notebook
where i have access 2002 with the access objects library
10.0. the thing worked just fine. when i brought it to
work and tried to use it on their machines, i got errors
saying that the "Setting for this property is too long".
the line of code that was highlighted
was "Graph2.RowSource = strSQL" (where strSQL is my
lengthy SQL statement). at work, we have office 2000
which supports the 9.0 library. what do i do?? is there
some way to get the 10.0 library?? the office i work in
does not have office 2002.
TIA,
John
p.s. if i should be asking this question somewhere else,
let me know