Access 2000 with Windows XP

[Michael Hobbs]

I have an Access 2000 database that I've been using since
Access 1.0 days. It works fine on my Windows Me machine,
but I got a new Dell laptop with Windows XP Home.

I installed Office 2000, and brought over my database.

I am having problems with queries - messages such as:

"Function not available in expressions in query
expression...", refering to my use of the Format()
function.

I've also received something like "Expression too complex"
in a query.

Any ideas why an Access 2000 database would not work on
Windows XP?

= Driven Crazy
= Michael

 

[Kristyn Wagoner [MSFT]]

Hi Michael -

This sounds like you may have a missing reference on the new machines. Take
a look at this article for steps to check that.

208218 ACC2000: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=208218


--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Michael Hobbs]

I am getting these errors in query expressions typed
directly in query design view. I am not calling VBA
functions as part of the query. Would missing references
still apply when not inside a module?

= Michael

 

[Ken Snell]

Michael -

Format is a VBA function, even though you're using it in a query. Kristyn's
advice is where I would start to fix the problem.

 

[News]

I would go to the Access vbe and check references. By default, Access does
not automatically refence DAO, but does reference ADO.. Also, when checking
references, be sure that your DAO reference is listed before the ADO
reference.

--

Richard Overturf
Harvest Data Systems
New Port Richey, FL USA
(e-mail address removed)