![]() |
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: 3132 error when using DAO
ws = dao.CreateWorkspace("JetWorkspace", "admin", "")
This error only happens with the compiled code - it works fine from the interpreter (within WinBatch Studio).
I assume I've left something out but can't track it down. Any help would be appreciated.
Sample code
dao = objectopen("DAO.DBEngine.35") ws = dao.CreateWorkspace("JetWorkspace", "admin", "") db = ws.OpenDatabase("%WorkDir%ServData.mdb") sqlstr = "SELECT * FROM SERVER ;" rs = db.openrecordset(sqlstr) SServer = rs.fields("Servername") rs.ADDNEW SServer.value = "%ThisServ%" rs.UPDATE ObjectClose(rs) ObjectClose(db) ObjectClose(ws) ObjectClose(dao)
rather than call the DBEngine directly
oAPP = OpenObject("Access Application.8") DB = oAPP.DBEngine
then create your workspace.
Article ID: W14425
Filename: 3132 error when using DAO.txt
File Created: 2001:12:12:17:16:30
Last Updated: 2001:12:12:17:16:30