Can't access database!

[Guest]

Our database is shared on our network...three computers cannot access the
database...the relationships can be seen but the initial window cannot be
seen any suggestions?

 

[Joseph Meehan]

Our database is shared on our network...three computers cannot access
the database...the relationships can be seen but the initial window
cannot be seen any suggestions?

I am not sure what you mean by "internal window" Is this a split
database with one part on the user's machine and the data itself warehoused
on the server in another database? Is Access security being used? Is
anyone opening it up "exclusively?

 

[Guest]

Could be these three computers' memory not efficient.

 

[Guest]

I meant the window where you can click on the tables, forms, etc...sorry I
wasn't specific...the database is split and on one of the computers it does
give a message of one exclusive user but not on the other two machines

 

[Guest]

no...the memory is sufficient on all three..any help would be greatly
appreciated. Thank You

 

[Guest]

Sorry Joseph I forgot to say thank you for any help

 

[dbahooker]

hit F11 and tell me if you see the db window

 

[Joseph Meehan]

I meant the window where you can click on the tables, forms,
etc...sorry I wasn't specific...the database is split and on one of
the computers it does give a message of one exclusive user but not on
the other two machines

In a properly split system, you can see the tables forms etc that exist
on your copy of the database (the front end) but the only parts of the back
end (the database on the "server" computer) you only see the tables that are
linked to yours, but nothing else, you just see the data.

A properly split system keeps on the shared dynamic data (the data that
changes) in one database (called the backend) located on the "server"
computer. The forms, reports queries and often additional tables, are
located in a different database on their own compute (called the front end)
.. This front end is linked to table(s) on the back end.

When people are sharing data it is wise to use this split system as it
avoids all kinds of problems. Is your system something like this?

 

[Van T. Dinh]

It is called "Database Containers window" because each tab represents a
Container and each Container stores a particular type of Objects.

Is your database split and each user has a separate copy of the Front-End?

Are you sure the Database Containers window is hidden or it is in another
part of the Access Application window and the users don't realise this? The
hint in the later case is the scrollbars appearing for the Access
Application window.

It depends on your set-up and I am not sure what you meant by "the
relationship can be seen" but try the following on each problematic
computer.

* If you see the scrollbar on the Access Application windows, use the Menu
Window / Cascade to see if the Database Containers window re-appears.

* Also try the Menu Window / Arrange Icons ... and see if the Icon for the
Database Containers window re-appears.

* Try also the Menu Window / Unhide and see if the Database Containers
window is listed as hidden. You can use the same dialog to unhide it.

* Try also F11 to show the Database Containers window.

* If each user has a separate copy of the Front-End, use the Menu Tools /
Start-up ... to check the settings for the Start-up options. There is an
option to hide the Database Containers window in Start-up options.