Hey all! I'm new to the forum and looking forward to learning more about Access!
My company uses our own software to visualize data that is stored in Microsoft Access databases. We also have a SQL Server but unfortunately at the moment our software is not capable of linking to SQL. I have tried linking a table in an Access database to our SQL Server and then using our software to connect to the linked table but I am running into issues...
The software we use looks for a table named tData in whichever Microsoft Access database we are using. I have successfully uploaded tData to SQL and then linked that SQL table to an Access Database table. I put new records in the SQL table to verify that the Access linked tData table can update records and it does. The linked table is properly named tData and looks the same as the original local tData table. I renamed the local one so our software should now point to the linked table. When I go to connect in our software I get the error in the image attached here. Based on the error it seems like our software doesn't see the tData table initially - it then tries to make a tData copy but tData already exists. At least that is my interpretation.
My question: does a linked table have a different format or naming convention than a local table when a 3rd party software is seeing it? I figured our software would see "tData" and use that table but I guess not!
Thanks for you help in advance!