Undefined Function Mid in expression after I installed MySQL

[malibu65k]

Hi all,

I installed MySQL yesterday on my laptop (Windows XP) because I had to have it for a project for my class I'm taking, and when I try to run a query in my MS Access database(2003) that uses the mid function I get an error message, "Undefined function 'Mid' in expression'. This query has always run before until yesterday after I installed MySQL.

Can anyone tell me if they have seen this before and how I can fix it?

Thanks in advance!

 

[SkipVought]

Hi,

Reload Access

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[malibu65k]

Never mind! I found the problem

In the references...

I removed...

Microsoft Visual Basic Application Extensibility 5.3

and added...

Microsoft Visual Basic 6.0 Extensibility

This worked. If I have other problems that develop from this I will post just in case anyone else has a problem with it.

 

[malibu65k]

Thanks Skip, I was just about to do that when I thought about trying the above.

 

[SkipVought]

Oh, yes, and check the wall plug! ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MajP]

I see this question asked all the time on this site. "My mid,left, right, instr... stopped working." It always has to do with the reference to vba. Often you will see this where it works on one machine and not another depending on the updates on the machine.

 

[MajP]

http://bytes.com/topic/access/answers/194577-certain-functions-have-stopped-working

This references Allen Brownes article describing this.