J
Jim Mc
I believe I'm having DOA/ADO reference conflicts. The following code
is running on several machines. Some get error, some don't - all
running access 2000. Error 13 received at the Set Mydb statement...
Dim Mydb As DAO.Database, MyTable As DAO.Recordset
Set Mydb = DAO.DBEngine.OpenDatabase("X:\Box\Attend\ATNDDATA.MDB")
Set MyTable = Mydb.OpenRecordset("tblAbsence Data")
MyTable.Index = "EMP NUMBER" 'Index of
table
Points = 0!
CurDate = Now 'Current Date is today
Any help appreciated.
is running on several machines. Some get error, some don't - all
running access 2000. Error 13 received at the Set Mydb statement...
Dim Mydb As DAO.Database, MyTable As DAO.Recordset
Set Mydb = DAO.DBEngine.OpenDatabase("X:\Box\Attend\ATNDDATA.MDB")
Set MyTable = Mydb.OpenRecordset("tblAbsence Data")
MyTable.Index = "EMP NUMBER" 'Index of
table
Points = 0!
CurDate = Now 'Current Date is today
Any help appreciated.