You can still download the full evaluation version on microsoft.com.

That could give you some more time to find and buy the real dev version.

Can't be done easily if you have foreign keys all over the place.

One thing you can do is script the whole database, rename the actual DB, then run the script...

sarg = searchable argument.

This is a where clause that can use a index : WHERE MyDate BETWEEN '2007-07-01' AND '2007-07-02'.

Non searchable argument in that exemple would be this : Where...

Try again with the bit column, you'll most likely see a convert_implicit in the execution plan.

Change to sarg like this : WHERE BitCol = CONVERT(BIT, 1)

That'll most likely push you back...

Here's the whole tree (very roughly presented) :

--> Sql servers

--> Databases

--> Access data projects

--> Top level objects (Forms, reports, macros...)

--> FormsObjects

--> FormsObjectsProperties

--> FormsObjectsPropertiesEvents

--> FormsObjectsPropertiesCodes (I was insterting the code...

Fixed width = CHAR

always english = VARCHAR

This however assumes that those variables will never change, which is sometimes hard to garantee.

Not that I know of.  AFAIK, unless you had profiler running, there's nothing you can do now... except turn auditing on!

Agreed.  Dynamic sql was made for cases like this one.

AS long as you are not using user inputs in the proc, stay with loop / dynamic sql.  The solution is...

Wasn't even aware that I was that close .

Maybe I'll even get there before PASS 2007.

That happens... I don't ahve time to reread the whole post everytime I answer... sorry if anyone got offended by that "double" post .

truncate both tables, insert data in both systems.

GO home.

WHILE EXISTS (SELECT * FROM tbl1 WHERE value1 = 'abc')

BEGIN

UPDATE table1 set value2 = '123' where value1 =...

Pretty much ya...

What do you want to do next?

Check out the adox refferences in access.  That'll get you started.

You can also access the system objects to find the list of tables of Access (check the options to show...

Yes.

This is one rare case where using EM to do the job will be faster... and error proof (developping time wise).