The recordset interface is referred to as Active X Data Objects (ADO).It requires a different syntax than DAO, but your experience with DAO will transfer nicely, and it has a much more powerful and consistent toolkit for accessing today's variety of PC and mainframe database formats on the Web.
Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in d:\apache\cm\on line 13So...Because they are organized into functional topics and kept very short, none of the examples can stand alone. A minimum program would need to use a combination of the "Opening", "Displaying" and "Closing" topics.You can cut and paste the short program topics into a working program.In Access create a new blank table and highlight 8 datasheet columns.Paste the example data into the table and rename the fields to the names above. If you have the examples only in hard copy, you would have to re-type the data in an Access table. With this Lock Type you can only scroll forward through records. Like a dynamic cursor, except that you can't see records that other users add, although records that other users delete are inaccessible from your recordset. This Lock Type indicates pessimistic locking, record by record. Find Last "pk People ID=2" ' numeric constant - DAO rs.