Search results

If you plan to use Access and Excel to do this you are going to utilize network bandwidth unless the both the front-end and backend are off the network. Unlike SQL Server that has a service running which does all the heavy lifting on the server side, Access has no such service running, the...

I agree with spikepl, if the response is very simple it would be easier and faster to just extract what you need from the response text, if however it is very long and complicated with multiple embedded structures/nodes, then loading it into a navigator of some kind might be useful.

You could use a DOMDocument object to parse the XML. http://stackoverflow.com/questions/11305/how-to-parse-xml-in-vba

Lots of questions here, and a lot to consider. 1) This looks like a viable way to send/receive your data. 2) The Response = objXmlHttp.responseText is where you are going to get the formatted response, you would need to load that Response into an XML document, or parse it yourself. Here is a...

This happened to me on an older version of SQL server as well, I deleted the DSN and re-created it, that worked for me.

This happens to me anytime code changes have been made, I think Access elevates the lock permission to exclusive and won't release it until the database has been closed and re-opened. At least that always works for me, not sure if your issue is related.

Any objects you create in Access, forms, reports, code, would require some version of access to be installed on the host system. To my knowledge only the windows CE platform has a mobile version of Office available. Now that's not to say you couldn't create a web based database as others have...

that code is C#, here is the MoveWindow API in VBA. To get the handle to the program you will need to use the FindWindow API to locate the window and get the handle to the program since the Shell command doesn't return a process or window handle. Private Declare Function MoveWindow Lib...

There is no one query type that can do what you want, you need to run 2 seperate queries as you're doing, one for the update, one for the insert. If you don't want duplicates either key the table to prevent them, or join the table to itself in the insert query and only insert records where the...

Well ultimately they need to access something that has access to your network share. Web database is probably your best route, another option would be to build a seperate database for the end users, and have them (or the program) export data and email / ftp it to a place where a process on this...

This function will = 0 if the form is closed, 1 if it is open. syscmd(acSysCmdGetObjectState,acForm,"FormName")

Apparently the code is trying to compile before you're able to check or change references, it would seem this can't be done through VBA on a remote database that has a missing reference.

Maybe try a simple approach to start Dim ref As Reference Set ref = a.References![Office] a.References.Remove ref

It's not a BuiltIn reference is it?

Maybe try this. x = 1 For x = 1 to a.References.Count If a.References.Item(x).IsBroken = True Then set myref = a.References(x) a.References.Remove (myref) Else Debug.Print a.References.Item(x).FullPath End If Next x

I would think application.References.Remove

Well it may not be possible then to programatically update just the path, you could try removing the references then remotely using the AddFromFile method of the reference object. Bottom line though this is dodgy business and I am not surprised it is difficult and perhaps not possible to do...

In this case it doesn't, references is part of the application object, not the database object. You need to declare a Access.Application variable then set that equal to your database.

many options there, but if you know the old path and the new path I might try something like If Application.References.Item(x).FullPath = OldPath Then Application.References.Item(x).FullPath = NewPath end if you could throw that into a for next loop, or use any other method you'd like.

Hmm, if you have an autoexec macro or form set for startup that is more difficult, you can look at using API's to simulate holding down the shift key, but aside from that I don't know of a way to disable that code from running.