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 [ at ][ at ]SPID?
"hpesata" <hpesata[ at ]gmx.at> wrote in message news:1179925283.585481.199230[ at ]k79g2000hse.googlegroups.com...
> 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.CurrentProject.OpenConnection strConnect, strUser,
> I am also using [ at ][ at ]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 [ at ][ at ]SPID, because one of my
> forms uses
> a different [ at ][ at ]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
> how can I work around this ?
> any help with this would be greatly appreciated,
> thanx in advance!