Group:  Microsoft Access ยป microsoft.public.access.adp.sqlserver
Thread: Different @@SPID for same user/connection ?!?!?!

Geek News

Different @@SPID for same user/connection ?!?!?!
hpesata <hpesata[ at ]gmx.at> 5/23/2007 1:01:23 PM
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 [ 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
Application.CurrentProject.Connection

how can I work around this ?

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

regards,
Hans

Re: Different @@SPID for same user/connection ?!?!?!
"Malcolm Cook" <malcook[ at ]newsgroup.nospam> 5/23/2007 2:00:33 PM
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?

Regards,

Malcolm

"hpesata" <hpesata[ at ]gmx.at> wrote in message news:1179925283.585481.199230[ at ]k79g2000hse.googlegroups.com...
[Quoted Text]
> 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 [ 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
> Application.CurrentProject.Connection
>
> how can I work around this ?
>
> any help with this would be greatly appreciated,
> thanx in advance!
>
> regards,
> Hans
>


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net