creating local table from SP

Hi ,
i am using Ms Access to connect to SQL SERVER, i am running some SP that
create the local tables in SQL Server , but is there anyway for me to change
the SP such that the "local tables" will be created in MS Access instead ?
tks & rdgsHi
The SP runs inside SQL Server, and it does not know, or care about the
Access Front-End. A SP can not modify a local Access DB, unless SQL Server is
linked to it (no Access linked to SQL Server)
Regards
Mike
"maxzsim" wrote:
> Hi ,
> i am using Ms Access to connect to SQL SERVER, i am running some SP that
> create the local tables in SQL Server , but is there anyway for me to change
> the SP such that the "local tables" will be created in MS Access instead ?
> tks & rdgs