Re: how to use a trigger to stop an insert/update?

On Feb 1, 2:25 pm, Art Kagel <art.ka...@xxxxxxxxx> wrote:
You can access data from multiple databases when their logging mode is
different by establishing separate connections to each database and using
the SET CONNECTION statement to switch connections.  You cannot join tables
in the two databases until both logging modes are the same.

Art


I'll do some testing with the SET CONNECTION later this week.
For the trigger I'm going to try to change the overlapping dates from
the SP or maybe insert a row in table so I can keep track of these
rows and forward them to whoever should fix them. This should help
while we manage to convert to logged.
In the next weeks I'll make a new post for the conversion to logged to
get some pointers.


thanks
.

Relevant Pages

  • Re: Timestamp in Webforms & Access
    ... Add a date time field to your database named say: PostedOn ... dim conn ... 'set connection string to local variable-I use a DSN-less connection ...
    (microsoft.public.frontpage.programming)
  • Re: Timestamp in Webforms & Access
    ... Add a date time field to your database named say: PostedOn ... dim conn ... 'set connection string to local variable-I use a DSN-less connection ...
    (microsoft.public.frontpage.programming)
  • Timestamp in Webforms & Access
    ... FrontPage forms to connect to a database on our subwebs. ... dim conn ... 'set connection string to local variable-I use a DSN-less connection ... set conn = server.createobject ...
    (microsoft.public.frontpage.programming)
  • Re: EXEC SQL CONNECT TO
    ... > Tibor Karaszi, SQL Server MVP ... > database name, user name, but none of them work. ...
    (microsoft.public.sqlserver.server)
  • Operation must use an updateable query.
    ... Microsoft JET Database Engine ... Operation must use an updateable query. ... Dim sConnString, connection, sSQL ... Set connection = Server.CreateObject ...
    (microsoft.public.access.formscoding)