I've not had a chance to fully read up about the refreshlink method, but from what i understand does this mean that i would have to refresh the link for each indicidual table or could i just specifiy the backend file?
You have to refresh the link for each table. You can use a function such as:
Dim dbs as DAO.Database
Dim tdf as DAO.TableDef
Set dbs = Currentdb
For Each tdf in dbs.Tabledefs
if Len(tdf.Connect) Then
tdf.Connect = <New connection string>
Set dbs = Nothing
Been there done that there a lot of work to be done where you could just put 5 shortcuts on the desktop
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.