ODBC database query
 

I am working with an Access database to keep track of everyone's jobs at
work. I have Excel files with macros that pull information from the
database and display it in a report form. My problem is that I seem to
be running out of space within the macros. I get to the database using
an ODBC link. Once I filter the data and complete the macro, the
filtered data displays perfectly, but if I save and close the file,
then open it again, the macro contains errors. When I open the macro
and look at the coding, it looks like it cuts off at a certain point as
if I had filled my character quota. Is there any way that I can expand
this limit or am I just going to have to deal with it?


--
gneissgirl
------------------------------------------------------------------------
gneissgirl's Profile: http://www.excelforum.com/member.php...o&userid=28714
View this thread: http://www.excelforum.com/showthread...hreadid=484027