RE: Run-time error 29068 with Access 2003
- From: Tim D <TimD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 10 Dec 2007 00:56:01 -0800
The decision whether to upgrade to SP3 is not simple, and depends on factors
that only you can evalute. An important factor is which version of Office
users of your apps will be using. The best I can do is suggest several links
below that are worth reviewing rather carefully.
But the first thing is to know accurately which version of Access you have
on your PCs. This point has to be made because you may NOT get the true
version by looking at Help / About Microsoft Access! To see why this is so:
http://support.microsoft.com/kb/328294/
This is a list of Office 2003 SP versions:
http://support.microsoft.com/kb/821549/
This tells you about Jet versions:
http://support.microsoft.com/kb/239114/
Note that it is important that all users connecting to a back-end data mdb
should be using the same version of Jet.
Best to use code to get the current versions of Access and Jet. I have found
Allen Brownes 'Get version' code to be excellent. It is included in his
'Splash Screen' download:
http://allenbrowne.com/ser-53.html
MS list of Known Issues in SP3 is in this article:
http://support.microsoft.com/kb/923618
Note that this list does not include the most common gotchas, again from
Allen Brownes site:
- "Combo is blank if RowSource table field has a Format property entry"
- "Access crashes if RowSource is a table with more than 31 fields"
My own experience with SP3 has been:
a) I had to tweak a number of controls in my apps
b) Once the mods were done, my apps seem fine in SP3
c) The apps still work ok under SP2.
I hope this helps.
Tim
"makyland" wrote:
No, I meant SP 2.
I'm observing now though that in the laptop where I'm experiencing the
problems I have:
Microsoft Office Access 2003 (11.6566.6568) SP2
while in the previous one where I don't have this problem at all the version
is:
Microsoft Office Access 2003 (11.6566.8107) SP2
so I guess that maybe the difference .6568 to .8107 is causing the problem????
I thought the update I installed yesterday was full SP2 but looking at this
it might be that I still need something else right?
I didn't want to upgrade to SP3 because I had heard of some problems with
it. Is it recommendable to upgrade?
.
- Prev by Date: RE: Enable Digital Signature Option in Email Generated from Access
- Next by Date: Re: Boolean Nulls
- Previous by thread: Re: Pages() Error messsage
- Next by thread: Re: not matching values in where clause
- Index(es):
Relevant Pages
|
