473,322 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access Tables

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

Nov 13 '05 #1
4 1299
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...

Nov 13 '05 #2
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
<ko******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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

Nov 13 '05 #3
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

Nov 13 '05 #4
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
<ko******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
5
by: Praty77 | last post by:
Hello - we have been using access 97 for a multiple user trading system at a small bank. Typically around 10 users entered a total of hundred trades everyday. Some of the data was shared with a...
1
by: Andrew Arace | last post by:
I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
4
by: Vanessa | last post by:
Hi there I am an Access developer, and I have written applications for a 30 telephone call center, using the standard multiuser jet engine, it all works fine, but I want to move our systems onto...
4
by: RSH | last post by:
Hi, I have a situation where I have created a little application that makes an Access database from a SQL Database for reporting purposes. it does the job well, but it seems a bit slow. Is...
5
by: Kip | last post by:
I have an office with approx 8 people. I have used Access with a Form on my personal PC for client records. I was wondering if I could put the Access table on a server and put shortcuts on each...
2
by: Steve | last post by:
I have zero experience with ODBC. If I have an Access frontend connected to a SQL Database using ODBC, are the tables connected like a frontend/backend Access database where the the tables you see...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.