News, links, downloads, tips and tricks on Microsoft Access and related
Thursday, December 30, 2004
Forgot how to write connection string?
- create new file test.udl
- open it, define connection settings
- close it
- open in notepad and copy connection string from there
Thursday, December 23, 2004
New browser - Firefox
AccessD list search
Wednesday, December 22, 2004
Checklist for Testing SharePoint Web Parts
OneNote 2003 Software Development Kit
People discussing Translator
Would be good to add a link to MS Access Translator there...
And one more site about SharePoint
Blog on SharePoint services
Tuesday, December 21, 2004
IDE for MSDE
Monday, December 20, 2004
AttachDB available for download
Finally it is here: http://www.pointltd.com/Products/Details.asp?dlID=46
AttachDB helps to perform simple administration tasks on SQL Server databases without SQL Server enterprise manager. It also checks that SQL Server has latest service pack installed. Utility can be used with command line arguments in bat files and setup scripts. Supports browsing for file on remote server. What it can do:
- Attach/Detach DB
- Backup/Restore DB and Log
- Run Script
- Shrink DB
How to map SQL Server login to DB login
Thursday, December 16, 2004
New edition of VBA language reference
Web Services in Office
Produced a first video :-)
[Access] How to deploy Outlook security settings using Group Policy
[Access] Access on Citrix problem
Access 2003 application, backend on separate server on the same network, people run application locally and with Citrix server. There is a complex form with about 10 subforms on it. When users try to add or edit record in subform sometimes occur a following error #3197:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". Also could occur other error "Not a valid bookmark"
Mostly error occur when Citrix server is heavy loaded. So I got a "feeling" that Citrix somehow reduce or cut Access cache or buffer it users to read records, and Access produce such error. After playing with different Jet setting I found that setting DBEngine MaxBufferSize option to 10000 eliminate mentioned error. Actually 10000 is empirical value, if we find some more precise value - I will publish it here.
And few more settings which could help Access to work smoother on Citrix:
- open frontend in exclusive mode
- turn off record-level locking
- move workgroup file to local disk
- use less subfoms, load subforms on demand
If you have any comments on this - please let me know
[Alex] How to stop evil
"The only thing necessary for the triumph of evil is for good men to do nothing".
Tuesday, December 14, 2004
Wednesday, December 08, 2004
[Alex] Found Valka!
He still in London, have a daughter and driving motorcycle!
Tuesday, December 07, 2004
[Access] Report Grouping sample