Convert a mdb Database (accdb) to a previous version database (mdb

[Guest]

I Have a big proglem.
I install the New Microsoft Office 2007, very good design.
But something I don't see...
How do I convert a database accdb to the format that can be recognize by the
ADO in Visual Basic 6, before I use the Convertion to 97 format.
But now what do I do?
Any suggestion? Any tool necessary?
Thaks.

 

[onedaywhen]

I Have a big proglem.
I install the New Microsoft Office 2007, very good design.
But something I don't see...
How do I convert a database accdb to the format that can be recognize by theADOin Visual Basic 6, before I use the Convertion to 97 format.
But now what do I do?
Any suggestion? Any tool necessary?
Thaks.

You can use ADO in Visual Basic 6 with the accdb format, no need to
convert it. Just use the appropriate OLE DB provider, being
Microsoft.ACE.OLEDB.12.0. You can download the provider (part of 2007
Office System Driver: Data Connectivity Components) here:

http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en

Jamie.

--

 

[Guest]

Still Doesn't work
Display this error message everytime that I try to make the connection with
an DataEnvironment:
-2147217843: It is not possible to initiate the application. It lacks the
filing-cabinet of information of the work group or is opened in the exclusive
way for another user.
Need sugestion...
Thanks

 

[Guest]

You can use ADO in Visual Basic 6 with the accdb format, no need to
convert it. Just use the appropriate OLE DB provider, being
Microsoft.ACE.OLEDB.12.0. You can download the provider (part of 2007
Office System Driver: Data Connectivity Components) here:

http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en

Jamie.

--

Thanks to answer to me.
But it still doesn't work because display the same error mesage that was
displayed before when I try to make the connection with the 'Microsof Jet OLE
DB Provider' to a Access 2000 database...
-2147217843: It is not possible to initiate the application. It lacks the
filing-cabinet of information of the work group or is opened in the exclusive
way for another user.
Help needed...
Thanks.

 

[onedaywhen]

Still Doesn't work
Display this error message everytime that I try to make the connection with
an DataEnvironment:
-2147217843: It is not possible to initiate the application. It lacks the
filing-cabinet of information of the work group or is opened in the exclusive
way for another user.
Need sugestion...
Thanks

FWIW I did a quick test connecting to a .accdb file using the OLE DB
provider in a DataEnvironment designer in VB6 and it worked fine.
Sounds like there is a more general problem accessing the file e.g.
opened exclusively. Suggestion: if you've got it open in Access then
try closing it ;-)

Jamie.

--

 

[Guest]

FWIW I did a quick test connecting to a .accdb file using the OLE DB
provider in a DataEnvironment designer in VB6 and it worked fine.
Sounds like there is a more general problem accessing the file e.g.
opened exclusively. Suggestion: if you've got it open in Access then
try closing it ;-)

Jamie.

--

Still doesn't work
I make the ADO connection 'Microsoft.ACE.OLEDB.12.0' and set the Database as
source and it still making the same error!!!
No I don't have ANY database open...
I Don't know why this is happening...
Please answer myhelp
Thanks.

 

[Guest]

FWIW I did a quick test connecting to a .accdb file using the OLE DB
provider in a DataEnvironment designer in VB6 and it worked fine.
Sounds like there is a more general problem accessing the file e.g.
opened exclusively. Suggestion: if you've got it open in Access then
try closing it ;-)

Jamie.

--

Hi again
You say that you make a quick connection and it work fine?
Why don't you send it to me???
(e-mail address removed)
I'll be waiting...
Thanks

 

[onedaywhen]

Still doesn't work
I make the ADO connection 'Microsoft.ACE.OLEDB.12.0' and set the Database as
source and it still making the same error!!!

Forgetting the DataEnvironment designer for the moment, can you
establish an ADO connection to the data source?

Jamie.

--

 

[Guest]

Forgetting the DataEnvironment designer for the moment, can you
establish an ADO connection to the data source?

Jamie.

--

No, I can't
Here is my module:

Dim adTable As New ADODB.Recordset
Dim adConect As New ADODB.Connection

