No Record Sources Not Found?

[Guest_imported]

Hello, I was having some trouble with VB accessing my Microsoft Access Databases. It said something to the effect that the drivers weren't found OR hadn't been installed. So, I reinstalled VB6, and tried again. This time it would let me pick the database to use, but then return the error that there were No Record Sources Found. So I reinstalled Office97 (thinking that might be where the problem lay), but it still says the same thing &quot;No &lt;freaking&gt; Record sources found&quot; <br>
<br>
The strange part is, I can see SOME of the databases, with no problem. Some of them work, some of them don't. Well, most of them don't... I set up a new database and then imported all the tables from one of the databases that didn't work, then I used this table and the thing worked fine!!! What's going on here??! <p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://www.computerwiz.net>HTTP://w...><br>---==============================---<br>

I am currently working on

http://www.computerwiz.net.<br>

It should be LIVE 1/12/00 or before. I would appreciate suggestions, comments and the like. Please go look and help. Thanks.<br>
---========================

 

[DougP]

how are you trying to look at your records?<br>
To connect to an Access database you need two things <br>
1. The Data base name i.e. Nwind.mdb&quot;<br>
2. The Recordsource (which can be a Table or Query or SQL statement) in that database i.e. &quot;Authors&quot;<br>
<br>
try this<br>
Add a Data control<br>
Find your database in the DataName Property first<br>
It will bring up a dialog box to assist you with finding your database on any drive you have access to.<br>
After you have the database name set<br>
Then scroll down the list of properties to find the Recordsource pick the table or query you want to connect to.<br>
<br>
Next add a Text box<br>
In it's properties click <br>
1. DataSource you should see DATA1 pick it.<br>
2. Then click the DataField and find the field you want.<br>
<br>
Note you must do both the data control and the text box in order for it to work<br>
<br>
Now run your project and click on the navigation buttons of the data control<br>
It should scroll through the records<br>

 

[wallywojo]

IF you are using on stations that do not have VB installed, you need to use DCOM.