Actually, the "xml" you posted is still only pseudo XML. It is not legitimate XML. It is missing the closing tags for Pharmacy and RefillRequest.

Actually Lowell's example shows you...

Well don't just take my opinion as the direction you should go....

Grant Fritchey (5/7/2013)

---

Sean Lange (5/7/2013)

---

Grant Fritchey (5/7/2013)

---

Funny you should ask this because the newest version of Access is running SQL Server. The Jet engine is gone. It's just a really...

Grant Fritchey (5/7/2013)

---

Funny you should ask this because the newest version of Access is running SQL Server. The Jet engine is gone. It's just a really fancy GUI on top...

Using google with your exact subject returned this as the top hit.

http://msdn.microsoft.com/en-us/library/bb500435.aspx

todd.ayers (5/7/2013)

---

ok... well I am an access noob and have only been using it since the middle of March... Next question is on a scale of 1 to 10 How...

todd.ayers (5/7/2013)

---

Looking for good and/or bad reasons to use SQL server as a back end component to access 2007 and use the Forms and Reports of Access as the GUI...

That is true for storage (well most of...

Oops I misread your original post. I thought you had said using...

rayh 98086 (5/6/2013)

---

Hi,

I am using a stored procedure and would like it to find a file on a different server location. When on the server, I have access to...

You can just run this.

SELECT SYSTEM_USER

Certainly no rush. Just something that might make the search a bit more friendly. Thanks for your help Steve.

Ross McMicken (5/6/2013)

---

The only reliable way I am aware of to present records in a desired sequence is to use an order by clause when you select the records. I...

kapil_kk (5/6/2013)

---

Hi, I have a scenario in which I am performing insertion on a table using a stored procedure. For every insertion there is a ID generation for the rows...