Provided by Peter Vukovic, September 1995.

'Debug.Print ' Database=' + path + dbsource Microsoft Office For Mac Os X 10.7 5 Free Downloadownload microsoft word 2010 for free.This Microsoft office for mac is one of the best and successors of 2011 and it is followed by the Microsoft office for mac of 2007. Source = Mid(db.tabledefs(i).connect, 11)ĭbsource = Mid(source, j + 1, Len(source))ĭb.tabledefs(i).connect = ' Database=' + path + dbsource Productivity downloads - Microsoft Word by Microsoft and many more programs are available for instant and free download. Set db = dbengine.Workspaces(0).Databases(0) '* AND THIS PROGRAM WILL CHANGE THE CONNECTIONS AUTOMATICALLY '* START YOUR APPLICATION (MACRO: AUTOEXEC) WITH THIS FUNCTION If your data and program are in different folders, see Dev Ashish's solution: Relink Access tables from code Function Reconnect () Peter Vukovic's function handles the reconnection. If you have an Access application split into DATA.MDB and PRG.MDB (see Split your MDB file into data and application ), and move the files to a different directory, all tables need to be reconnected. Microsoft Access tips: Reconnect Attached tables on Start-up MS-Access Tips for Serious Users

Microsoft access 13