setting unique table

[DTSFreak]

Hi,

I've an acces form which recordsource is generated through an
ado-connection. This ado-connection calls a view in sql server. Within the
view there are multiple tables joined from different databases in sql
server.

The problem is that i cannot update a field in the access form because no
unique table is set.

So to resolve this problem, how can i do this without telling the form which
table's name it should use. I don't want my frontend to know database
specific names. If i can tell my form to use a unique table within my view,
that would be great.

Is this possible?

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886