Thanks Glen, no, the blackberry directory on my desktop can't be reached over the Web. What would I need to do to achieve that? I see you mention an asp...

I see James mentioned a CLR stored procedure, what is it?

I've also tried to follow the instructions in the article to access the C:\BlackBerry folder on my pc so I...

Plus this type of security isn't natively supported in Access 2007/2010 but only for backward compatibility.

It seems to me that Roy's sql statement deletes all the records in t1 which aren't present in t2 while John's deletes all records in t1 which are also present...

Are you using the same Type mentioned here: http://www.sqlservercentral.com/Forums/Topic1016736-21-1.aspx

?

Thanks Philipp,

can you give me an example of a CHECK constraints with a SELECT statement in it?

By the way, shouldn't it be

DB_Connection.Execute SQL_Statement(i)?

Hi Philipp, where do you get this SQL Scratchpad?

Where do the extracted data end up?

Hi Chris, your last two posts definitely take Access to another level because they tap its potential.

How do you go about amending a SQL pass-through query to use the generated...

Thanks RF, maybe we should get together on Windows Live Messenger for a three-way webcam chat or make it four-way if we invite jd 60382 http://www.sqlservercentral.com/Forums/Topic807393-131-2.aspx#bm888908

"As you can't...

:satisfied: I guess they got down to it

That's been a fantastic exchange. Congrats fellows!!:-)

P.S. how come, when you click the "More..." link to access additional smileys, you get the message:

The following error occurred...

Sorry the...

Thanks! 🙂

How come you delete the tables after relinking them?