I think you will find that the database engine needs write access even if you don't. I've encountered this problem before, and we had to copy from the CD to a harddrive and take off the read-only flag (as nicsin said).
I don't know if anyone knows of a workaround? Different database drivers...
Have a look at "Unload", and "Show" in the help. You might want to have the timer-reset functionality on a separate form to the one you want to re-initialise.
Hope this helps
Regards
Daren
Must think of a witty signature
Hi cjac
I don't think this is the case. If your array is declared globally and you change the dimensions and populate it, the data will be there for all procedures.
I'll just try this to make sure....
Yes, I declared an array in a module and used a subroutine in a form to resize it and fill...
From specters,if a wish for thing and a thing passed hoping for should come to a man. Will he not welcome it the more. Therefore it is more welcomed to meat and gold. At less beer brings back my desire of old."
A change in punctuation and some extra letters might help here:
"From...
I don't know about a "best" way, but I used Microsoft's XML SDK to write an application which creates XML documents in a specific format. It took a little while to get my head around first the XML concepts, and then Microsoft's objects and methods, but it was worth it (for me).
You...
Screen.ActiveForm should give you the form that currently has the focus e.g.
Screen.ActiveForm.Text1.SetFocus
Hope that's what you are looking for
Regards
Daren
Must think of a witty signature
The book I bought was "Beginning XML 2nd Edition" by Hunter, Cagle and a few others, published by Wrox. It has a chapter on the DOM as well as an appendix which lists the DOM interfaces. I found it very useful for this, and if I need to go deeper into XML there is a lot more in the...
Check out "ShellExecuteEx" and "WaitForSingleObject" API calls. There are plenty of examples on the web and probably on TT too.
Hope that helps
Regards
Daren
Must think of a witty signature
Hi Brad
As part of my current project I did this the other way around - I extracted data from a database and wrote it to an XML file. I got a book on XML (although there are plenty of sources on the web - I just prefer books :-)) and used some code examples from the web to create a basic XML...
I believe that the DLLs do get over-written. It could cause problems with other applications that can't use more recent versions of the DLL - it depends on whether the DLL has been written to be backwards-compatible I suppose. I think the various versions of Windows have different strategies for...
I think vb5prgrmr was right - it was the usual VB " problem. What you did should have worked fine once the quote-marks were sorted out. I have used the same method as you, I just used single quotes as delimiters:
[/code]
Set xpProcIns = .createProcessingInstruction("xml"...
From what I have read, the XML file needs to have a specific format for it to be opened via ADO. Do you absolutely have to open it in this way or could you open it via the XML DOM and parse the contents into a database?
Daren...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.