editing exsisting access database

[Guest]

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

 

[UpRider]

What happens if you push F11 in either view?

UpRider

 

[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

 

[Guest]

How do I unhide hidden objects?

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

 

[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

 

[Guest]

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.

 

[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

 

[Guest]

There is nothing in the navigation pane

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

 

[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

 

[Guest]

Jeff:
Yes it is a .accde file.
So what should I be looking for???

 

[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.

 

[Guest]

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

 

[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.

 

[John W. Vinson]

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

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?

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]

 

[Guest]

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

 

[Guest]

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

 

[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.

 

[Guest]

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?

 

[David W. Fenton]

You create an accdb.

You convert that accdb to an accde.

Actually, you create a *new* database in accde format, leaving the
original accdb in place.

 

[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

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]