I doubt it's going to work because you cannot set District to 1 and something else at the same time

OR ((([Austin Police Department].District) Like "*" & [Forms]![Austin Police Department- District...

Hi, what happens if you use

WHERE [Austin Police Department].District = 1 AND ((([Austin Police Department].Name) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*")) OR ((([Austin Police Department].Location) Like...

"Often I will develop a permissions script setting permissions for the varous objects."

What do you use to develop permission scripts?

Are there any books that explain syntax such as $x or //EXPR

?

Sounds like the same advice you can find here: http://accessexperts.net/blog/2012/07/31/my-best-presentation-is-now-online-optimizing-access-with-sql-server/#comments

"i'm currently using a thread in the ms access section"

I can't see the thread, have you started it?

Thanks, so with Access can you manipulate namespaces like you see doing here> http://www.sqlservercentral.com/Forums/Topic1360396-21-1.aspx

?

What is the command that makes you go from

CREATE TABLE #XML_SOURCE(

...

select * from #XML_SOURCE;

to

<Assets>

...

</Assets>

?

And what is a good book to learn the syntax used by arthurolcot in his reply?

For...

What's the meaning of

FOR XML EXPLICIT

?

I'm not an expert but shouldn't the query have "active" somewhere in it in order to return

<active>1</active>

?

Giorgio

@Don

that was magically done:cool:

I suppose it could be further refined into:

SELECT Reciprocals.*, Reciprocals_1.UniqueID

FROM Reciprocals LEFT JOIN Reciprocals AS Reciprocals_1 ON Reciprocals.RelatID = Reciprocals_1.RecipID

WHERE Reciprocals.UniqueID<Reciprocals_1.UniqueID OR Reciprocals_1.UniqueID Is Null

so...

@liebesiech

"I hammered a small MDB file together"

When I open your mdb, the Access VBA References window on my pc says I'm missing SQLDMO.dll version 8.5, where can I...

Thanks! 🙂

What's a timestamp and how do you add it to every table?

Thanks Glen, I've downloaded and extracted all the files in your Images.zip, what's the name of the file holding the revised article containing the explanation?

It's just a little vbscript on...

Hi Glen, I've downloaded the files and I'll be looking at them(on and off :-)) during the weekend.

In a previous reply, you say, "The updated article explains how this enhancement...