Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: temporary database
Here's some sample code to do that.
Make sure DAO.DBEngine.35 exists on those computers. Maybe try searching the registry for that application object. Search under HKEY_Classes_Root for DAO.DBEngine....
And make sure that version 3.5 (35 above) is installed. Open up the registry editor on the PC and do a search for:
DAO.DBEngine
If it's installed it will show up as: DAO.DBEngine.35
dao = objectopen("DAO.DBEngine.35") ;english language lang = ";LANGID=0x0409;CP=1252;COUNTRY=0" ver = 32 ;database version 3.0/3.5 file ws = dao.CreateWorkspace("JetWorkspace", "admin", "") db = ws.CreateDatabase("d:\report stage\test.mdb", lang, ver) ; create a table in the new db tablesql = "create table [Test Table] ([First Name] TEXT (77), [Last Name] TEXT (77), [Amount] LONG, [Comments] MEMO)" ; execute the table build SQL command... db.execute(tablesql) sqlstr = "SELECT count(*) as [cnt] FROM [Test Table];" db.createquerydef("Test Query", sqlstr) objectclose(db) objectclose(ws) objectclose(dao) message("Debug", "End of Job") exit
Article ID: W14665
Filename: Code to Create a Temporary DB.txt
File Created: 2003:02:03:15:41:50
Last Updated: 2003:02:03:15:41:50