setting unique table

[Jason]

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?

 

[Damiaan]

Are you sure that you didn't make your query too complex?

--

Kind Regards
Damiaan
e: info at dampee.be
w: http://www.dampee.be