Different @@SPID for same user/connection ?!?!?!

[hpesata]

Hi!

I am currently writing an ACCESS ADP app which uses SQL Server 2005
Express Edition.

users have to login to the app/database and I am setting the current
application-connection:

Application.CurrentProject.OpenConnection strConnect, strUser,
strPassword

I am also using @@SPID within my tables/stored procedures to enable
users to have specific data.

The recordsources of my forms use SQL-server views/UDFs, I am
modifying data
within my database via stored procedures.

I am now running into a problem with the @@SPID, because one of my
forms uses
a different @@SPID than the others and my user-specific approach
doesnt work...

how can this happen ?

somehow access seems to use a different/new connection for this forms
recordset than
Application.CurrentProject.Connection

how can I work around this ?

any help with this would be greatly appreciated,
thanx in advance!

regards,
Hans

 

[Malcolm Cook]

Do you have subforms? If so, then heed these words: "Unlike with other database objects, Access does not always use the same
connection to retrieve the data source of a subform." - http://support.microsoft.com/kb/308312

What is the effect you are trying to acheive by using @@SPID?

Regards,

Malcolm