All Tags » Access (RSS)

Browse Site by Tags

Showing related tags and posts across the entire site.

  • Smart Access Magazine

    Garry Robinson, fellow Access MVP, has purchased the Smart Access Magazine . there was 300 articles/2000 pages written by over 100 of best Access professionals in the world under the guidance of editor Peter Vogel. (Although I do recall emailing a few authors some corrections and never hearing back from...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Mon, Jun 1 2009
    Filed under: Access

  • DbUtilities - Transfer object permissions from a secured database to a new database container

    The first item "is a fantastic re-write of DbUtilities which, as an Add-in, makes it easier to transfer the object permissions from a secured database to a new database container. " Author: Jeff Conrad (aka "Access Junkie"), former Access MVP and now a test for Microsoft. Sandra Daigle's...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Sat, May 23 2009
    Filed under: Access, Security

  • Redimming an array 1,000,000 times takes 4.63 seconds

    The following question was asked at StackedOverflow. How do you redimension an array in VBA? . One response was some detailed code showing how to redim an array efficiently by doubling the number of elements. This took 0.41 seconds for a million records while redimming 1,000,000 took 4.63 records. I...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Thu, May 21 2009
    Filed under: Access, Tips, VBA

  • Latest Access 2003 hotfix - 970623

    "When you try to import all objects from an Access 2003 database into a new one, you receive the following error message: There isn't enough free memory to update the display. Close unneeded programs and try again." Access 2003 hotfix package April 28, 2009 - 970623
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Thu, May 21 2009
    Filed under: Access, Patch

  • Microsoft Office 2010 Technical Preview

    The Microsoft Office 2010 Technical Preview is a limited, invitation only program which will provide you with the opportunity to experience early, pre-release versions of Office 2010 which will include the following applications: Word 2010, Excel 2010, Outlook 2010, PowerPoint 2010, OneNote 2010, Access...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Tue, May 12 2009
    Filed under: Access, Office

  • Exceeding 2 Gb MDB file size (and a bit of TGIF humour)

    Exceeding the 2 Gb MDB file size gives you an exceedingly misleading error message: In Jet 4.0 one message that is received when the 2 Gb file size is exceeded is invalid argument. This is, of course, utterly confusing and can mean other things such as corruption. In A2007/ACE (I was running in an ACCDB...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Fri, May 8 2009
    Filed under: Access, Humour

  • Dreaming of Rails as the Next Microsoft Access

    An interesting blog posting titled Dreaming of Rails as the Next Microsoft Access (Rails meaning Ruby on Rails of which I know nothing other than having seen the occasional reference it.) Now I disagree with the authors characterization of us as "Office drones". <smile> Nevertheless interesting...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Mon, May 4 2009
    Filed under: Access, Software Development

  • The problems with currency fields

    The Access help on currency fields states: Use a Currency field to prevent rounding off during calculations. A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right. A Currency field occupies 8 bytes of disk space. Excellent you figure. Now if your code and...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Mon, Apr 27 2009
    Filed under: Access

  • I sure hope there is a final exam on this course

    Project title: Need 15 Queries in Access "I need someone who can make 15 queries in Access 2007 and have to be done in sql view (this is a must). I want this for school home work and need them fast, as soon as possible. I will provide you with the tables and the queries I need, they are attached...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Mon, Apr 27 2009
    Filed under: Access, Humour, Eclectic

  • Overflow error 6

    A newsgroup poster had the following very standard lines of code strSQL = "SELECT Mytable.Field1, Mytable.Field2, Mytable.Field3 FROM Mytable" SET rs = Currentdb.OpenRecordset(strSQL,dbOpenDynaset) The error was Overflow error 6. He then replied a day later indicating that one of the variables...
    Posted to Tony's Microsoft Access Blog (Weblog) by Tony on Sat, Apr 25 2009
    Filed under: Access, Tips, VBA
Page 1 of 28 (279 items) 1 2 3 4 5 Next > ... Last ยป