Access Database not running well on P4 processor

[Jeff]

I have a database application that does not work on a P4.
The only thing I can come up with is that the computer is
too fast for the program. The database loads fine but
when I try to find records using a form all of the objects
become invalid and I receive the '?Name' message in most
of the fields of the form. The database works fine on a
P1,P2 and P3 processors. Anyone know what could be
causing this?

Thanks
Jeff

 

[Paul Overway]

Not the processor. You probably have a bad reference.

 

[Jack-of-all-traits]

I guess you are using INTEL, and not AMD ? P4 means intel chip, maybe make
sure your computer is actually and Intel, sometimes the CPU may not function
100.00000% of the time since at the assembly language level there may be
very
unique differences in the way code is excuted.

Maybe try uploading all available patches for your access from the ms
website
also to see if there is a difference.

Please let us know what worked out.

Thanks-

 

[Tony Toews]

I guess you are using INTEL, and not AMD ? P4 means intel chip, maybe make
sure your computer is actually and Intel, sometimes the CPU may not function
100.00000% of the time since at the assembly language level there may be
very
unique differences in the way code is excuted.

FWIW I've been running mostly AMDs for about 10 years with no
problems. Only my last laptop has been an Intel CPU.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Albert D. Kallal]

You don't mention what version of ms-access.

Since it loads and runs (somewhat!) you likely are NOT experience a bug in
a97 when you have more then 1 gig of ram. (if you download the sr
updates....this is fixed).

The above actually gives an error about "out of memory" in the above case

However, regards...you should make sure the updates and bug fixes to access
are installed.

Can you open some code, and do a save and compile all?.

And, as others have mentioned...check your refs....

For info on refs check out:

Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803

 

[Jeff]

The CPU is an Intel P4, I have checked references and have
the Access version up to date. Version 2002. The problem
may be the way the code finds and updates the screen with
records. When I search for a record or update some data I
get the ?Name error. I will look into this problem
further but it seems I will need to rewrite some code to
get this to work on the P4.

Thanks
Jeff