Can´t open access DB from listbox

[silentwolf]

Hi guys,

I got following code to open a database within a form.

Unfortunatelly I am not able to open the file.

The reference is ok as I am using the same code to reference tables within the selected database..

Private Sub lstDateien_DblClick(Cancel As Integer)
    Dim dbsExtern As Database
    
    Set dbsExtern = OpenDatabase(CodeProject.Path & "\" & m_strDatei, , True)
    
[COLOR=#ff0000]'Methode or dataobject not found[/COLOR]
    [COLOR=#ff0000]dbsExtern.Visible = True[/COLOR]

   
End Sub

Thanks for looking!

 

[Norie]

Albert

I don't think OpenDatabase works in the way you think/want it to.

It opens the database and adds it to the Databases collection of the workspace.

You can then work with the objects, eg tables, queries etc, in the database.

It doesn't open the database as though you had double clicked on it or opened via the File menu in Access.

PS The Database object doesn't have a Visible property.

 

[silentwolf]

Hi Norie,
yes I saw that it had not a visible property.. hmm but thought there is a way of open a database from within a form..

So there is no way of doing this?

The thing is that I already created a userform listbox which list me all the databases within a certain Directory.. so would be nice if that can be opend straigt from there..

 

[Norie]

Albert

Do you want to open the selected database to allow the user to interact with it?

Where is your listbox located?

 

[silentwolf]

Norie,
I got the listbox in a access form.
I like to vie tables and queries in other listboxes in that form most of it works already... however I like to be able to open it from that form if I need to make some
changes to that selected database...
Some of them are password protected some not so the only interaction would be to be able to enter the password.

 

[Norie]

But you want to open the actual database to work with it rather than just access its data?

 

[silentwolf]

what I supose to be doing with all these data is find three tables in each of those databases and then store it somewhere to check wheter I got dublikate data somewhere.
Problem... not all table are called the same.
For instants I got customers, objects and employees...and linked table objectEmployee so basically who has worked on what object at what date and time

Now I need to find all databases which are containing any information about that.
Save it somewhere and then find any dublikate data..

Problem is that not all databases have the exact field names to make it difficult to have a one sub or functions to import all of the data.. So therefore I might need to change the field names or create qry to get me the data..
still not quite sure what the best way of doing it