Compatibility

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Lina Manjarres said:
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?
Click to expand...

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?
 
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?
 
Lina Manjarres said:
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?
Click to expand...

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.
 
Thank you!
Where do I finde the AutoCorrect option?

Dirk Goldgar said:
Lina Manjarres said:
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?
Click to expand...

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)
Click to expand...
 
Lina Manjarres said:
Thank you!
Where do I finde the AutoCorrect option?
Click to expand...

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.
 
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!
 
Lina Manjarres said:
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!
Click to expand...

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.
 
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!

Dirk Goldgar said:
Lina Manjarres said:
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!
Click to expand...

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)
Click to expand...
 
Back
Top