473,467 Members | 2,028 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Reading access in VB

1 New Member
I am a newbie... I need help with this seemingly simple problem.
I have an access database that I'm trying to read into my VB app. That's the easy part. My problem is the table it reads returns a number. I now need it to read a name based on that number from a different table within the same data base.

I thought I was on the right track, but get this error "The schema you trying to query is different to the base query"

I'm sure it is a simple fix, but I'm stuck and very frustrated. Any help appreciated....

Thanks in advance.
Marc
Oct 11 '07 #1
2 920
debasisdas
8,127 Recognized Expert Expert
You need to qualify the table name by the schema name and must have select previliges on that table.
Nov 5 '07 #2
mokete
3 New Member
I am a newbie... I need help with this seemingly simple problem.
I have an access database that I'm trying to read into my VB app. That's the easy part. My problem is the table it reads returns a number. I now need it to read a name based on that number from a different table within the same data base.

I thought I was on the right track, but get this error "The schema you trying to query is different to the base query"

I'm sure it is a simple fix, but I'm stuck and very frustrated. Any help appreciated....

Thanks in advance.
Marc




Why do u try subquery
Nov 8 '07 #3

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

Similar topics

24
by: Hendrik Schober | last post by:
Hi, I have a 'std::istream' and need to read its whole contents into a string. How can I do this? TIA; Schobi
1
by: Magnus | last post by:
allrite folks, got some questions here... 1) LAY-OUT OF REPORTS How is it possible to fundamentaly change the lay-out/form of a report in access? I dont really know it that "difficult", but...
3
by: [Yosi] | last post by:
I have some unreasonable issue while reading access component from other thread. I have a Form class which includes TreeView, this tree view includes some TreeNodes , lets say 2 . In my Form...
4
by: dale zhang | last post by:
Hi, I am trying to save and read an image from MS Access DB based on the following article: http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp Right now, I saved images without any...
14
by: Zahid | last post by:
Hi, What is a VDT file? How do I read a VDT file into my application? I know how to read text files etc but not VDT files. Im preparing in advance a prototype that read VDT files and does...
1
by: Jens | last post by:
Hello, i am just trying to get familiar with the Reflection-Api. I want to access a protected property of my class using the getValue-method of ReflectionProperty-Class. When i execute the code...
2
by: Paul M | last post by:
Hello, is there any way of reading Microsoft Access Macros via VBA code? Or better still through VB .net code? By reading I mean being able to read what the actions are plus any parameters &...
3
by: Budd | last post by:
Hi all, This is my first time here so treat me gently.....I have dabbled with Access now for a number of years and find I can create what I require...the thing I have always struggled with though...
3
by: darren via AccessMonster.com | last post by:
Hi I'm based in the UK and I've drifted into Access from building a simple db for myself, to then being asked to build a simple db for someone else, to now spending time building increasingly...
19
by: Hapa | last post by:
Does only reading (never writing) of a variable need thread synchronisation? Thanks for help? PS. Anybody knows a Visual C++ news group?
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...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.