T
Tom P.
I have some code that relinks all my ODBC tables because I
need to prompt each user for their personal account info
when they open the database. I do this by rebuilding the
connection string with their credentials and then calling
the TransferDatabase method for each linked table.
A small number of my linked tables (they are from a Sybase
database...) do not have unique indexes and this caused
Access to prompt for their unique record identifier upon
linking. The user can simply not select anything an press
the OK button and the app works fine.
I'd like to do something so that this box either does not
appear or so that I can detect the prompt and
programmatically close the box so that the user does not
need to get involved. As it is now I can see some users
stumbling on this question when prompted...
Anyone know how to make the prompt go away or how to
handle closing it from VBA?
Thanks,
Tom
need to prompt each user for their personal account info
when they open the database. I do this by rebuilding the
connection string with their credentials and then calling
the TransferDatabase method for each linked table.
A small number of my linked tables (they are from a Sybase
database...) do not have unique indexes and this caused
Access to prompt for their unique record identifier upon
linking. The user can simply not select anything an press
the OK button and the app works fine.
I'd like to do something so that this box either does not
appear or so that I can detect the prompt and
programmatically close the box so that the user does not
need to get involved. As it is now I can see some users
stumbling on this question when prompted...
Anyone know how to make the prompt go away or how to
handle closing it from VBA?
Thanks,
Tom