Checkbox Deafult Problem introduced by SP3

T

ToniS

I have Access 2003 and SQL Server 2000. Lately I noticed when I add a new
record, all of the bit (check box) feilds deault to True instead of False. i
have made sure w/i Enterprise Manager the defualt is 0, I also did this with
in Access, property
field default value to 0. I did some research and one reply on
Microsoft.public.access was that this is a known bug that has been introdued
by 2003 sP3 and MS is aware if this problem. Do you know if this problem has
been fixed? How do I determine that? (I tried looking for a fix) Does anyone
know of a work around?

Below is the website where I found the response.
http://groups.google.com/group/micr...a5112528fa?lnk=st&q=access+sp3+adp+bit&rnum=9

Thanks
ToniS
 
P

Paul Shapiro

I have a client using Access 2003 SP3 with an adp and SQL Server 2000, and I
have not heard of this issue from them. I think I would have if it were
occurring. Check again on Access post-sp3 hotfixes. I also seem to remember
the 945674 hotfix might have fixed this problem.

You could check that the SQL Server has all current updates, in case that
would affect what's happening. I seem to remember an adp problem if a bit
field allows Null. If the field currently allows null, you could change that
to not null. Last option would be to use SQL Profiler to see exactly what
Access is sending to the server. Maybe something there would suggest a
workaround?
 
B

bcap

My phone rang red-hot because of this problem when SP3 was released. I had
to figure out for myself that it was an SP3 issue (MS hadn't acknowledged it
at the time) and then tell everyone to go back to SP2 (which meant a
complete Office 2003 uninstall/reinstall). However, the hotfix fixed it for
everyone. I suspect that pcbins either hasn't installed the hotfix where he
thinks he has, or he has a different issue.
 
P

pcbins

Where am I supposed to install it? I ran the hotfix and extracted the file
and ran it. I assumed it would install itself where it needed to be. It used
to fix the problem but it doesnt anymore. Or sometimes I just had to
re-create the form and it would work. But now it seems nothing I do will fix
it.

This is embarressing because I work for a multi million dollar company and
now my data bases have so many issues its insane. And no two PC's have the
exact same issues. But these combo boxes are essential.

I would not even be using Micros#!t Access for my databases except that this
company insists I use it.

Perhaps after I print up all these issues and prove to them that I am not
incompetent, they will accept my suggestion to use a far superior system.
 
S

Sylvain Lafontaine

Not sure about your descripion of the problem but this hotfix should be
installed on every machine of each user. If you are installing it only on
your machine, this could be the the problem. You should also check that all
of the latest service packs (WIndows + Office) have been applied to all of
these.

Second, have you tried to decompile the ADP file (by using the starting
parameter /decompile / complact in a link) twice (2) in order to be sure to
remove any pre-compiled VBA code before distributing it?

A solution would be to change the bit field into a tinyint because the
tinyint can store the value -1; which is the numerical value of True in VBA.
This would take more place for the database but would work for all systems;
whatever their SP and hotfix status.

If you are not using a continuous form, you could also use an unbound
control to display these values; by using code that will set and reset them
in the OnCurrent and the OnBeforeUpdate events of the form (or something
like that).
 
B

bcap

You seem unclear as to what problem you actually have. This thread is about
the SP3 bit columns/check box issue, but you are talking about combo boxes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top