Dim strConection As String

Global vbGlobalPassword As String

Public Function Begin() As Boolean

On Error GoTo Err_

strConection = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Password=yg2593abl96;" & _
"Data Source=" & App.Path & "\MyDesktop.accdb;" & _
"Persist Security Info=True"

adConect.Open strLigacaoBD
Begin = True
Exit Function

Err_:

frmIniciar.txtLogin = "Error Number: " & Err.Number & ", " & _
"Error Title: " & Err.Description & "."

If Not adConect Is Nothing Then
If adConect.State = adStateOpen Then adConect.Close
End If

Set adConect = Nothing
Begin = False

End Function

Shows this error:

Error Number: -2147467259, Error Title: [Microsoft] [Manager of ODBC
controllers] the name of the origin of data was not found and no predefined
controller was not specified.
(The error was shown in portuguese, I just translate it in the Google to
english

I hope you help me...
Thaks

 

[onedaywhen]

Forgetting the DataEnvironment designer for the moment, can you
establish an ADO connection to the data source?

No, I can't
strConection = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Password=yg2593abl96;" & _
"Data Source=" & App.Path & "\MyDesktop.accdb;" & _
"Persist Security Info=True"

Error Number: -2147467259, Error Title: [Microsoft] [Manager of ODBC
controllers] the name of the origin of data was not found and no predefined
controller was not specified.
(The error was shown in portuguese, I just translate it in the Google to
english

Have your tried using the Data Links wizard thing to generate the
connection string? e.g. in code:

Public Function GetOleDbConnectionString() As String
Dim oDLink
Set oDLink = CreateObject("DataLinks")
' only way to prevent 'object not
' set' error if cancel pressed?
On Error Resume Next
GetOleDbConnectionString = oDLink.PromptNew
End Function

Jamie.

--

 

[Guest]

Forgetting the DataEnvironment designer for the moment, can you
establish an ADO connection to the data source?

No, I can't
strConection = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Password=yg2593abl96;" & _
"Data Source=" & App.Path & "\MyDesktop.accdb;" & _
"Persist Security Info=True"

Error Number: -2147467259, Error Title: [Microsoft] [Manager of ODBC
controllers] the name of the origin of data was not found and no predefined
controller was not specified.
(The error was shown in portuguese, I just translate it in the Google to
english

Have your tried using the Data Links wizard thing to generate the
connection string? e.g. in code:

Public Function GetOleDbConnectionString() As String
Dim oDLink
Set oDLink = CreateObject("DataLinks")
' only way to prevent 'object not
' set' error if cancel pressed?
On Error Resume Next
GetOleDbConnectionString = oDLink.PromptNew
End Function

Jamie.

--

Hello again...
I don't mean to be boring but...
The code you send me, 'GetOleDbConnectionString()', yes is very useful, but
it returns the same error that was return before...
What I made was:
Dim adConect as ADODB.Conection
'Code...
And intead of the "Provider=Microsoft.ACE...", I put
GetOleDbConnectionString, like this
On Error Goto Err_
adConect = GetOleDbConnectionString
Exit Sub
Err_:
Msgbox "Numer: " & Err.Number & ", " & _
"Description: " & Err.Description
....
The Msgbox always returns:
Number: -2147217843, Description: It is not possible to initiate the
application. It lacks the filing-cabinet of information of the work group or
is opened in the exclusive way for another user.
(Message translated by the Google Translation Tool)
Help Please...
Thanks

 

[Guest]

A quick google search using the error *number* suggests it is a
problem of authentication e.g. the username/password is wrong. You are
aware the security model has changed for the Access 2007 engine...?

Jamie.

--

The problem now is another because the provider Microsoft.ACE.OLEDB.12.0
doesn't acept password on Databases...
Or the user is no more "Admin"???
Can I have with this provider a password security?
Please answer my Help
Thanks

 

[Guest]

The problem now is another because the provider Microsoft.ACE.OLEDB.12.0
doesn't acept password on Databases...
Or the user is no more "Admin"???
Can I have with this provider a password security?
Please answer my Help
Thanks