accesser2003
Registered User.
- Local time
- Today, 06:37
- Joined
- Jun 2, 2007
- Messages
- 124
I have a linked table to a SQL server table called AllAttendanceEvents.
the AllAttendanceEvents table has index called "AttEvents". I wrote the following code:
set AllAttendanceEvents=currentdb.openrecordset("AllAttendanceEvents")
AllAttendanceEvents.movefirst
AllAttendanceEvents.index="AttEvents"
When it executes the read line statement, it generates the following error:
Operation is not supported for this type of object
Is there any way to get around of this problem with the linked tables?
the AllAttendanceEvents table has index called "AttEvents". I wrote the following code:
set AllAttendanceEvents=currentdb.openrecordset("AllAttendanceEvents")
AllAttendanceEvents.movefirst
AllAttendanceEvents.index="AttEvents"
When it executes the read line statement, it generates the following error:
Operation is not supported for this type of object
Is there any way to get around of this problem with the linked tables?