Welcome to SPN

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

Sign Up Now!

Linking from code , works but slow

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

  1. Domac

    Domac
    Expand Collapse
    Guest

    Hi,

    Just finished implementing Linking from code depending on user profile , but
    it is pretty slow , how to make it faster????
    Access wizard links tables faster then my code, here is snippet:


    While Not rst.EOF = True

    Set tdef = CurrentDb.CreateTableDef(rst!Tablica)

    tdef.Connect = rst!Linkbaza
    tdef.SourceTableName = rst!LinkTablica

    CurrentDb.TableDefs.Append tdef



    rst.MoveNext
    Wend


    Thanks!
     
  2. Loading...


Share This Page