How to view MSAccess2003 default collation order

[Redd_Green_At_Hotmail]

On the TOols/Options/General page, you can set the collation order for the
next compact/repair operation.

Where can you view what the value is set to currently? Is this a per-table
setting?

HELP!!!

 

[Douglas J Steele]

CurrentDb.CollatingOrder will give it to you. It's on a database-basis, not
a per-table basis.

 

[Redd_Green_At_Hotmail]

THanks DOuglas.
Can I ask, where can I find CurrendDB in the MS Access user
interfaces?
Regards,
Redd

 

[Redd_Green_At_Hotmail]

Danny,
Thanks also. Im running MsAccess2003. By "code window" do you mean
VB? or the developer studio? Im trying to find a way, from within MSAccess
GUI.
THanks
Redd

 

[Redd_Green_At_Hotmail]

OK Getting somwhere (never been this far inside Access). I added a
"module", then found CurrentDb.CollatingOrder.

Finally, can you tell me how to run the module?

Thanks!!!
Redd