Solved Access not displaying properly

[LarryE]

I wonder if we have a terminology or symantics issue here. May I ask when you imported the table into the new DB and then opened it, you said the "DB window does NOT display".

When you open the new DB does the imported table show in the Navigation Pane to the left? Because at that point, the DB window IS being displayed but no form is opened yet. Are you confusing the DB window with a form being opened and displayed?

 

[AccessShell]

I would be happy to do what you suggest. But, tell me why when I open one of my DBs from a shared drive, it opens correctly from the other computer, but not from mine. The file is not being opened at the same time.

 

[AccessShell]

LarryE. No. It does not show a DB window. It shows, a window with a list of tables from the DB where I am taking a table form. It does not look the DB window. Here is a picture of that

 

[isladogs]

@LarryE

I wonder if we have a terminology or symantics issue here.

A2003 has a database window ...not the navigation pane which was introduced in A2007

 

[Pat Hartman]

DO NOT SHARE YOUR DATABASE USING A CLOUD DRIVE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Are you sure the other user has the same version of Access that you have? If they have 2007 or newer, they don't have the database window. They have the Navigation Pane.

 

[AccessShell]

I never use the cloud.
I am the only one that installs programs on both computers. I never used, or sae A2007.

 

[Pat Hartman]

Well, then I guess we are left with you uploading the db so we can look at it.

 

[AccessShell]

Here you go

 

[Pat Hartman]

Someone with A2003 will need to open the database to let us know what he sees.

 

[mike60smart]

Here you go

Was able to open using Access for 365.

Saved in 2000 Format attached

 

[LarryE]

@LarryE

A2003 has a database window ...not the navigation pane which was introduced in A2007

The OP stated they were using Windows 10. Would the Windows version make a difference? I don't know.

 

[mike60smart]

I know that someone with 2003 version needs to open the Db but I opened with Access365 to look for anything unusual.

 

[AccessShell]

I already said that on another WIN10 computer I was able to open the DB properly. i.e. the DB window opened.

 

[isladogs]

As expected, no problems here in A2003

Access 2003 is not officially supported in Windows 10 but it runs without any serious issues.
See Microsoft Access Version Features and Differences Comparison Matrix (fmsinc.com)

 

[Gasman]

Someone with A2003 will need to open the database to let us know what he sees.

I was going to suggest another person opening the db on the other site, but the O/P has already done that with the other user in their organisation.
So it looks like it is down to their computer.?

 

[Gasman]

Have you tried out the code in post #15?

 

[AccessShell]

I tried it, but I was not sure where to put it. Also, I never put code like this in any other DB I wrote.

 

[AccessShell]

This is what the DB window should look like. You are missing 3 lines before the table name

 

[Gasman]

I tried it, but I was not sure where to put it. Also, I never put code like this in any other DB I wrote.

Just run it from the immediate window.
It just changes a setting one time only.

 

[AccessShell]

I cannot get to an immediate window unless there is a DB Window showing!