I have an application that connects to a SQLServer database. When I test everything works fine. Forms open, data is entered, reports are made. When I create a mde from this and I go put it on a users PC and set up the correct ODBC connection, etc. When the users open the application they get an error on the first button they push to access a "employee" table.
Now if I go to the database window and open the table then close it the button works fine. It's as if the connection to the tables are not "live" until we manually open them first.
Any suggestions on how I can make the tables "live" ALL the time not just when you open them manually first.