MSysObjects Name field

[David C]

I was looking at the data in an offline copy of a replica we have been
having problems with and looked in the table MSysObjects. Some of the
records had something like below in the Name field of several records:

~sq_cfdlgCompanies~sq_cCompanyTypeID

What is this and is it normal?

 

[Andi Mayer]

I was looking at the data in an offline copy of a replica we have been
having problems with and looked in the table MSysObjects. Some of the
records had something like below in the Name field of several records:

~sq_cfdlgCompanies~sq_cCompanyTypeID

What is this and is it normal?

all objects with a starting ~ are temporary things and this is normal

 

[Douglas J. Steele]

I have to disagree with Andi on this one. It's not temporary, and it's not
going to go away, although it is normal.

Anytime you use the wizard to build a control, it actually creates a query
to use as the recordsource. I suspect you have a form named fdlgCompanies
that has a control CompanyTypeID on it, and this query is associated with
that control.

 

[david epsom dot com dot au]

In A97, objects (queries) with names like that were deleted when you
compacted the database: in A2K they are not. (Correct me if I'm wrong! -
minimal testing)

More generally, in A97 items marked as temporary (using the DAO 'hidden'
flag) were deleted when you compacted the database: in A2K they are not.
Again, please correct me if I'm wrong! (according to reports in the
VB groups).

(david)