-
Wola de nuevo, gente!!
:nono: No consigo vincular o abrir mi base de datos de access, con el VB
Me parece haber leido que se puede. Me interesa saberlo porque como ya os dije, tengo bastante curro hecho en access.
Alquien me puede ayudar?? Pleeeeeeeeease??:rolleyes:
-
la forma mas facil es atraves del objeto data, le pones en la propiedad databasename la ruta al mdb y ya puedes empezar
aunq la forma buena de hacerlo es atraves del adodb, tienes q añadir la referencia a la libreria en el proyecto.pd. yo hablo de vb 6, de .net no tengo idea
-
Dim rst As ADODB.Recordset
Dim strconnect As String
Dim sql As Stringstrconnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\var_BASE_DATOS\MAESTRA.mdb"Set rst = New ADODB.Recordset
sql = "SELECT tabla etc etc ;"
rst.Open Source:=sql, ActiveConnection:=strconnectespero que te sirva
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Registrarse Conectarse