Error 3075 Function Not Available - but no missing references

[Jozef]

I have an MDE file that is blowing up with "Error 3075 Function Not
Available", which is normally a reference issue, but, I have no missing
references.

It seems that offending function is a Format() over a date field in a list
box. Has anyone run into anything similar before? I built the db on a
Windows XP pro machine using Access XP. The target / test machine is a
Windows 2000 machined with only Access 97 and the runtime version of XP
installed.

Any ideas?
Thanks!

[the chiller]

I can't think of anything else other than reference problem
http://allenbrowne.com/ser-38.html

[Steve Jorgensen]

On Mon, 19 Dec 2005 05:15:23 GMT, "Jozef" <[e-mail]> wrote:

I have an MDE file that is blowing up with "Error 3075 Function Not
Available", which is normally a reference issue, but, I have no missing
references.

It seems that offending function is a Format() over a date field in a list
box. Has anyone run into anything similar before? I built the db on a
Windows XP pro machine using Access XP. The target / test machine is a
Windows 2000 machined with only Access 97 and the runtime version of XP
installed.

Any ideas?
Thanks!

It could be a Microsoft security update. If you have Access 2002 (XP), and
you get the new JET security update installed via Windows update, but do not
also install the newest service pack for Access 2002, you can end up with
security defaults changed, and no menu item in Access to change them back.

There is also another security problem I've seen where the new JET security
update sets the sandboxmode option in the registry to 3 even though the
default is supposed to be 2. 2 means that only Access programs can call
functions from within queries executied by JET. 3 means -nothing- can call
functions (e.g. Format) from queries. I believe the option can be found under
HKEY_LOCAL_MACHINE/Software/Microsoft/JET/4.0/Engine.

[Terry Kreft]

I beleive this can also be caused because a referenced file is not properly
registered.

Look at regidtering your non-builtin references again.

--
Terry Kreft

"Jozef" <[e-mail]> wrote in message news:Llrpf.12172$wg4.843@edtnps84...

I have an MDE file that is blowing up with "Error 3075 Function Not
Available", which is normally a reference issue, but, I have no missing
references.

It seems that offending function is a Format() over a date field in a list
box. Has anyone run into anything similar before? I built the db on a
Windows XP pro machine using Access XP. The target / test machine is a
Windows 2000 machined with only Access 97 and the runtime version of XP
installed.

Any ideas?
Thanks!

[Lyle Fairfield]

Jozef wrote:

I built the db on a
Windows XP pro machine using Access XP. The target / test machine is a
Windows 2000 machined with only Access 97 and the runtime version of XP
installed. Any ideas?

My idea is that you are much braver than I am.

[Tim Marshall]

Jozef wrote:

It seems that offending function is a Format() over a date field in a list
box. Has anyone run into anything similar before? I built the db on a
Windows XP pro machine using Access XP. The target / test machine is a
Windows 2000 machined with only Access 97 and the runtime version of XP
installed.

Jozef, as others have mentioned, this is a reference problem.

I have had some very bad luck at the universty I work with standard
references in Access 97 installed on Windows XP Pro and 2000 operating
systems. I have many A97 installs with Office XP (minus A2003) working
fine, but many instances where it is not. Often times, it's the result
of later versions of Office being installed, even without installation
of Access 2000, 2002, 2003. Sometimes there is only office 97
installed. I don't know if this is a problem with Win XP or how the
computer support person does the installs (A97 and A2003 and Office 97
and Office xp run fine on my set up, but I installed it myself carefully
following the guidelines you can tgoogle from this group or search for
onm the MS website).

I've also had one user's machine rendered completely useless for A97 as
regards references after he installed a VB application which used Some
version of Jet as the database engine - presumeable this ws a runtime
verison of Access.

I've given up on supporting my A97 apps on such machines.

Glum information, but that's my experience, anyway.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me