I have an access front end that references a SQL backend. I have the
ODBC connection connecting the front end to the back end set up on my pc and it works fine.
My problem occurs when I distribute the front end to another user with out the ODBC connection
set up on their PC. They recieve an error. I have to distribute to a number of users but I do
not want them to set up the ODBC connection since that task is error prone and the users and not
all savy with computers.
how can I use VBA to set up the connection? Please use examples in your code.
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
This very simple solution applies to a narrow cross-section of the "needs to close" variety.
In this case, the full message in Event Viewer was in applog, Event ID 1000:
Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
The canonical version of this article is on my web site here:
A companion presentation is available here:
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…