troubleshooting Question

Access FE connecting to SQL Server BE

Avatar of APD Toronto
APD TorontoFlag for Canada asked on
Microsoft AccessMicrosoft SQL Server 2008
8 Comments1 Solution379 ViewsLast Modified:
Hello Experts,

I just had to connect an Access FE to a SQL Server BE (linked), but in doing so, I had to setup a user-defined ODBC.

My question is, do i need to define an ODBC on every machine that i want my FE to be used on, or is there a way to "ship" this, or perhaps define it as a connection string in VBA?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros