473,396 Members | 1,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

how do i open a linked table?

If a table is imported into the database, we write:
Dim rst_p, rst_r As DAO.Recordset
Set db = CurrentDb
Set rst_p = db.OpenRecordset("Pol", dbOpenTable)
Set rst_r = db.OpenRecordset("Rid", dbOpenTable)
But if the tables are linked instead, what code should i write to open it?

Thank you very much!
Dec 4 '08 #1
2 1317
ChipR
1,287 Expert 1GB
The code doesn't change at all.
Dec 4 '08 #2
MikeTheBike
639 Expert 512MB
@kwokv616
Hi

I find that if you omit the dbOpenTable 'Type' argument then it works OK, In fact only 3 of the 5 'Type' arguments seem to work with a link table name.

I cannot comment further as I only use ADO recordset (at least for the last 8 years!).


MTB
Dec 4 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
20
by: Neil | last post by:
I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about...
3
by: Michael Plant | last post by:
Hello one and all. I have a stored table in my database and the form I'm using is based on a query that draws data from my stored table and a linked table. The linked table is a *.txt file. ...
1
by: Hannu | last post by:
Hi. I have in my database linked tables from other access database and i have local tables. My form is linked into local table, but when i open it, it seems to check every table in my database...
3
by: MeganF via AccessMonster.com | last post by:
Hi. I've been working on a database for a while now between my desktop and my laptop. Each time I copy the files, I go into the Linked Table Manager and update my path to my linked databases....
2
by: Javier Gomez | last post by:
How to open a linked table in exclusive mode from a FORM in DAO ??? (but,...... please I need it in DAO.) Thank you ! Javier Gomez
7
by: Bruce Lawrence | last post by:
I have a table on a SQL server called history. When I link this table using an ODBC connection, i give it the username and password and tell it to save the password and it works great. On my PC. ...
0
by: Salad | last post by:
A97. Split database. Frontend DB1.MDB. Backend DB1BE.MDB. Tables are linked between DB1 and DB2. From my testing, if I open DB1 exclusively using /excl the backend DB1BE is not opened...
2
by: kevcar40 | last post by:
Hi is it posible to check if another database is open? i have several datasbase the first is a dbase where the local data is maintained on closing the database the table is exported to a holding...
0
by: Moor | last post by:
I'm unable to to open a linked table T that is stored in an Access 2.0 MDB database file (shared/back-end,) using both Access 2.0 and Access 2003, in the same time. Here is the scenario: 1-...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.