Compatibility

[Lina Manjarres]

I have an aplication made with Access 2000 on Win2000 working perfect.
When I run the aplication in Access 2002 on Win XP it had problems

How can I make it to be compatible on both platforms?

 

[Dirk Goldgar]

I have an aplication made with Access 2000 on Win2000 working perfect.
When I run the aplication in Access 2002 on Win XP it had problems

How can I make it to be compatible on both platforms?

Normally it should be, barring broken references and possible issues
with Jet sandbox mode (which may be set to disallow certain "unsafe
expressions" in queries). What sort of problems did you encounter?

 

[Lina Manjarres]

For example, when I use a filter on a query like this one:
[Formularios]![ChannelFrm1]![ChannelFrm2].[Formulario]![IdCompany2ndLevel]
It works fine on my access 2000 but it dosen't work on my partner's access
2002.
It may be a configuration problem?

 

[Dirk Goldgar]

For example, when I use a filter on a query like this one:
[Formularios]![ChannelFrm1]![ChannelFrm2].[Formulario]![IdCompany2ndLeve
l]
It works fine on my access 2000 but it dosen't work on my partner's
access 2002.
It may be a configuration problem?

I can't see any reason why that wouldn't work equally well in either
version of Access. Do you get an error message? If so, what is it?

For safety's sake, make sure that both installations of Access have the
Name AutoCorrect option turned off.

 

[Lina Manjarres]

Thank you!
Where do I finde the AutoCorrect option?

For example, when I use a filter on a query like this one:
[Formularios]![ChannelFrm1]![ChannelFrm2].[Formulario]![IdCompany2ndLeve
l]
It works fine on my access 2000 but it dosen't work on my partner's
access 2002.
It may be a configuration problem?

I can't see any reason why that wouldn't work equally well in either
version of Access. Do you get an error message? If so, what is it?

For safety's sake, make sure that both installations of Access have the
Name AutoCorrect option turned off./

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Thank you!
Where do I finde the AutoCorrect option?

Click Tools -> Options ..., and go to the General tab. You'll see a
set of three check boxes in a group that is labeled "Name AutoCorrect".
Uncheck either "Perform name AutoCorrect" (if you want Access to keep
collecting this information, but not to try to apply it) or "Track name
AutoCorrect" (if you don't want Access to bother with it at all). I do
the latter, because I know I'm never going to use the feature and want
to avoid the overhead.

I don't know if this is the cause of your current problem, you
understand; it's just a possibility.

 

[Lina Manjarres]

Thanks Dirk, but I found the problem.
My Access 2002 is in spanish, but I have to write those filters in engish. I
mean, instead of saying [formularios]!... i have to correct it and write
[Forms]![...
It seems that this problem is being corrected in SP3.
Thanks a lot!

 

[Dirk Goldgar]

Thanks Dirk, but I found the problem.
My Access 2002 is in spanish, but I have to write those filters in
engish. I mean, instead of saying [formularios]!... i have to correct
it and write [Forms]![...
It seems that this problem is being corrected in SP3.
Thanks a lot!

I guess your partner's PC is not also set for Spanish? Or is it a bug
that happens even if both PCs are using the same language?

I'm glad you found the answer. Thanks for posting it.

 

[Lina Manjarres]

It is a Bug. It happens on my partner's PC and all the PCs at his office that
have access 2002 spanish. My PC has Access 2002 spanish so it works perfect.
Thank you!

Thanks Dirk, but I found the problem.
My Access 2002 is in spanish, but I have to write those filters in
engish. I mean, instead of saying [formularios]!... i have to correct
it and write [Forms]![...
It seems that this problem is being corrected in SP3.
Thanks a lot!

I guess your partner's PC is not also set for Spanish? Or is it a bug
that happens even if both PCs are using the same language?

I'm glad you found the answer. Thanks for posting it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)