reserved error (-7748) when attempting to link a table

Question

Software: Microsoft Access 2016
File extension .mdb
Data source : ODBC
ODBC Driver : Sybase ASE ODBC driver


When attempting to link a table from a data source with the configurations above mentioned, the reserved error (-7748) is thrown.

I was able to pinpoint the problem to tables with nonclustered indexes in the data source.

My workarround was creating a view of that table to link to Access. This workarround creates a redundancy in the Data Source and as such is not a valid solution for the problem.

Any thoughts on how to resolve this issue?

Answer 1

Hello Joel.Almeida,

Have you tried to add WorkArounds2=8192 for the affected data source? Could you try check if below blog could work for you?

Fixes For “Reserved Error -7748” in MS Access 2003, 2007, and 2010

Besides, could you check if there is any field in the data source which data type is incompatible between Access and Sybase?

Best Regards,

Terry

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Hi Terry,

Thanks for the feedback.
This is a part of a business intelligence application that is used by multiple people on a remote machine farm.
Editing the registry is not an option in my case.

Furthermore, where can i find the field types not compatible between ASE and Access?

Answer 3

Hello Joel.Almeida,

To be honestly, I'm not familiar with ASE and I did not know the difference between there support fields.

I think the Data Source should be a table, right? You could try to link the table's and specific field one by one. Once  one field caused this error but others not, this field's type is  the type we want.

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].