Local tables vs. linked

[Mike]

Hi,

I've an application connected to MSSQL. I need to create a table for the
local application which should not be part of the SQL but when I create it,
automatically it's created in the SQL server. How do I ensure that a table
stays with the application (not linked)?

TIA



--------------------------------------------------------------------------------

Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 857 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!

 

[Sylvain Lafontaine]

The newsgroup m.p.a.adp.sqlserver is for ADP project and has nothing to do
with ODBC linked table and MDB database files. You should post in a more
appropriate newsgroup.

If your question is really for ADP, then you are out of luck: ADP files
doesn't have and cannot have any local table.

 

[ciroteo]

Hi,

I've an application connected to MSSQL. I need to create a table for the
local application which should not be part of the SQL but when I create it,
automatically it's created in the SQL server. How do I ensure that a table
stays with the application (not linked)?

TIA

--------------------------------------------------------------------------------

Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 857 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!

for example you can create a table on the server, or by the way you can
use the same. Then You can add a field with autovalue the name of the
user or another uid. Then using a update query you can populate the
same table with all the record you need and a user value in the new
field.
In this way the user will update or manipulate only the records
matching his user name and
at the end of the procedure you will delete all the records you have
temporarly created.
hope it's clear!

 

[aaron.kempf]

ADP is a great solution; i really really reccomend it.

it is a lot simpler to troubleshoot

-Aaron