Access S.I.G.

by Craig Evans

Greetings experienced programmers .... newcomers .... those in between ....
at our last meeting we demonstrated :

Paramaterised query which easily converts to a recordset regardless of complexity

Do While Not rst.EOF is better than Do Until rst.EOF

A slow networked database is worth code optimisation

Compact on close creates file copies if other users have crashed & the ldb 
file is still open

chr(34) is ascii for " (double quote) - very useful in code

Designing string fields in tables to Allow Zero Length Strings then trap for 
errors in code using the NZ (null zero) function

Change macros to code using Tools - Macro Converter

Document your code

Table msysObject - LinkType 6 = Table.  The path to the table is to the left. 
Useful for determining linked database locations

Most of the above was demonstrated on a fully active database.

For more solutions & amazing discoveries drop in to the Access S.I.G., 
second Monday of the month except January - 6:30pm to 8:30pm.
All problems readily accepted.  If you are not completely satisfied with 
our solutions we will happily return your problems with a smile & no questions asked :-)

You will benefit most if you are currently working on a database - 
but don't let that deter you from coming along. 
Bring your database with you and we'll probably fix it on the spot.

Remember : All the solutions are simple - some just take longer to figure out.