FREE MODULE: How to open a Database in VB (Access, DBF)

[Franky]

Hi,

so many people ask how to open Databases in VB. Here is a example how you can do it. It works 100% and can open Access.MDB and DBF-Files.

Use this and you will never have questions/problems anymore how to open DBs.

Franky

[Ambivalentiowa]

Originally posted by Franky
Deserve this attachment to be on page 1?

eh?

[trin]

this code for databases is exactly what i was looking for. I understand all of it except the stuff below.

rsLigue.CursorType = adOpenStatic
rsLigue.CursorLocation = adUseClient
rsLigue.LockType = adLockPessimistic
rsLigue.Source = "Select * From [Ligue]"
rsLigue.ActiveConnection = DB
rsLigue.Open

Also, this is the sql i have coded during design time. Do i need to modify at all. Im just wondering because you use square brackets in your sql statement.

SELECT  exam_order,objectives,subject FROM Phase1b where exam_order > 0 AND objectives <> " " order by exam_order asc

thanx trin

[Franky]

it is the first time that I get a reply that I do something right. I used only the brackets to show the table better, but you don't need the brackets.
Your SQL-statement looks fine to me.

The code for the recordset rsLigue (french word for league) is to open in the already opened connection the recordset. You can open the recordsets that are in your MDB. Why I used the parameters there is a little homework for you. Check the MSDN , there you find why I did this.

Franky

[eanatum]

Question...

Can I put a table name in the Recordset.Source instead of an SQL statement?

[Franky]

I checked the MSDN and there it tells yes.

Source Property (Recordset) ADO
Indicates the source for the data in a Recordset object (Command object, SQL statement, table name, or stored procedure).

Applies To

Recordset

Settings and Return Values

Sets a String value or Command object reference; returns only a String value.

Remarks

Use the Source property to specify a data source for a Recordset object using one of the following: a Command object variable, an SQL statement, a stored procedure, or a table name . The Source property is read/write for closed Recordset objects and read-only for open Recordset objects.

If you set the Source property to a Command object, the ActiveConnection property of the Recordset object will inherit the value of the ActiveConnection property for the specified Command object. However, reading the Source property does not return a Command object; instead, it returns the CommandText property of the Command object to which you set the Source property.

If the Source property is an SQL statement, a stored procedure, or a table name, you can optimize performance by passing the appropriate Options argument with the Open method call.



Franky

[Ecniv]

You realise that you could put a link to this thread in your sign bit (see UserCP>Profile) and when you answer any post its there for people to jump to.


Vince

[Franky]

slower slower ..... again, what can I do? And how get I a picture like the others have it in my profile?

Franky

[Ecniv]

Click UserCP>Edit Options>Change Avatar (bottom)

Vince

[Franky]

I don't mean the little button pic. I mean the big pics that some users have on every post on the bottom of their post.

Franky

[Franky]

..

[MartinLiss]

Franky: Please limit your posts to useful questions and answers.

[Franky]

I had problems with ADO 2.7 (Microsoft Active X Data Objects 2.7)
After I used 2.6 the problems was gone.

Keep this in mind when you install MDAC

Franky

[Franky]

Hi,

If anybody have WORKING connectionstrings for Paradox, XBase and other type of Databases it would be maybe a good idea to attach them to this thread.

nice greetings
Franky