How can I change defined postgresql schema when using Access linked table manager

[kdric]

I am using postgresql 9.3 on Windows 8 64, and am using Access as a frontend data entry. In postgresql I have changed the schema from 'public' to 'irll'. The linked tables in Access are still linked as 'public' (e.g. 'public_table1') and I need to update/change the connection of the tables to match the new schema in the postgresql db (e.g. 'irll_table1').



Using the linked table manager, I cannot see an option to change the old schema prefix of 'public' to the new of 'irll'.


I can easily set up a new odbc connection with the new schema, but if I do this I will lose the data input forms I have set up in the Access database. How can I change the defined schema of the linked tables?

[ItsMe]

I do something like this to assign connection properties to tables. Maybe you can see what an existing table's connection property looks like by using debug.print or something, then edit as needed.

Dim t As TableDef
Dim strTableName As String

        strTableName = "NameOfTable"
        Set t = db.CreateTableDef(strTableName)
        
            t.Connect = connectionStringODBC
            t.SourceTableName = strTableName
            
            db.TableDefs.Append t
            t.RefreshLink
            
        Set t = Nothing