VB and table names

From: Chan Hoong Keong <hkchan_at_hkchan.pc.my>
Date: Mon, 30 May 94 06:44:01 GMT
Message-ID: <770280241snx_at_hkchan.pc.my>


I am using VB to generate applications retrieving data from Oracle. The applications will be used by a group of users accessing tables created by another user. In SQL*PLUS, the select statement will look like this :

        SELECT * FROM admin.atable WHERE ...

When the same code was used in VB, VB produced an error saying "admin.mdb" not found. The error indicated VB was expecting "atable" from MS Access database "admin". Is there anyway to use owner prefixed tables in VB?

--
Email : hkchan_at_hkchan.pc.my
Received on Mon May 30 1994 - 08:44:01 CEST

Original text of this message