Acess 2007 Crashes

[Murray]

We are running a 2003 Database which a user using Access 2007 also need to
open. We are using Autoupdater to keep the Front end up to date and to start
Access. on one particular Computer when he uses the desktop shortcut he gets
a message the Access has stopped working. I have deleted the Autoupdater and
recreated (V1.74) but it did not help.
After the initial crash if I try to open outlook directly it actually starts
the database that crashed, without a problem. If I close the DB and open
access a second time, access will open with loading the DB.
The user is also using Vista, any ideas what may be causing the crash? I
know the inforamtion is vague, so if you need any more I will happily post it.

Thanks

 

[Gina Whipp]

Murray,

A few questions...

1. Do you utilize Outlook from within the database?
2. Is everyone sharing the same front end?
3. The person who Access 2007 is it in a Trusted Location?

http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Murray]

Thanks for the reply, hopefully the following will answer your questions:

1. Yes we do send emails drom within the database - so yes we are using
Outlook
2. The front end is on a network share and we use Autoupdater to download
the Front end to each individual computer
3. I set up each Access 2007 computer to have the trusted location as the
local download folder (c:\Databases) and also the network share where the
backend resides

C:\Databases is the folder where Autoupdater saves a copy of the front end.

Many thanks

 

[Gina Whipp]

Murray,

Then I think you should check the references on the machines. Sounds like
it could be a reference to the *wrong* Outlook. Sounds like the Access 2003
database might be looking at Outlook 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Murray]

Gina
I am not sure I understand what you mean. The user has Office 2007, the
database was designed for Access 2003. The DB sends email but I would have
assumed that it uses the default email program, outlook 2007. Does something
have to be changed for an Access 2003 database, opened with Access 2007 to
send mail using outlook 2007?

Thanks

 

[Gina Whipp]

Murray,

I want you to check the References... go any Code Window - Tools -
References, look for any that say MISSING.

I am wondering if the 2003 database is looking for Outlook 2003 but can only
find Outlook 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tony Toews [MVP]]

We are running a 2003 Database which a user using Access 2007 also need to
open. We are using Autoupdater to keep the Front end up to date and to start
Access. on one particular Computer when he uses the desktop shortcut he gets
a message the Access has stopped working. I have deleted the Autoupdater and
recreated (V1.74) but it did not help.

Once the Auto FE Updater has downloaded the new copy of the FE and
other files and started Access running with your app then it's job is
done. So it isn't causing your problem.

I'd say Gina is looking at a possible answer with a references
problem with Outlook. I'd suggest using late binding and remove the
Outlook reference so users with either Outlook 2003 or 2007 can
execute without issues.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony

 

[Murray]

Sorry for the delay with the reply was busy with other jobs. I checked the
code window and there are 5 ticked:
VB for applications, Access 12 Object Libary, DAO 3.6, OLE Automation and VB
for Application Extensibility. There were no "Missing" in the list.

Any further help is greatly appreciated.

 

[Murray]

Tony, After re reading Ginas Post and yours I think I understand what you
meant. I disabled some of the references , DAO 3.6, OLE Automation and VB for
Applications Extensibility 5.3, and Access started to run again.

Thanks