Tony's Microsoft Access Blog - All Comments

re: granite.ab.ca is temporarily down

Tony — Thu, 17 Jul 2008 21:04:41 GMT

Yes, the webserver is still unreachable by the outside world. This is now 53 hours. GRRRRRR

re: granite.ab.ca is temporarily down

Robert — Thu, 17 Jul 2008 20:13:02 GMT

Hi Tony,

Is your web site still down? You had a great article on setting up terminal server when using it with MS Access that I have shared with a number of people. I am trying to find it again. The URL was: www.granite.ab.ca/.../terminalserver.htm

I know working with some telco's who provide a 24 hours response time (24 business hours which is 3 may be even 4 days in the telco world since they seem to only work half days.) is frustrating. We have had our unfortunate share of bizzard issues with them as well.

Hope things get going soon.

Regards,

Robert

re: granite.ab.ca is temporarily down

John Thoms (thomasj@zachry.com) — Wed, 16 Jul 2008 22:52:06 GMT

Any ETA on uptime? I was on MS web discussion and need some informaion on usage of temporary tables...

Thanks!

re: Microsoft jet database engine could not find object 'xyz.dbf'...

Scott — Tue, 15 Jul 2008 20:20:53 GMT

Had a similar issue with a file that had name.2ndname.txt and Access will not find it. For whatever reason, it does not recognize or can not find a file that has two dots. Thanks for the comment, though. It helped send me looking in a differennt direction.

re: The Laptop Drive of Shame

Garry — Tue, 15 Jul 2008 19:49:38 GMT

Suffered the same problem many times, my solution was to force myself to always pack the cord first and tell myself off when I put the laptop in the bag first. Now I have a bag that has 4 pouches, glasses, mouse, wireless connector and yes one for power cord. I pat these before I leave to check if I have these becuase without them, you are scrammbling not to look like a gooooooose.

re: Norton Antivirus strikes again - ODBC to SQL Server 2005

abhishek — Wed, 09 Jul 2008 08:12:19 GMT

Thanks a lot. I had the similar problem the solution mentioned works.

re: KB article 950812: Compact and repair might delete your database (Access 2007)

KC1127 — Sat, 05 Jul 2008 14:31:16 GMT

What a horrible bug!

re: KB article 950812: Compact and repair might delete your database (Access 2007)

KC1127 — Sat, 05 Jul 2008 14:30:34 GMT

What a terrible bug...

re: Updated - Microsoft Access Email FAQ - DOS Mailers

Bonnie — Tue, 01 Jul 2008 11:13:25 GMT

I use DOS all the time.

re: Silly, silly HP printer driver software

Bonnie — Tue, 01 Jul 2008 11:00:39 GMT

I love HP printers but agree with your take on the driver software. Been a pain.

Thanks.

re: Page with sample VB code for Serial Port IO

Tony — Fri, 27 Jun 2008 19:33:53 GMT

Janaka, did ou follow the links mentioned?

Compile error: Sub or Function not defined

Tonys Microsoft Access Blog — Fri, 27 Jun 2008 19:16:44 GMT

As a follow up to my previous blog entry Compile error: Method or data member not found here's the

Compile error: Sub or Function not defined

Tonys Microsoft Access Blog — Fri, 27 Jun 2008 19:06:03 GMT

As a follow up to my previous blog entry Compile error: Method or data member not found here's the

re: Heroes Happen Here {Comic Series}

Lauren — Fri, 27 Jun 2008 18:27:41 GMT

Great comic strip! Thanks for the tip

re: Page with sample VB code for Serial Port IO

janaka — Wed, 25 Jun 2008 06:54:19 GMT

need vb codes for serial communication

re: Adding Programs to Access 2007 Deployment Packages

Mark Hammer — Sat, 14 Jun 2008 19:25:01 GMT

Thanks, Tony! Very helpful. You're the greatest!

Mark Hammer

Lake Oswego, Oregon, U.S.

re: File Compression using the OS and NTFS file system

Tony — Fri, 06 Jun 2008 01:21:37 GMT

Sure but there's also free open source dll's and sample VBA code that will also allow you to zip and unzip files mentioned on that same page. I'm using them inside some of my apps.

DLLs in the same folder as the MDB/MDEs don't require installation which I would imagine an Activex Control would.

However the main point of this blog entry is using the Windows OS and NTFS built in compression.

re: File Compression using the OS and NTFS file system

Garry Robinson — Fri, 06 Jun 2008 01:11:25 GMT

Polarzip light does this nicely but that requires an install. VB code is very clear.

re: Permission Denied

Tony — Wed, 14 May 2008 20:18:59 GMT

Grovelli, correct. If I have a user specific table I'll also do a Cartesion join, filter the form and have the user specific fields also on that same form.

I do not use the main menu for such variables, with them not visible of course, as the user can use the mouse scroll wheel to go to a second record and cause troubles later. Been there, done that. Took me quite a while to figure out what was causing that problem.

re: Permission Denied

grovelli — Tue, 13 May 2008 19:14:51 GMT

Hi Tony, you say, " I always use a GlobalOptionsHidden form to store those Global Options variables". Do you mean you store those Global Options variables in a table referenced by the hidden form?