Novice
Windows XP 
Access 2010 32bit
Hi, I have created an Access database where all of the queries, forms, macros and VBA codes work; however, when we try to run this in the client's environment using Access 2010 Runtime, we are getting a run-time error 3146. We are assuming that it is related to the linking to their database, but cannot figure out the issue. When we test the linking in their environment using Excel, it works fine, but it won't work using Access 2010 Runtime. Does anyone have any suggestions? Thank you!
VIP
Windows 7 64bit Access 2010 32bit
What is the exact error message? A number of threads on 3146 error. Search forum and should see at least 9.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows XP Access 2010 32bit
I don't have access to the client's system at this time; therefore, I can't get an answer to this question yet. I will let you know when I do. Thank you for your time.
Sometimes Helpful
Windows 7 64bit Access 2010 32bit
What are you linking to and how? Can you provide an example? Be sure to hide sensitive data within connection strings.We are assuming that it is related to the linking to their database, but cannot figure out the issue.
Novice
Windows XP Access 2010 32bit
We are linking to tables in the client's payroll system through system DSN.
Sometimes Helpful
Windows 7 64bit Access 2010 32bit
It is difficult to say without additional info. Maybe this is helpful ...
https://www.accessforums.net/sql-ser...ere-52914.html
Error 3146 in Access 2007, not in Access 2010
2010 Runtime version
Posting Permissions
Reply With Quote