question

BernhardZweifel-2715 avatar image
0 Votes"
BernhardZweifel-2715 asked SeeyaXi-msft commented

Linked Tables

Hi,

I have a an MS Access Application developped with linked tables. Everything works fine. Now I exported the tables to an SQL server (MariaDB 10 on Synology). When I link my MS Access front end with the SQL tables 9 out of 10 work as expected. the 10th table only gives results on queries with SQL. But using the same query, or even trying to open the linked table in access throws an error (3163).

Any suggestions to solve this problem is most welcome.

Thanks boz

sql-server-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Now I exported the tables to an SQL server (MariaDB 10 on Synology).

Just a note: Microsoft SQL Server != MariaDB (MySQL); better post your question to a more related forum

0 Votes 0 ·
  • I was asked to post the detailed error message:
    Run time error '3163': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (My error message is in German, but that is what it says.

  • A link I received addressing blank query returns is not directly helpful, because the linked table would not open at all, triggering the same error message.

0 Votes 0 ·

The reason that the response you got is not helpful is because you are asking in the wrong place. In SQL Server, the text for error 3163 is:

The transaction log was damaged. All data files must be restored before RESTORE LOG can be attempted.
Das Transaktionsprotokoll war beschädigt. Alle Datendateien müssen wiederhergestellt werden, bevor RESTORE LOG erneut ausgeführt werden kann.

I hope that you find a forum for MariaDB. But that is not on this site.

0 Votes 0 ·

Hi @BernhardZweifel-2715,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @BernhardZweifel-2715,

See this docs: https://docs.microsoft.com/en-us/office/troubleshoot/access/query-returns-blank.
It may be helpful.
If it doesn't work, can you post a detailed error message? Because I don't have your environment and i should know your error message.

Best regards,
Seeya


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft commented

Hi @BernhardZweifel-2715,

Here is the forum about MariaDB: https://mariadb.com/kb/en/community/
Hope your problem can be solved and have a nice day!

Best regards,
Seeya

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It has been suggested that this forum is not the appropriate place for my question. My approach in the past has been to start lokking for solution where the error message appears. MariaDB does not know any error 3163. On the other hand Microsoft information relating to the error suggests to use the developpers forum to find an answer. So much for that.

Interface problems between application are rather tricky, no part feels responsible; it is either the other software, the hardware or the incompetent user.
I found a solution doing it the hardway. I rebuilt the table from scratch, imported the data again, and it works! Very unsatisfactory approach, because you do not know when and wy it will happen next time.

0 Votes 0 ·

Interface problems between application are rather tricky, no part feels responsible; it is either the other software, the hardware or the incompetent user.

Well, in this case you have two products: MS Access and MariaDB.

But you posted a question with a tag for Microsoft SQL Server which is a third product with no relation to the other.

That is why you are being told that you are in the wrong place.

0 Votes 0 ·

Hi @BernhardZweifel-2715,

If you think that the MariaDB forum cannot solve your problem, Microsoft also has many products, you need to see which part of your question is biased, and then go to the corresponding forum to ask questions.
You can post here: https://techcommunity.microsoft.com/t5/access/bd-p/Access

Best regards,
Seeya

0 Votes 0 ·