This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EAD6.717E62F6
Content-Type: text/plain;
	charset="iso-8859-1"

Hi there,

Thanks for your help with version checking. The option I went for was a
batch file that downloaded the system from startup.

This has lead me on to my next question...
how can I tell if a query or other object has been modified?

i.e. when closing a database, I need to know if say a user has made design
changes, or created new queries, forms, reports, macro's etc.
And if so, export these to another database.

Is this possible?

Thanks

Sam Rose

Query the MsysObjects table (hidden) for the object in question (Type and 
Name field) and look at the "DateUpdate" field.

R
 
Hi there,

Thanks for your help with version checking. The option I went for was a
batch file that downloaded the system from startup.

This has lead me on to my next question...
how can I tell if a query or other object has been modified?

i.e. when closing a database, I need to know if say a user has made design
changes, or created new queries, forms, reports, macro's etc.
And if so, export these to another database.

Is this possible?

Thanks

Sam Rose