editing exsisting access database

B

benny wa

I have recently inheirited a 2007 Access Database. I am currently trying to
find the forms and queries part of this database to make changes to it; such
as adding the ability to search by last name option instead of looking thru
an entire list of names.
Currently to look at the database I can either just dbl click the access
db and get the first form or I can hold down the shift key and get a
database tools , external data menus.
How do I get to where the forms and queries are located?
Thank you
 
J

Jeff Boyce

Forms, queries (reports, macros, ...) and tables are objects located in the
database window in Access...UNLESS they have been hidden and the option to
show hidden objects is turned off.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

benny wa

How do I unhide hidden objects?

Jeff Boyce said:
Forms, queries (reports, macros, ...) and tables are objects located in the
database window in Access...UNLESS they have been hidden and the option to
show hidden objects is turned off.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
J

Jeff Boyce

Go to the database window. Click on Tools | Options.

On the View tab, make sure the Hidden Objects checkbox is unchecked. This
is a more permanent setting.

Or you could click Windows | Unhide... in the database window.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

benny wa

Jeff:
Forgive the ignorant questions, I do have a good understanding of
Access, its just this db isnt as stragiht forward as I thought, so with that
prefaced:
When I open the access db up if I dont hold dwnthe shift key I just get
the main intro screen.
When I go into it with shift key held down I get a line menuthat has:
Home, Create, External Data, Database Tools & Acrobat
In the Database Tools Box when selected are:
Macro, Show/Hide, Analyze, Move Data, Database Tools
In the Show HIde tab the only option is the relationship button. I hit
that and that is where I see all of the tables except for the 2 that I hid
and am unable to unhide.
I hope this fully communicates what I did wrong and what it is that I need
to do to fix it.
 
J

Jeff Boyce

Use the Shift/Start method. Look on the left side, ?see the Navigation
Pane? Is there a ">>" symbol at the top? Click it to expand the Navigation
Pane.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

benny wa

There is nothing in the navigation pane

Jeff Boyce said:
Use the Shift/Start method. Look on the left side, ?see the Navigation
Pane? Is there a ">>" symbol at the top? Click it to expand the Navigation
Pane.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
J

Jeff Boyce

Is there a chance you have an .accde file -- this would be an "executable"
which you would NOT be able to make any changes to...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Douglas J. Steele

The accdb that was used to create the accde.

If you don't have that, I'm afraid you're out of luck.
 
B

benny wa

In the .accde point to where the accdb is located?
When I enter data in the .accde it should store in the .accdb right?
 
D

Douglas J. Steele

No.

You create an accdb.

You convert that accdb to an accde.

There's no linkage between the accde and the original accdb.
 
J

John W. Vinson

In the .accde point to where the accdb is located?
Click to expand...

No, although typically there would be a different file on the computer with
the same name, just an .accdb extension. However, that choice is up to the
developer; they might have renamed it, stored it someplace else, kept it for
themselves, or (foolishly) deleted it altogether.
When I enter data in the .accde it should store in the .accdb right?
Click to expand...

No. The data is stored in the .accde, unless the developer made it a split
application with a "frontend" for the forms, reports, etc. and a "backend" for
the tables.

John W. Vinson [MVP]
 
B

benny wa

OK, When I open the access db it is a .accde
If I open with the shift key held I can then see tables, but no data, no
forms no nothing.
I've done searches on my server for .accdb , but iut returned nothing.
So am I screwd
 
B

benny wa

Doug:
If the accdb is converted to the sccde, then where can I find the data
that is loaded in the tables?
 
D

Douglas J. Steele

Linked tables have a Connect property that will tell you where the target
table is.

If they're not linked, then the data will be in the same file.
 
B

benny wa

Found all the tables, quieries, forms and stuff
Now I have to make a tfield in a table more searchable
I havea Last name field that s part of search.
the whole search criteia involves the enitire table. so when you select the
search button all the fields are viewable to scroll through.
I want to be able to type part of the last name and have my options then
presenteed to me.
Do I need to mak a new query with just the last name in it or can I modify
the existing table properties for that column?
 
J

John W. Vinson

OK, When I open the access db it is a .accde
If I open with the shift key held I can then see tables, but no data, no
forms no nothing.
I've done searches on my server for .accdb , but iut returned nothing.
So am I screwd
Click to expand...

Where did the database come from? Did you create it yourself, or did someone
give it to you? If the latter, can you contact that person?

John W. Vinson [MVP]
 
L

Larry Linson

Jeff Boyce said:
Forms, queries (reports, macros, ...) and tables are objects located in
the database window in Access...UNLESS they have been hidden and the
option to show hidden objects is turned off.
Click to expand...

Jeff... the Original Poster said Access 2007, which I don't think HAS a
traditional database window. That might be his problem... isn't this in a
somethingorother pane?

Larry
 
Top