Recent content by sjs

Thanks, these two links helped me resolve the problem

Tim, thanks for the link. Will check it out when back in office in two weeks. Presumably I can run this code as is in Access 97 VBA? Also would I be able to adapt this code to point to my own icon

Is it possible in Access vba to create a shortcut on the desktop which points the mdb containing the vba and an icon in the same directory?

We are currently using Access 97 as standard. I am just about to submit a capital exenditure form which must cover everything. In the immediate future we will use Access 97 MDE front end against an SQL Server backend but in the longer term I could see a need to use Access XP Runtime with MDB...

Correct me if I am wrong, but I am fairly sure that running queries in an Access front end inflates the size over time. Presumably Access creates temporary works space under the bonnet which it does not recover.

SQL Server backends don't need compacting. I need to somehow to replicate the Access 2000 functionality so that Access 97 compacts on exit.

Yes exactly. The front end will be an Access 97 MDE file on the users PC only containing temporary tables, code, forms, reports etc. The backend is a single SQL Server instance on the WAN.

I should have said this is in Access 97. These will be individual copies with one user at any time. It is in fact a front end for an SQL Server backend.

I need to be able to compact an Access MDE file on exit. This MDE file would need to be distributed to multiple users so I would want to avoid having an additional configuration on each target machine. Looking at the options in this thread: TSI SOON seemed suitable but I think requires...