Microsoft Access won't open the database tables or forms

[newVBM3]

Hi.

I know the question is kind of vague.



But I was out the week of Christmas, and then I get an email saying Access for users isn't opening any tables, queries, or forms.

[Welshgasman]

Yes, very vague.
Any messages?

[newVBM3]

Yes, very vague.
Any messages?

No error messages. It literally just blank.

[Bulzie]

You sure thats the right database file? In File Explorer what is the size? Do you have a backup? Is that a backend database or the frontend?

[newVBM3]

You sure thats the right database file? In File Explorer what is the size? Do you have a backup? Is that a backend database or the frontend?

Yes, I believe so. This has been the Access file for years now. This happened right before new years.
It is 412kB. Should be much larger.
I do, but the backups are different sizes as well. I just tried opening the backup, it is saying "'Id' is not a index in this table."
Backend db.

[mike60smart]

Hi
Can you upload the Database to see if anyone else can view the tables?

[CJ_London]

So answer the basics

Is your db split?
If it is, is the front end shared?
How many users?
is this happening to every user or just some?
does it happen on other databases, or just this one?

I just tried opening the backup, it is saying "'Id' is not a index in this table."

implies your db is corrupted. So you need to find a valid backup

[Bulzie]

Go into the design of the front end, see if tables there and can you click and open them and do they have data. I assume the backend is an Access db?

[newVBM3]

Hi
Can you upload the Database to see if anyone else can view the tables?

Hi. My apologies, but I cannot.

[newVBM3]

So answer the basics

Is your db split?
If it is, is the front end shared?
How many users?
is this happening to every user or just some?
does it happen on other databases, or just this one?

implies your db is corrupted. So you need to find a valid backup

The DB might be, how do I find out?
30 users.
Every user that uses this Db.
Nope, just this one.

Where else can a valid backup be stored?

[newVBM3]

Go into the design of the front end, see if tables there and can you click and open them and do they have data. I assume the backend is an Access db?

I am be able to load all tables and data on Microsoft SQL Server side of things. This is the root and parent Db. Restricted mainly to the DBA.

This Access Db was created for business users. So they can view data easily.

[mike60smart]

If the FE is not showing any tables try Relinking to the BE

[newVBM3]

Okay, I was able to locate a working back up.
Easy fix on my end.

Thanks all.

[CJ_London]

The DB might be, how do I find out?

you said the BE is sql server, so it is split

Every user that uses this Db.

doesn't answer the question. Does every user have a copy of the FE (the Access bit) on their own machine? Or is it located in a shared location and every user uses it?

From what you have said, it sounds like the latter. If they are using a shared copy, you will suffer from corruption and this will happen again. Fortunately you have a separate BE which provides some protection for your data.

The setup should be every user has a copy of the FE (the Access bit) on their own machine. And the connection to sql server should be over wire, not wifi.

Where else can a valid backup be stored?

That is up to you. The working copy you found - make sure you put a copy somewhere safe where it a) cannot be interfered with and b) cannot be deleted. It may be if this is a backup, the seeds of corruption have already have been sown, it's just not apparent yet. So I would create a new access file and import all the objects. Then compact repair

[newVBM3]

you said the BE is sql server, so it is split

Got it, thanks.

doesn't answer the question. Does every user have a copy of the FE (the Access bit) on their own machine? Or is it located in a shared location and every user uses it?

It is in a shared location. What is happening is that we are creating a shortcut to their desktop to the Access bit.

The setup should be every user has a copy of the FE (the Access bit) on their own machine. And the connection to sql server should be over wire, not wifi.

Silly question, how do I go about setting this up?
And they are wired.

That is up to you. The working copy you found - make sure you put a copy somewhere safe where it a) cannot be interfered with and b) cannot be deleted. It may be if this is a backup, the seeds of corruption have already have been sown, it's just not apparent yet. So I would create a new access file and import all the objects. Then compact repair

I will make backups of the working backup. I will clean up all the network paths for this Access bit.

I will create a new access file, import all objects, and then compact repair.


Thanks for the feedback. Appreciate it.