Use a MDB created in different language

Hello,
Is it possible to translate the form (, reports, queries,… ) definition of
an Access database? I’ve got a MDB build with Access 2003 in Spanish. When I
try to open a form of this database with Access 2003 in English I get an
error in queries with references to values in fields located in the form.

Enter Parameter Value:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12232-use-a-mdb-created-different-language.html
Formularios!!

I've tried to import the form to a new English MDB but with the same result.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12232

This seems easy to change in MSysQueries but this is read-only.

The database is complex with a lot of forms and many references in forms and
reports. It’s difficult to manually maintain two versions of the same MDB.
The same MDB must be used for people form different companies with different
corporate language versions of Office so it’s not possible to use the same
version of Access.

Thanks in advance

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

As with all MsOffice products Localized versions are capable of reading
English mdb's - but not the other way around.
The simple answer is therefore to always develop using the english version.
That said, this code should fix it for you

Sub FindQueryText(Optional ByVal txt As String = "Formularios", Optional
ByVal ReplaceBy As TextBox = VBA.vbNullString)
Dim Db As DAO.Database
Dim Qdef As DAO.QueryDef
On Error Resume Next

Set Db = Access.CurrentDb
For Each Qdef In Db.QueryDefs
If VBA.InStr(Qdef.SQL, txt) > 0 Then
Debug.Print Qdef.Name
If VBA.Len(ReplaceBy) > 0 Then
Qdef.SQL = Replace(Qdef.SQL, txt, ReplaceBy)
End If
Qdef.Close
Next
Set Db = Nothing

End Sub

HTH

Pieter

PS
There's a product on the market called SpeedFerret that also changes all
texts in modules, forms & reports as well


"PMM" wrote in message
news:40EF442C-A8AA-4B2A-AFEE-EE7224E3ECA4@microsoft.com...
> Hello,
> Is it possible to translate the form (, reports, queries,. ) definition of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12232
> an Access database? I've got a MDB build with Access 2003 in Spanish. When
> I
> try to open a form of this database with Access 2003 in English I get an
> error in queries with references to values in fields located in the form.
>
> Enter Parameter Value:
> Formularios!!
>
> I've tried to import the form to a new English MDB but with the same
> result.
>
> This seems easy to change in MSysQueries but this is read-only.
>
> The database is complex with a lot of forms and many references in forms
> and
> reports. It's difficult to manually maintain two versions of the same MDB.
> The same MDB must be used for people form different companies with
> different
> corporate language versions of Office so it's not possible to use the same
> version of Access.
>
> Thanks in advance
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12232

As with all MsOffice products Localized versions are capable of reading
English mdb's - but not the other way around.
The simple answer is therefore to always develop using the english version.
That said, this code should fix it for you

Sub FindQueryText(Optional ByVal txt As String = "Formularios", Optional
ByVal ReplaceBy As TextBox = VBA.vbNullString)
Dim Db As DAO.Database
Dim Qdef As DAO.QueryDef
On Error Resume Next

Set Db = Access.CurrentDb
For Each Qdef In Db.QueryDefs
If VBA.InStr(Qdef.SQL, txt) > 0 Then
Debug.Print Qdef.Name
If VBA.Len(ReplaceBy) > 0 Then
Qdef.SQL = Replace(Qdef.SQL, txt, ReplaceBy)
End If
Qdef.Close
Next
Set Db = Nothing

End Sub

HTH

Pieter

PS
There's a product on the market called SpeedFerret that also changes all
texts in modules, forms & reports as well


"PMM" wrote in message
news:40EF442C-A8AA-4B2A-AFEE-EE7224E3ECA4@microsoft.com...
> Hello,
> Is it possible to translate the form (, reports, queries,. ) definition of
> an Access database? I've got a MDB build with Access 2003 in Spanish. When
> I
> try to open a form of this database with Access 2003 in English I get an
> error in queries with references to values in fields located in the form.
>
> Enter Parameter Value:
> Formularios!!
>
> I've tried to import the form to a new English MDB but with the same
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12232
> result.
>
> This seems easy to change in MSysQueries but this is read-only.
>
> The database is complex with a lot of forms and many references in forms
> and
> reports. It's difficult to manually maintain two versions of the same MDB.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12232
> The same MDB must be used for people form different companies with
> different
> corporate language versions of Office so it's not possible to use the same
> version of Access.
>
> Thanks in advance
>



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4079 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len