473,326 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2003 with SP3 causing problems

I just got SP3 installed an about half of the forms in my database no
longer open, it reports "there is not enough memory to complete this
operation" (RAM and disk space are in abundance).

Is everyone avoiding SP3 or is it not a known problem?

Sep 25 '07 #1
3 2733
Viasys, can you provide some more info?

Do these forms have combo boxes on them?
Is the RowSource of the combo a table or a query?
How many fields in the table/query?

Anything in the Format property of the fields in the RowSource table?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Viasys" <go**********@viasys.co.ukwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...
>I just got SP3 installed an about half of the forms in my database no
longer open, it reports "there is not enough memory to complete this
operation" (RAM and disk space are in abundance).

Is everyone avoiding SP3 or is it not a known problem?
Sep 25 '07 #2
On Sep 25, 1:39 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Viasys, can you provide some more info?

Do these forms have combo boxes on them?
Is the RowSource of the combo a table or a query?
How many fields in the table/query?

Anything in the Format property of the fields in the RowSource table?
Hi Allen, sounds like you know something :-)

Looking at one of the forms now, there's one combo box that uses a SQL
statement against a table.
Rowsource = SELECT [zstblWhatsNew].[WhatsNewID], [zstblWhatsNew].
[VersionNumber], [zstblWhatsNew].[ReleaseDate] FROM [zstblWhatsNew]

No formatting in the combo box or the source table. The form does not
open in design mode either.

Another form I just looked at is a template one I use for unbouind
forms, it has 7 buttons, 4 labels and a box. All the buttons have a
function call (=Functionname(form) or some such) and are no different
to all the other forms that do work. In fact, everything on tjhis
template form would exist in the other forms, which makes it hard to
narrow down. There is a smart tag saying one of the button's short cut
key is used more than once but that doesn't occur i nthe other form
that I looked at.

Now (I purposely re-applied SP3 to a machine) if I try opening in code
in normal mode I get "The microsoft jet database engine cannot find
object '', make sure the obect exists and you spell its name and thre
path name correctly", opening in design view gives the "not enough
memory".

Sep 26 '07 #3
On Sep 27, 1:00 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
You're right: a bad binary should not survive a SaveAsText, delete module,
compact, LoadFromText sequence.

Presumably this is not just a bad index, since that should be identified
and/or fixed by a compact also.

Not sure what else to suggest.
Apart from turning off automatic updates to make sure MS doesn't push
SP3 on me :-)

Sep 27 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Wayne Aprato | last post by:
I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
1
by: Norman Fritag | last post by:
Hi there I have avoided to use active x controls because I thought they are causing more problems then they are doing any good. I a new application I would want to use the tree and list view...
10
by: Wayne Aprato | last post by:
I have a database that was written in Access 2003 using the Access 2000 file format. When I run the mdb in Access 2003 everything works fine. If I run it in Access 2000 the timer event won't fire...
10
by: B Moor | last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM SQL Server 2000 sp3 (or latest).MS Office 2k3 I have the access 2k3 front end running on server (this may get changed) and all was well...
0
by: Wayne | last post by:
Can anyone cast any light on the following. I have a database that I have written in Access 2003 using 2000 file format. Everything was working OK when running it under Access 2003 but when I...
3
by: Shailesh Humbad | last post by:
I figured out what was causing the "Access is Denied" error when calling functions from referenced DLLs in my service. I've tried to be very detailed, so bear with me. It turns out that...
8
by: rdemyan via AccessMonster.com | last post by:
I've converted my application from A2K format to A2003 format. I tried to follow Allen Browne's protocol in getting my app into A2003 (although I was unable to find informtion on the conversion...
2
MSeda
by: MSeda | last post by:
I just got a new laptop and need to get Access for it. I was wondering if anyone had tried 2007 yet. MS says it has 2007 "Most functionality in previous versions of Access is available in Office...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.