I was building a database in WordPress but their table interface lacks completely and I dont want to spend 200 hours developing a backend for a once-off project.
I always used MsAccess for RAD blueprinting and I reckon you can build a better more flexible interface in 20 hours. With XHR MsAccess has some better internet capabilities these days, a nice simple XMLHttp library.
You can use it for any http rest api in the cloud.
Ajax for Access :) here’s the most basic wordpress xml-rpc call, sayHello.
Sub PutXML() txtURL = "http://www.blog.com/xmlrpc.php" txtUserName = "user" txtPassword = "pwd" Dim objSvrHTTP As ServerXMLHTTP Dim strT As String Set objSvrHTTP = New ServerXMLHTTP objSvrHTTP.Open "POST", txtURL, False, CStr(txtUserName), _ CStr(txtPassword) objSvrHTTP.setRequestHeader "Accept", "application/xml" objSvrHTTP.setRequestHeader "Content-Type", "application/xml" strT = "" strT = strT & "
" strT = strT & "" objSvrHTTP.send strT MsgBox objSvrHTTP.responseText End Sub demo.sayHello" strT = strT & "
For pre-Vista you need the MSXML 6.0 library from microsoft, in Vista I already had it installed so you can add a reference to the library and off you go.