I have a program that uses ADOX automation to create tables in an Access
database (custom-built program in VB6 by me). Every week, it creates a new
table for the user running the program.

Prior to installing SP1, it would work perfectly fine on Terminal Server.
The table would be created and no problems.

After installing SP1, it now doesn't work. I get the error #-2147024769 -
Automation error. The specified procedure could not be found.

After talking with some fellow programmers on some coding forums, we've
decided it's not my program, but somehow SP1 locked the ADOX dll down so it
doesn't work like it did before. Is there any way that I can get around this
that anyone knows of? We don't want to get rid of SP1, but I want this
program to work like it did beforehand.

Any help would be appreciated.

I finally came across a way to fix it. I needed to repair the MDAC on the
Terminal Server.

If anyone else runs into this problem, here is the site that I found that
has a tool to do that: http://www.macropool.com/en/download/repair_mdac.html

"df_fga" wrote:

> I have a program that uses ADOX automation to create tables in an Access
> database (custom-built program in VB6 by me). Every week, it creates a new
> table for the user running the program.
>
> Prior to installing SP1, it would work perfectly fine on Terminal Server.
> The table would be created and no problems.
>
> After installing SP1, it now doesn't work. I get the error #-2147024769 -
> Automation error. The specified procedure could not be found.
>
> After talking with some fellow programmers on some coding forums, we've
> decided it's not my program, but somehow SP1 locked the ADOX dll down so it
> doesn't work like it did before. Is there any way that I can get around this
> that anyone knows of? We don't want to get rid of SP1, but I want this
> program to work like it did beforehand.
>
> Any help would be appreciated.