Tables Issues (2 Viewers)

[wejdan1994]

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 ?

 

[theDBguy]

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]

You can set Navigation Pane to not display system tables.

 

[wejdan1994]

@theDBguy appreciated

 

[wejdan1994]

@June7 thank U

 

[theDBguy]

@theDBguy appreciated

Hi. You're welcome. Hope it helped. Cheers!

 

[MajP]

If you want to understand these see below

Purpose of System Tables - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

@isladogs has written the most thorough explanation of these tables you will find anywhere.

 

[isladogs]

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

 

[wejdan1994]

@MajP many thanks , @isladogs yes i did thank U