Database Issue Checker software

[Lou_Reed]

I have a software program: Access Database Issue Checker

It seems a little dated. When I ran my db through it, the most common error in Table Field Properties is

Allow zero length

I assume that this is in the design view of the table properties. It usually is an option. I am not sure how accurate it is however, since when it says I should allow zero length


in some field, well I already do. So what gives here. It seems like a good program to pick small errors. I am just wondering how accurate.

Another error is : Bad characters: Space. But I have not even put anything in the filed yet?

What gives?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Bob Fitz]

Another error is : Bad characters: Space. But I have not even put anything in the filed yet?

Could it be referring to some other object name, like a table?

[jwhite]

That utility written by Allen Browne (http://allenbrowne.com/appissuechecker.html) is just another tool developers can use to help them with maintaining databases. Allen did state at the top of that page:

Some of the issues it identifies may be irrelevant - even intended - in your application. For example, null foreign keys can be a very useful design technique, and spaces in a field name will not cause problems beyond slowing development. The utility merely reports the facts, and you decide what is relevant. You can therefore configure it to skip particular words or characters, and ignore issues.

It's a tool; not a utility telling you things must be changed. And I presume the "Bad Characters: Space" is due to object names and fields having spaces in your database, as has been observed with copies you have posted here.

[Lou_Reed]

Okay, my most common complaint :

Allow Zero Length
Subdatasheet
Bad Name Application Property

These are all quite new to me. What do they mean?

Respectfully,

Lou Reed

[jwhite]

Allow Zero Length: Your field is allowed to have a Zero Length String (ZLS) as a value, see http://allenbrowne.com/bug-09.html
SubDataSheet: See same link above
Bad Name Application Property: Not sure what this refers to, what was the value associated with the match(es)?

[andy49]

Well for a start the bad name lost will be the name of a field table or control that isn't a good idea. Maybe a field called [date]?


Sent from my iPhone using Tapatalk

[Lou_Reed]

The program by Allen Browne was a significant help. It got many small errors in my db. But I have two questions.

First, how does one run the code he offers? It is clearly in VBA. But he is unclear exactly how to run it.

Secondly, are there any other programs out there that can do similar things?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[jwhite]

The Application Option "Display Form" is set to frmMain, so on startup frmMain is automatically opened. It is not started from VBA code.

There may be other working & supported options out there but haven't heard of any. There is another by Rick Fisher (Find & Replace, http://rickworld.com/) but he's gone awol and the latest version doesn't work well with recent versions of Access, as I have read. MZTools and Browne's utility are both great in their own right.

[Lou_Reed]

I down loaded from a previous a VBA checker program, but it will not install. It always ends the install prematurely. How do I install it?

Respectfully,

Lou Reed

The program is called VBA inspector/

[jwhite]

Need more info - how did the install end prematurely?

For others reading, he is referring to: http://www.team-moeller.de/en/?Add-Ins:TM_VBA-Inspector

The utility is installed as an Add-In. Once installed, from the VB Editor, click Add-Ins menu at top, then TM VBA-Inspector should be in the list.

[Lou_Reed]

I am using Windows 10, 64 bit Pro. The install just ends with no reason, I have a paper from the internet that says to turn off .Net framework 3.5. I am not sure how.

R,

Lou Reed

[jwhite]

"just ends with no reason" doesn't tell us anything. In detail, when you ran the installer, what happened? Screenshots would help. And what is the "paper from the internet" that says to turn off .Net Framework 3.5? Is it associated with VBA-Inspector? We need more details to assist.

[Lou_Reed]

A dialog box opens during install process that says the "Installer Ended Prematurely". I did a search with that phrase and got a lot of answers, the
one that seems most credible is a software conflict with another application. In my case .NET. Just turn that off, it implies and everything will be okay. It is worth
a try, but how to do it?

Also, on Database Issue Checker, I got bad name field property: Type. It is in a table. That is all it says, but what is bad. I do not think that I am using a reserved word, which I think is the usual reason given for bad name. So what is it?

Respectfully,

Lou Reed

[jwhite]

I had no issue installing the app on my pc which is 64bit Win10 and .net 3.5 and 4.5 are both enabled. You may have another app that requires 3.5, so I wouldn't blindly disable it to see what happens without investigating further. You could try asking the author of the utility. With regard to "Type" - that is a reserved MS-Access Keyword - don't use it as a variable or field name in a table.

[Lou_Reed]

I not want to uninstall it; I only want to disable it, install VBA code inspector and then re-enable it.

Would that work?

R,

Lou Reed