97 - Referencing Linked Data 
Author Message
 97 - Referencing Linked Data

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



Mon, 11 Jun 2001 03:00:00 GMT  
 97 - Referencing Linked Data
On Thu, 24 Dec 1998 11:00:09 -0800, Troy Berardo

Quote:

>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)

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

Then use the FindFirst method rather than the Seek method.



Mon, 11 Jun 2001 03:00:00 GMT  
 97 - Referencing Linked Data
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
Quote:

>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



Mon, 11 Jun 2001 03:00:00 GMT  
 97 - Referencing Linked Data
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

Quote:

>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



Tue, 12 Jun 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Linking Access 97 fornt end to Access 2000 data

2. Data enviroment and linked tables in Access 97.

3. Linking ACCESS 97 to Project 97

4. How to Link the Outlook (97) Journal Folder to Access (97)

5. How to link a password protected Excel 97 Spreadsheet to Access 97

6. Data Link Dialog in VB.NET without COM reference

7. Urgent : Exporting Access 97 data to Excel 97

8. Sending and manipulating data from Access 97 to Excel 97

9. Exporting Access 97 data to Excel 97

10. sending bookmark data from word 97 to access 97 database

11. Insert data from Excel 97 into Word 97

12. References when Converting to 97

 

 
Powered by phpBB® Forum Software