Jet Problem with Report

[matthewnsarah07]

Currently using a database created on a personal drive M: at work. I use to fill out a form which in turn generates a report sent out via SendObject.

Code as follows:

Private Sub Command46_Click()

If Me.Dirty Then Me.Dirty = False
Me.Status = "New - Awaiting Area Ref"
DoCmd.SendObject acReport, "rptWatchman", acFormatSNP, Me.StaffEmail, "[EMAIL="Donald.Coates@highways.gsi.gov.uk"]Donald.Coates@highways.gsi.gov.uk[/EMAIL]", Me.StaffEmail, "North West Watchman Form Attached", "A new Watchman Form is attached in Access Snapshot format.", Me.Attachments, No
MsgBox "Your Watchman Form was Submitted Successfully, you will receive a copy shortly by email", vbOKOnly, "Information"
'   MsgBox MailOutLook.Body
 
End Sub

I've moved this dbase to a shared drive G: - others users can log on to the drive and use the dbase until in comes to sending the report.
It simply throws up The Microsoft Jet Databse could not find object"

How can I solve this problem without having to rebuild the database from scratch???

Any help greatly appreciated

 

[ted.martin]

Have you split the front-end from the back-end? Also sending a report in 'snapshot' format may not be the most practical as snapshot is a Microsoft functional application and may not be available on your recipient's system. A PDF would be better.

 

[matthewnsarah07]

The dbase hasn't been split at the moment.

The other users should have the ability to send Snapshots, I don't have the software to send pdf files

I don't get this error only other users, not sure whats generating it??

 

[ted.martin]

PDF is a free Add-In with Office 2007.

 

[matthewnsarah07]

My apologies we are still languishing in Office 2003

All users can view the snapshot attachment they just don't seem to be able to send them

Also the error does name an object that can't be found only "

 

[matthewnsarah07]

Could it be something to do with moving the databse to a new drive even though there are no linked tables.

Interestingly I have tried the database today on my home computer and I don't get the problem

 

[Alisa]

Sounds like it could be a missing reference. Check to see if any of the references say MISSING on the person's computer who is having the problem.

 

[matthewnsarah07]

How do I check references I only have Access 2000 at home, on 2003 do you reach references by right clicking on the report?

 

[Alisa]

In the code window - open one of your modules, then you can get to the references through the tools menu.

 

[matthewnsarah07]

Thanks Alisa

Now you've mentioned that I remember having to activate Automation and Outlook object once before, that might be it

 

[matthewnsarah07]

I have tried removing references from my Access but it still works, can't access the other users machine for a day or so

 

[Alisa]

Yeah, you need to check out the references on their computer, not yours. Good luck.

 

[matthewnsarah07]

Quick update - tuned out to be one PC that had the Jet problem all sorted now

Many Thanks

 

[Alisa]

glad you got it working