Im developing the .accdb at my PC which has Office 2007 and Office 2010, Im using Office Access 2007 for this .accdb.
On my PC in this location C:\Program Files (x86)\Common Files\Microsoft Shared\VBA I have VBA6 and VBA7 folders
In Program Files (without x86) I dont have the VBA folder because both versions are 32bit.
On the server PC there is only VBA 7 folder at this location (the .dll is the same version as mine) C:\Program Files (x86)\Common Files\Microsoft Shared\VBA, however, there is also a VBA 7.1 at C:\Program Files\Common Files\microsoft shared\VBA. The server has Office 2010 and 2013, 2010 is being used.
Now could that 7.1 be causing the error? But I dont see a reason to do it so because Im compiling the .accde at my PC and not on the server.
As I remember in the past it worked fine without this error. The error shows up when I right click on a table and select Linking manager.
I tried an older .accdb version of mine which im 99% sure it worked without this error because whenever I put a new version I use the linking manager and check if all the tables are linked correctly but the older version shows the same error (description in attachment).
Edit: I forgot to mention that I made the .accde at my PC and then moved it to the server, I had a .accdb version with the table links from server. The .accde seems to work fine without errors for now at least..
Edit2: I made a typo wrote accde instead accdb, I colored it red
On my PC in this location C:\Program Files (x86)\Common Files\Microsoft Shared\VBA I have VBA6 and VBA7 folders
In Program Files (without x86) I dont have the VBA folder because both versions are 32bit.
On the server PC there is only VBA 7 folder at this location (the .dll is the same version as mine) C:\Program Files (x86)\Common Files\Microsoft Shared\VBA, however, there is also a VBA 7.1 at C:\Program Files\Common Files\microsoft shared\VBA. The server has Office 2010 and 2013, 2010 is being used.
Now could that 7.1 be causing the error? But I dont see a reason to do it so because Im compiling the .accde at my PC and not on the server.
As I remember in the past it worked fine without this error. The error shows up when I right click on a table and select Linking manager.
I tried an older .accdb version of mine which im 99% sure it worked without this error because whenever I put a new version I use the linking manager and check if all the tables are linked correctly but the older version shows the same error (description in attachment).
Edit: I forgot to mention that I made the .accde at my PC and then moved it to the server, I had a .accdb version with the table links from server. The .accde seems to work fine without errors for now at least..
Edit2: I made a typo wrote accde instead accdb, I colored it red
Attachments
Last edited: