mde database (access 97/access2002)

[HansV]

I assumed from <post#=401092>post 401092</post#> higher up in this thread that Pat had already ticked the 'Hidden objects' and 'System objects' check boxes (the latter shouldn't be necessary). If no user-level security has been applied, that should make all tables visible, even if their Hidden property had been set to Yes.

[GARYPSWANSON]

Patt,

Any chance the MDE file was created using 97 and you are using either 2000 or 2002 to try to access it. As the code in the MDE is compiled, I think there may be compatibility problems if trying to get to the database using newer versions that may be preventing you to see the tables. If so, try opening the database using 97 to get to the tables. (Can you see any objects at all?)

My hidden file comment was answered by others. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

[HansV]

Try this:
- In a "normal" .mdb database, set a reference to the Microsoft DAO 3.n Object Library. The version is 3.51 - I think - for Access 97, 3.6 for Access 2000 and higher.
- Copy the following code into a standard module:

Sub ListTables()
Const strDatabase = "C:AccessTest.mde"
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef
Set dbs = OpenDatabase(strDatabase)
For Each tdf In dbs.TableDefs
Debug.Print tdf.Name
Next tdf
Set tdf = Nothing
dbs.Close
Set dbs = Nothing
End Sub

- Substitute the correct path and filename for the .mde database.
- Run the code by clicking somewhere in it and pressing F5.
- ALL tables, including the system tables whose name begins with MSYS should be listed in the Immediate window.

What is the result?

[charlotte]

Application.SetOption "Show Hidden Objects", True

[patt]

That's an excellent idea Hans.
Unfortunately the Client has not got back to me so I won't bother you good people again on this topic until they do (get back to me that is).

Thank you all for your generous contributions and time, you are just fabulous.