Tables Issues (1 Viewer)

wejdan1994

New member
Local time
Today, 15:00
Joined
Mar 29, 2020
Messages
10
Hi

I have problem with my Ms Access, where there are a number of tables i do not know from where it come from.
even when i open a new file or blank template. it appears to me in faded manner.

when i want to delete it the below message will be displayed.
Any one have solution ?
1585532388113.png
1585532511465.png
 

theDBguy

I’m here to help
Local time
Today, 05:00
Joined
Oct 29, 2018
Messages
10,019
Hi. These are system tables needed by Access to keep track of your database objects, like your table relationships. You can't delete them, and you shouldn't.
 

June7

AWF VIP
Local time
Today, 04:00
Joined
Mar 9, 2014
Messages
2,935
You can set Navigation Pane to not display system tables.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 08:00
Joined
May 21, 2018
Messages
3,112

isladogs

CID Moderator
Staff member
Local time
Today, 13:00
Joined
Jan 14, 2017
Messages
13,139
Thanks @MajP

@wejdan1994
As already stated, you can (and should) hide the system tables unless there is a good reason to work with them.
To do so, click Navigation Options and untick both Show System Objects and Show Hidden Objects,

Most system tables cannot be edited or deleted. Even where you can do so, you shouldn't ... or your database may not work correctly

Having said that, there are many good reasons why developers will make use of these for a variety of purposes
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom