Storing xml Files within Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tracey - 07 May 2008 19:51 GMT

I have an Access database that stores software keys. The company I work for
sells a software product with 3rd party software, all of which each has a
software key (currently just a string of text). I now need the ability to
store a software key in this database that is generated via an xml file.
There is a separate front-end accessible by many users who will need to
obtain this key in the xml format. Is it possible, or smart, to save these
files within the Access database? Any other suggestions? Thanks in advance!

Reply to this Message

Arvin Meyer [MVP] - 08 May 2008 12:43 GMT

Access 2007 has an attachment datatype that could probably handle this.
Previous versions would need to store the text , most likely in a Memo
datatype field, unless they could be guaranteed to be under 255 characters
which then could be stored in text.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have an Access database that stores software keys. The company I work
>for
[quoted text clipped - 6 lines]
> files within the Access database? Any other suggestions? Thanks in
> advance!

Reply to this Message