2003 Access Runtime doesn't work after installing SP2

C

coolnyan

We just installed SP2 and we found out that 2003 access runtime doesn't work
anymore. When users click on shortcut, nothing happen. All users only have
access runtime installed. We found out the work around to this problem by
installing FULL access version and opening the file from menu.

Is this problem caused by security in access 2003? Any help is appreciated.

Regards,
Khiat
 
A

Albert D.Kallal

Does un-installing and then re-installing the runtime work also?

I got quite a few people running the 2003 runtime..and they all are on sp2.
And, no problems reported.

My install scripts of course always do turn off the security warnings.
 
C

coolnyan

Hi Albert,

Thanks for your reply. I found out that the shortcut doesn't run because
it's pointing to FQDN, i.e., \\vanhome.ca\fs\apps\access\timesheet.mdb. When
I change the shortcut to point directly to server
(\\vanfs1\apps\access\timesheet.mdb), it works!

Have you had this kind of problem before? I am still finding out whether
SP2 security setting causing this problem.

Thanks,
Khiat
 
A

adsl

coolnyan said:
Hi Albert,

Thanks for your reply. I found out that the shortcut doesn't run because
it's pointing to FQDN, i.e., \\vanhome.ca\fs\apps\access\timesheet.mdb.
When
I change the shortcut to point directly to server
(\\vanfs1\apps\access\timesheet.mdb), it works!

Have you had this kind of problem before? I am still finding out whether
SP2 security setting causing this problem.

Thanks,
Khiat
Click to expand...
 
A

adsl

coolnyan said:
Hi Albert,

Thanks for your reply. I found out that the shortcut doesn't run because
it's pointing to FQDN, i.e., \\vanhome.ca\fs\apps\access\timesheet.mdb.
When
I change the shortcut to point directly to server
(\\vanfs1\apps\access\timesheet.mdb), it works!

Have you had this kind of problem before? I am still finding out whether
SP2 security setting causing this problem.

Thanks,
Khiat
Click to expand...
 
D

david epsom dot com dot au

"Intranet site is identified as an Internet site when you use an FQDN or an
IP address"

http://support.microsoft.com/?kbid=303650

" For example, you may receive the following error message when you try to
open a Microsoft Access database (.mdb) file on a local intranet share (by
using the FQDN or IP address) with Microsoft Access 2002: "


The runtime shuts down with unhandled errors, but I would have expected some
kind of message.

(david)
 
C

coolnyan

I added *.domain.com name to LOCAL INTRANET SITES and it fix the problem!
Thanks for your help.

Khiat
 
Top