I have an application that I need to distribute with two databases- one
database that our company may change from time to time and resdistribute
to our customers, and a second table that contains the customer's
personal data AND links to the tables in the first database. However,
since I do not know what directory the customer will be installing the
software in, I need to know how to update these links without destroying
the relationships between the tables, etc.
I have tried to use the code samples from MSDN, but when I run the code,
I get a very generic error like "Errors Encountered". I just had to
reboot and lost the code, so I can't reproduce it quickly. I have
written code to delete the existing links and recreate them using the
database in the current directory, but this blows away the
The source and target databases do not have passwords at the database
level, but I do have a custom SECURED.MDW file for the databases. As I
said above, I can write code to delete and recreate the links, so I
think I am handling the password issues correctly.
Are these errors caused by the relationships that exist? Is it too
complex for ADOX to handle, or am I missing a step? Any advice on this
one would be appreciated.