My office is getting ready to upgrade our document management system from Hummingbird’s Docs Open to DM5. On occasion, I need access to the document where it lives on the server (and not just through the DMS’s interface). Our new DMS has completely locked our ability to see a document’s real path. I have a query created in SQL view that will give me the path to the document, but I would like a way to automate it a bit more.
[indent]
SELECT P.DOCNUMBER,V.VERSION,V.VERSION_LABEL,P.DOCSERVER_LOC + P.PATH+C.PATH
FROM DOCSADM.PROFILE P,DOCSADM.COMPONENTS C,DOCSADM.VERSIONS V Where P.DocNumber = C.DocNumber AND P.DocNumber = V.DocNumber AND C.Version_ID = V.Version_ID AND P.DocNumber = 600000
[/indent]
Currently, I have to go into the query, switch to SQL view, manually change the document number (the 600000 at the end), then save to see my path. I was wanting to set up a form that I could type in the document number and it would automatically do all the background stuff and display my path for me. Is there a way to do this?
Thanks,
Becky
We’ve worked with queries and forms and all kinds of Access stuff, but this is our first time trying to talk to anything outside of Access.
I sent the stuff over to him, and he fixed everything right up. In my original query, he removed the “AND P.DocNumber = 600000” section and created a second query (a regular access one, this time) that linked to a field in a new empty table he created. The table has a field named “docnumber” just like the the SQL database. The form he created lets you add an entry to the new table, then immediately run the query. It takes a few seconds to run, but it gives us exactly what we needed.
