have a database that uses linked tables
Every time the db is opened the startup form deletes current links and creates new links to tables in a file path set in an ini file.
This works fine as long as the old path is still valid. If the db is opened and table links are created and then either the database is moved or the path to the old tables is re-named, Access gives the error
'<Path> isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. (Error 3044)'
there is error trapping in the code that should just allow the old link to be deleted and the new link to be established. but Access halts with error 3044 before it opens the startup form.
Any body got an idea how I can get around this
Every time the db is opened the startup form deletes current links and creates new links to tables in a file path set in an ini file.
This works fine as long as the old path is still valid. If the db is opened and table links are created and then either the database is moved or the path to the old tables is re-named, Access gives the error
'<Path> isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. (Error 3044)'
there is error trapping in the code that should just allow the old link to be deleted and the new link to be established. but Access halts with error 3044 before it opens the startup form.
Any body got an idea how I can get around this
Comment