Another item that may add to your code but might make it a lot clearer...

I never use anything but the . commands within a With statement. I see...

Why not? SSMA has no reason to care that the server involved happens to be local. At least no reason I can think of, anyway. ...

Grovelli,

Why do you keep differentiating between "frontend" and "backend" ? If the tables are within the .mdb file, then THAT file IS the Access Database, and that's the...

One more attempt on my part:

DECLARE @MyHead TABLE

(

Row_ID INT,

Promo_ID INT,

...

As much as I hate to be the bearer of bad news, I really don't think there's any viable way for anyone to help you out here. The...

Unfortunately, that's not the result I end up with. I'm unable to refer to any Yes/No field by name. I've long ago given up on using...

Jeff,

He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?

Steve

(aka smunson)

:):):)

Just my two cents, but the OP has consistently NOT provided the exact details of the rules on which the output is based, and instead keeps adding more detail as...

I don't know, but you have to remember that there are three separate events for every key pressed. KeyDown, KeyPress, and KeyUp. They occur IN THAT...

Or this...

CREATE PROCEDURE

TO KILL CURRENT DATABASE

WHEN USER DUMMY

or ...

SET VARYING LENGTH

VALUES FOR UNION INPUT

TO GET UNIQUE DATE

Steve

(aka smunson)

:):):)

Atif,

Here's an idea, using the concept you started with...

WHEN USER DUMMY

THEN FETCH CURRENT BACKUP AND

RESTORE DATABASE

Steve

(aka smunson)

:):):)

As for what to do about the space problem, I think you'll have no choice but to make that the first thing you check for on the KeyDown event, and...

Which software are you referring to when you say "You can only use the License once" ? The software from the DreamSpark site, or a paid for Developer...

Maybe I shouldn't give up so easily. Turns out the Key Down event DOES FIRE for the DELETE key, so there's likely to be a solution using the...

Ok, let's clarify, as I'm a bit confused. I had the impression that your tables were within the Access file (.mdb I presume), so if that's the...