[Mind_Killer]

I´m having a problam with my program!
I want to save and viu information in a data base alredy criated in acsses 2003!
how do I do that?
Please poust me:

Mind_Killer66@hotmail.com

[Amadeus]

Are you having problems accessing the database? Or working with the records contained therein?

[Mind_Killer]

Amadeus, on 14 Nov, 2005 - 10:05 AM, said:

Are you having problems accessing the database? Or working with the records contained therein?

Both, I basacly don´t no the code!!!!

[Amadeus]

Is the database going to be on the same machine as the application, or is it going to be a remote database? If local, you can simply connect with an ADODB Connection object:

Dim dbConn As New ADODB.Connection
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DatabasePath 'set the database connection string
dbConn.Open connString 'open a connection to the database

From there, it really depends on what you'll be doing...if you're simply inserting, deleting, things of that nature, you can get away with a command object:

Dim cmd As New ADODB.Command 'object used to specify SQL command paramters, such as type (INSERT), and execution
Set cmd.ActiveConnection = dbConn 'activate the connection

You can then use the command object to execute statements.

If you're going to be looping through returned data, querying for specific items, then I'd suggest using an instance of the RecordSet object.

[Xenon]

i'd like you to check this out

and this too ADODB data access


hope this helps !

cheers

Xenon

[born2c0de]

Use the Intrinsic Data Control.
That way the coding is reduced much more.