I am getting a type mismatch message under strange circumstances.
Here's whats going on:
1. I have split the database into a front end and a back end.
2. I have compiled the project.
3. I update the linked tables and then make an mde file.
4. When I use the mdb file, everything seems to work fine.
5. When I use the MDE file, I get a type mismatch error.
6. If I copy the entire database and take it home and follow the same
steps as outlined above, I don't get the error.
I don't understand what factor changes which causes the error. I know
which section of code is producing the typemismatch error, but I don't
know why it works fine as an MDB file but not as an MDE file.
Does anyone know what might be going on here?
Thanks,
Jody