How do I synchronize a web database (Access 2000 format) with a d.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with Office XP to develop a site where we are unable to use the
SharePoint Timer Service, and the only way I have seen so far that I might be
able to send data from a desktop computer's Access database to the web server
Access database is via XML export and import. However, it seems no matter how
or what I export in XML format, whether I embed the schema or include
presentation code, Access cannot import the data.

I believe I can code the modules to run in both environments if I can just
get the data out there. I am willing to look at other formats, just so it
works. Thanks.
 
I haven't used the XML import/export features in Access 2002 or 2003 yet,
because I wanted to maintain compatibility with Access 2000. So I used the
MSPersist XML format (the format that's used when you save an ADO recordset
as XML). There are some glitches to be worked around, and it's not pretty,
but it does work.

If you want to look further into this, check out KB article 263247, "HOWTO:
Obtain an ADO Recordset from XML"

I found that in order to get Access to read correctly from the XML file, I
had to use the abbreviated empty element closing tag format <z:row ... />.
It would not read correctly from the XML file when I used the
non-abbreviated format <z:row ...></z:row>. I used the following regular
expression to doctor the XML (this is C# code in the web service that
queries the database and returns the XML) ...

strResult = System.Text.RegularExpressions.Regex.Replace(strResult,
">\\W*</z:row>", "/>");
 
Back
Top