AutoFEUpdater Ini and linked tables

  • Thread starter Thread starter darren via AccessMonster.com
  • Start date Start date
D

darren via AccessMonster.com

I have a common FE, but each team of users have their own team backend.

I've just started using the Tony's Updater and wondered whether I can use the
ini file to pass the connection details in to the FE which can then be used
to relink the necessary tables to the teams BE. The idea being that each team
thenhas their own ini file with the connection details to their back end..

This said ini files are totally new to me.

All help and ideas welcome.
 
I don't think Tony frequents this group very often. You'd probably be better
off reposting to microsoft.public.access.multiuser, or just to
microsoft.public.access
 
Thanks Doug

Found a solution. In the ini file CommandLine I added: /cmd "[BE file path]"

The from AutoExec prompted the following

Private Sub sbLinkedTables()

Dim db As Database
Dim tbl As TableDef
Dim rst As Recordset

p_strBEpath = Command()

If IsNull(p_strBEpath) = False Then
Set db = CurrentDb
Set rst = db.OpenRecordset("UsysLinkedTbls", dbReadOnly)

rst.MoveLast
rst.MoveFirst

Do Until rst.EOF

Set tbl = db.TableDefs(rst("Name"))

With tbl
.Connect = p_strBEpath
.RefreshLink
End With

rst.MoveNext

Loop

End If

Set db = Nothing
Set tbl = Nothing
End Sub

Seem to do the trick.

:o)
 
Back
Top