471,852 Members | 1,059 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

Ongoing problem with Unknown Function Replace

Hello,

I have an ongoing problem with a single machine not recognizing the
REPLACE function.

This is a WinXP Pro machine, running Office 2000 (SP3) with MDAC 2.8
(SR1) and Jet 4 installed.

The references are all identical to every other machine running this
app.
If I open this DB on another machine (the exact same front end, via
network) it works fine.

I have made sure that modules refer explicitly to dao.database and
dao.recordset where appropriate - but this doesn't apply to the replace
function.....

Is there something else I can try to update/fix this one machine.

Thanks,

Mal.

Nov 13 '05 #1
3 2450
What is the SP level of Jet dll file? If I recall correctly, the Replace
issue was fixed in SP6 of msojet40.dll.

--

Ken Snell
<MS ACCESS MVP>
<ma******@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hello,

I have an ongoing problem with a single machine not recognizing the
REPLACE function.

This is a WinXP Pro machine, running Office 2000 (SP3) with MDAC 2.8
(SR1) and Jet 4 installed.

The references are all identical to every other machine running this
app.
If I open this DB on another machine (the exact same front end, via
network) it works fine.

I have made sure that modules refer explicitly to dao.database and
dao.recordset where appropriate - but this doesn't apply to the replace
function.....

Is there something else I can try to update/fix this one machine.

Thanks,

Mal.

Nov 13 '05 #2
Well,
I will check on that.
But until very recently the mdb was working just fine....
now any db on the machine will not run the function.

?????
Mal.

Nov 13 '05 #3
> issue was fixed in SP6 of msojet40.dll.

- and broken in some obscure way by SP8

We gave up and put the User Defined Functions
back in for InStrRev and Replace. We had a
development machine here in the office that
couldn't use Replace, and if we couldn't identify
the problem here in the office, it didn't look
good for deployment to clients.

Notice that InStrRev is not listed as either
'blocked' or 'safe in sandbox mode':

How to configure Jet 4.0 to prevent unsafe functions from running in Access
2003
http://support.microsoft.com/default...98&Product=acc
Clearly InStrRev cannot be used in Jet sandbox mode:
(?) But Access Sandbox Mode is supposed to control
Jet Sandbox mode.(?)

Perhaps there is an installation or registration
problem, or perhaps there is something about sandbox
mode.

(david)
"Ken Snell" <kt***********@ncoomcastt.renaetl> wrote in message
news:ku******************************@comcast.com. ..
What is the SP level of Jet dll file? If I recall correctly, the Replace
issue was fixed in SP6 of msojet40.dll.

--

Ken Snell
<MS ACCESS MVP>
<ma******@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Hello,

I have an ongoing problem with a single machine not recognizing the
REPLACE function.

This is a WinXP Pro machine, running Office 2000 (SP3) with MDAC 2.8
(SR1) and Jet 4 installed.

The references are all identical to every other machine running this
app.
If I open this DB on another machine (the exact same front end, via
network) it works fine.

I have made sure that modules refer explicitly to dao.database and
dao.recordset where appropriate - but this doesn't apply to the replace
function.....

Is there something else I can try to update/fix this one machine.

Thanks,

Mal.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Johan | last post: by
3 posts views Thread by daveland | last post: by
6 posts views Thread by David Hayes | last post: by
reply views Thread by Ewart MacLucas | last post: by
22 posts views Thread by José Teixeira Junior | last post: by
7 posts views Thread by julian.tklim | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.