Access Tables

[koumides@gmail.com]

I have just received a file from a friend (.mdb) file. It is composed
of many forms and one module. Every form has the design part and the
code part. As I saw there is some SQL code... The problem is I can't
see the tables...where are they located?? I am used to MS SQL
Server...and never used Access before.
Can anybody help?

Thnaks a lot,
Marios Koumides

[pietlinden@hotmail.com]

Re: Access Tables

so you click on the tables tab and there are no tables? And if you go
to Tools, Options, and select Show Hidden Objects, you still have no
tables? What if you create a query? Can you see them then? Ummm...
holding down the shift key and hitting the TABLES tab might do it...

[Todd Matson]

Re: Access Tables

Marios,

I can only speculate, but here are a few ideas:

1) The tables may be hidden. To see hidden tables, go to Tools / Options /
Hidden Objects.

2) It is common to split an Access application into two parts: the
"front-end" contains the forms and code; the "back-end" contains the tables.
Usually, the "Tables" tab in front-end would show a list of links to tables
in the back-end. It is also possible, however, for the code to create and
remove these links on the fly. In other words, it is possible that your
database contains no tables, but will try to connect to them as needed.

3) Your friend may have made a mistake.


-Todd Matson


<koumides@gmail .com> wrote in message
news:1110321982 .471835.121660@ g14g2000cwa.goo glegroups.com.. .[color=blue]
> I have just received a file from a friend (.mdb) file. It is composed
> of many forms and one module. Every form has the design part and the
> code part. As I saw there is some SQL code... The problem is I can't
> see the tables...where are they located?? I am used to MS SQL
> Server...and never used Access before.
> Can anybody help?
>
> Thnaks a lot,
> Marios Koumides[/color]

[koumides@gmail.com]

Re: Access Tables

When I always open an .mdb file I can a pop up containing, Tbales,
Queries, Forms etc. With the specific one that I have the
question...when I open the file...I just get a form popup. I went in
the code which pops up VB editor, and I can see the code of many forms
there...but no tables anywhere. The database though seems to be working
fine...cause I can see in the form all the values they have entered.
The file also is big (Around 6Mb) so it should contain the tables. If I
have tools/relationships I can see the schema of my tables. But the
actual tables are nowhere :)

thanks again
marios

[Todd Matson]

Re: Access Tables

Marios,

The "pop up" containing Tables, Queries, Forms, etc. is called the "Database
Window". I can't be sure, but it sounds like you are saying you can't see
that window. Try hitting the F11 key. You can also go to Tools / Startup and
check "Display Database Window".


-Todd Matson


<koumides@gmail .com> wrote in message
news:1110358524 .866702.170000@ o13g2000cwo.goo glegroups.com.. .[color=blue]
> When I always open an .mdb file I can a pop up containing, Tbales,
> Queries, Forms etc. With the specific one that I have the
> question...when I open the file...I just get a form popup. I went in
> the code which pops up VB editor, and I can see the code of many forms
> there...but no tables anywhere. The database though seems to be working
> fine...cause I can see in the form all the values they have entered.
> The file also is big (Around 6Mb) so it should contain the tables. If I
> have tools/relationships I can see the schema of my tables. But the
> actual tables are nowhere :)
>
> thanks again
> marios[/color]