System Object - Table

S

SAC

I'd like to add a field to a systemObject - a table. Is there a way to do
this?

Thanks.
 
6

'69 Camaro

Hi.
I'd like to add a field to a systemObject - a table. Is there a way to do
this?
Click to expand...

Don't alter the structure of, or the records in, the system tables in the
database, since it may corrupt your database. Jet may not be able to open
or use the database afterwards.

If you need to view additional information about a specific item, then
create a user-defined table to store this information along with the primary
key of the object in the system table. Then create a query with an inner
join on the primary key field in the system table to view the system
information side-by-side with the information you've stored in your
user-defined table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
S

SAC

I would like to see what happens. Right now I'm not able to view it's
structure. Can you tell me how to. I'll be responsible for any
consequences.

Thanks.
 
6

'69 Camaro

Hi.
I would like to see what happens. Right now I'm not able to view it's
structure. Can you tell me how to.
Click to expand...

Open a database in Microsoft Access. Select the Tools menu -> Options... to
open the Options dialog window. Select the "View" tab. Mark the "System
Objects" check box, then select the "OK" button to save your change. Select
the "Tables" tab in the Database Window. The table names that start with
MSys are the system tables. These are the ones that shouldn't be altered.
I'll be responsible for any
consequences.
Click to expand...

Of course.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top