Hide Select Unique Record Identifier

[Rich K]

I'm linking to a db2 database from within access. I can create views on the
server and then link to it from vba code just fine.

However, when I link it the "Select Unique Record Identifier" dialog box
appears for the user to resolve. I'd like for that dialog box to not
appear, either by automatically selecting an identifier or by totally
disreguarding the box.

Any ideas on how this is done?

 

[Brian]

What is happening is that the DB2 database is probably multi-keyed and Access
needs to be told which key is the unique one (a wrong choice could give you
incorrect data selection later).

Establish the link one time, then leave the linked table in the Access
application and distribute that to users. Then they will never see the Select
Unique Record Identifier.

I would strongly discourage anyone from leaving end users to link tables
themselves. Instead, consider deploying an Access application that already
has all the links established one time, and let users run their code/queries
against the linked tables.

 

[Rich K]

Thanks Brian,
I found a solution to the issue by strategically placing a sendkey({ESC}) in
my code. While it would be wonderful to create a link once and forget about
it, the links are to views that will be dynamicaly created and linked from
code. We're doing this as part of our attempt to decrease process time for
some tedious code events.

If anyone wants more information about how I implemented the solution let me
know.

 

[Seasoned Cross-Vendor BugFinder]

Rich,

I would certainly like your solution. I'm trying to do the exact same thing
and am up against the same problem.

Lynn