Access 2003 reserved error -7748

[TTL]

Hi
I'm having problems linking to an odbc connection which works fine when
using access 97 databases. I get as far as selecting the table for the ODBC
but when I try to finish an error message come up 'Reserved error (-7748)'
Can anyone help me please?

 

[Gijs Beukenoot]

TTL gebruikte zijn klavier om te schrijven :

Hi
I'm having problems linking to an odbc connection which works fine when
using access 97 databases. I get as far as selecting the table for the ODBC
but when I try to finish an error message come up 'Reserved error (-7748)'
Can anyone help me please?

From another group :

This solution given to me by Sybase worked for me:

Apparently this error is an Access issue. However, to workaround this
you will need to go into the registry and add a new string value to
the ODBC DSN.

Bring up regedit.
HKEY_LOCAL_MACHINE
+ Software
+ ODBC
+ODBC.ini

Select the Data Source that you are using.
Right mouse click and select New, String Value (the name is case
sensitive) Call it WorkArounds2

Then select the WorkArounds2 and select Modify, give this a Value of
40960.

That will create the String Value of WorkArounds2=40960

Then attempt the link to the table.

 

[TTL]

Thanks - This has solved the problem!!

TTL gebruikte zijn klavier om te schrijven :

Hi
I'm having problems linking to an odbc connection which works fine when
using access 97 databases. I get as far as selecting the table for the ODBC
but when I try to finish an error message come up 'Reserved error (-7748)'
Can anyone help me please?

From another group :

This solution given to me by Sybase worked for me:

Apparently this error is an Access issue. However, to workaround this
you will need to go into the registry and add a new string value to
the ODBC DSN.

Bring up regedit.
HKEY_LOCAL_MACHINE
+ Software
+ ODBC
+ODBC.ini

Select the Data Source that you are using.
Right mouse click and select New, String Value (the name is case
sensitive) Call it WorkArounds2

Then select the WorkArounds2 and select Modify, give this a Value of
40960.

That will create the String Value of WorkArounds2=40960

Then attempt the link to the table.