Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need diff. way to link tbles besides cat.tables.append tbl

Status
Not open for further replies.

daddypost

Technical User
Oct 21, 2004
98
US
i've currently got code automatically checking for passwords, and remote tables using cat.tables.append tbl. Our lan team just set up a locking scheme which apparently doesn't like what I'm using (long story short, it makes two unsuccessfull attempts at linking for every successful attempt and them locks out at 6 unsuccessfull attempts. So any database with more than 3 tables locks out users when updating links). Anyway, my managers boss feels that the function is old and there has to be a new way of accomplishing the same task. Does anyone know of a newer way of doing this? Thanks in advance for your help.
 
Catalog is an ADOX object. ADO starts from Accees 2000 or newer
TableDef is a DAO object. DAO starts from the beggining of Access

Both are used in a different way to play with MS Access tables.

I feel we 'll have to wait till the .Net implementation into MSAccess (brrrrrrrrrrrrrrrrr)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top