Could someone please explain how to modify the following line so it will
work when I split the database?

Set rstAppointments = dbsTest.OpenRecordset("Appointments", dbOpenTable)

Thanks,

Troy

On Thu, 24 Dec 1998 11:00:09 -0800, Troy Berardo

Set rstAppointments = dbsTest.OpenRecordset("Appointments",
dbOpenDynaset)

Then use the FindFirst method rather than the Seek method.

Troy,
either use dbOpenRecordset instead of dbOpenTable or open dbsTest as backend
database
---
Best regards,
___________
Alex Dybenko
Point Limited
Home Page: http://www.geocities.com/SiliconValley/Heights/5091/
Moscow MS Access User Group
http://www.arimsoft.ru/msaccess

To open a table-type recordset, you need to open your database
variable against the database where the linked table resides. You can
get the path to that database from the connect property of the linked
table in the front-end database where your code is running. Something
like this:

dim tdf as tabledef
dim dbsTest as database
dim rstAppointments as recordset
dim strPath as string

set dbsTest =currentdb
set tdf=dbsTest.tabledefs("Appointments")
strPath=mid(tdf.connect, 11)
set dbsTest =opendatabase(strPath)
set rstAppointments = dbsTest.OpenRecordset("Appointments", _
 dbOpenTable)

 -- Andy