Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Use a MDB created in different language

Discussion in 'Information Technology' started by PMM, Jul 28, 2006.

  1. PMM

    PMM
    Expand Collapse
    Guest

    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!<form_name>!<field_name>

    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
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    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" <PMM@discussions.microsoft.com> 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!<form_name>!<field_name>
    >
    > 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
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    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" <PMM@discussions.microsoft.com> 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!<form_name>!<field_name>
    >
    > 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
    >




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

Share This Page