Report Objects

R

Richard

I have a database that uses "Send Object" to email multiple recipients. It is
a shared database. Occasional users are reporting email failures. When it
occurs I have found Access reports the object does not exist. But the Object
is there and can be used from a different machine. I have searched through
the knowledge bases without finding this particular problem. I suspect a bad
or corrupt DLL.
 
D

Douglas J. Steele

How can you be sure that "the Object is there"? Just because it's on your
machine doesn't mean it's on each user's machine. (And even if it's on the
server, that doesn't matter: it has to be on each client)

Has your application been split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships)? If you're sharing it, it definitely should be.
Only the back-end should be on the server: each user should have his/her own
copy of the front-end on his/her hard drive.
 
R

Richard

Douglas,
Thanks. No the database is not split up. The file sits on a public drive.
I did a work around where a user can check a box when there's an email
problem. There is a companion database that functions as a log. When it sees
the check box it does the email. The laptop the log runs on acquired the same
proble Monday and inspired my search for a solution. I was able to fix the
problem by using the "Repair Office" selection from the help drop down. But I
have a hard time believing
I will look in to splitting the database.
 
Top