Tony's Microsoft Access Blog - All Comments

re: Windows Live Family Safety Filter is an enormous pain

Susanne — Sat, 31 Oct 2009 06:12:06 GMT

Thank you! Uninstalling Family Safety worked for me just now. Hopefully it's a permanent fix, this program has caused nothing but frustrations since I installed it last year, in the hopes of keeping my kids out of trouble. It never worked as advertized, and at the end blocked my access to the internet all together.

Good riddace.

Why doesn't Microsoft mention this in their website?

Next5Exits — Fri, 30 Oct 2009 22:46:09 GMT

This fix (SAVE AS..) addressed this same issue we had with our ADP file. Thank you so much.

Microsoft should have covered this in their support, KB or MSDN.

re: I can't download Google Earth

Doug — Fri, 30 Oct 2009 21:07:37 GMT

The link from the entry above by jluc finally worked for me. I have vista on my HP laptop and tried many links to get google to download and show up with an icon on my desktop, and this one worked:

earth.google.com/.../thanks.html

re: Share your Access 2007 templates

Sieng Leng — Thu, 29 Oct 2009 01:04:44 GMT

Need template of Ms. Access to study database

re: Getting a list of control names on a form

tharpa — Tue, 27 Oct 2009 16:07:02 GMT

It doesn't work for me in 2007.

re: Jackcess is a pure Java library for reading from and writing to MS Access databases.

Tony — Sun, 25 Oct 2009 01:41:23 GMT

I wasn't aware I had mentioned this project previously although I have mentioned MDBTools a few times.

I'm interested in anything that "gets under the hood" of the MDB format . (In a non NDA sense of course). So I figured someone might be interested and poke about a bit.

I was a bit puzzled myself as to why they figured there was a significant different between A2000 and A2002/2003 format files.

re: Jet Engine History

David W. Fenton — Sun, 25 Oct 2009 01:33:30 GMT

My bet is that the Jet history at the beginning in the 3.5 version is identical to that in the 3.0 version. If you sent me the 3.0 version, I'd send you the 3.5 (scanned to PDF, not typed).

Really, I'm not sure the 2nd edition is of sufficient use to be worth spending the money to acquire it. Certainly, I use it, but then, I've never fully reconciled to Jet 4.0!

It's really too bad they didn't put the effort into a Jet 4 edition. It wouldn't surprise me, though, if we someday got an ACE version which included a lot of the content that would have appeared in a Jet 4 edition.

David W. Fenton

http://dfenton.com/DFA/

re: Jackcess is a pure Java library for reading from and writing to MS Access databases.

David W. Fenton — Sun, 25 Oct 2009 01:29:05 GMT

So, why do you keep mentioning this project? Are you working with Java? I can't see that it is of the slightest use to an Access developer, and I just don't understand why the Linux folk want to use Jet (ACE is not relevant as they are supporting only Jet 4).

Their FAQ also seems to indicate that they don't really get the distinction between Access and Jet, given that they say their driver supports A2000 but not A2003 -- there were no differences in Jet at all between those two releases, and the only differences in the file format were at the level of Access-only properties (or, put another way, the updates to Jet were independent of the Access version -- each subsequent Jet 4.0 service pack worked transparently with all the Jet 4-compatible versions of Access). Jet alone should be able to handle these just fine, even though it will give no special meaning to them.

The failure to deal with A2003 files indicates to me that developers really don't have a frigging clue what they are doing. They don't understand that an Access MDB is a Jet MDB with custom properties whose meanings are unknown to Jet, but whose values are still accessible to Jet via the Properties collections of the various Jet objects.

If *I* know this, there is no reason someone who is mucking around trying to reverse engineer read/write access to Jet data stores shouldn't know it.

Either their FAQ is misleading, or these are are rank amateurs whose work should not be trusted with any amount of valuable data.

David W. Fenton

http://dfenton.com/DFA/

re: Queries and the 3061 "Too few parameters. Expected 1." message

Tony — Sat, 24 Oct 2009 21:43:37 GMT

Polprav

Yes, you may quote a sentence or a paragraph from any blog posting or website as well as include a link. But not the entire page.

Also note that you are possibly a blog spammer so I removed your URL from your comment.

No teme

Polprav — Fri, 23 Oct 2009 10:16:23 GMT

Hello from Russia!

Can I quote a post in your blog with the link to you?

re: New version of the Auto FE Updater available

Tony — Tue, 20 Oct 2009 22:23:46 GMT

Orlando

You are absolutely correct. That was on oversight on my part. The next release will fix that.

Thanks very much for pointing that out.

re: New version of the Auto FE Updater available

Orlando — Tue, 20 Oct 2009 17:38:34 GMT

When locking out users shouldn't the Open Server Folder be disabled? Currently when the database is locked the user can still open the FEnd on the server if they open it from the server folder.

re: New version of the Granite Fleet Manager - V1.63

B Raghunath — Mon, 19 Oct 2009 17:51:39 GMT

Need to try out

re: Always copy and paste a file to another PC

Tony — Sat, 17 Oct 2009 22:02:40 GMT

Anon, that was too long ago for me to remember that detail. I was likely on my Win XP host system though.

re: Always copy and paste a file to another PC

Anonymous — Thu, 15 Oct 2009 17:32:30 GMT

Are you trying this on a Vista machine? It is my understanding that XP and MS OS's before that follow the original description. For Vista, copy and move now act the same.

re: The expression On Click you entered ...

Finny — Thu, 15 Oct 2009 11:24:54 GMT

thanksss soo much this really helped me!!

re: I can't download Google Earth

Deniz — Sun, 11 Oct 2009 16:17:31 GMT

Hi,

I think the problem is with the automatic downloading. Try starting the download manually.

re: Is Nothing

David W. Fenton — Tue, 06 Oct 2009 04:21:02 GMT

I'm confused, Tony. Don't you have:

<pre> If Not rs Is Nothing Then

rs.Close

Set rs = Nothing

End If

If Not db Is Nothing Then

' if it's not DBEngine(0)(0)

db.Close

Set db = Nothing

End If</pre>

...as part of the exit routine in every sub/function where you open recordsets and db's? Is that what you're saying? This has been standard cleanup code forever.

It doesn't belong in the error handler, though, but in the exit routine, which you resume after you've handled the error.

Keep in mind, though, that it's possible with database variables where you've opened a database other than DBEngine(0)(0) for the variable to be Not Nothing but still closed, so you have to trap for error 3420 and deal with it (how depends on the context). My dbLocal() function for caching a reference to CurrentDB() has included checks for that for quite some time, since I discovered the problem in regular use (you can Google my name and "dbLocal" and you'll find the code, though I can't guarantee it will be the latest version).

David W. Fenton

http://dfenton.com/DFA/

re: Bizarre Access 2003 error message

Mark — Sat, 03 Oct 2009 16:20:52 GMT

I am also getting this reference error when I open any database downloaded from my instructor at school. I am being told it is a normal reference warning, and to alt+f11, access the missing reference, remove it, then go back in and recreate the missing reference. I am looknig for a more permanent fix so that I do not have to do this on every downloaded database file.

Someone else recommended to me to run that script and get a list of references, but I can't get it to work. Does it get created in Access somewhere?

Also, this problem did not start until I installed Office 2007 Enterprise, and I suspect that that particular .dll reference is because my MDAC version is now newer than what the school is using.

re: Windows Live Family Safety Filter is an enormous pain

kel — Sat, 03 Oct 2009 09:56:54 GMT

just used revo uninstaller..........thankyou whoever posted that up you are a genius!!!!