If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Backend Database
I have put my data tables into another access database which resides on a
server. After splitting the database. When I use seek, it tells me that it is an invalid function. I have linked the tables in the backend database to the current database. my code is as follows : Dim dbs1 As dao.Database Dim rst1 As Recordset Set dbs1 = CurrentDb Set rst1 = dbs1.OpenRecordset("Customer Forecast") rst1.Index = "Key" rst1.Seek "=", estkey before splitting the database, it worked fine. Why would this stop working. The table in the backend database is indexed on "Key" Thank you, Gerry |
Thread Tools | |
Display Modes | |
|
|