Syntax error or access violation

[Akhorahil]

Hi!
I was making an aplication in Access 2010, after hard work I have finished it and works perfectly in my PC (a bit slow because a complicated query).

The program is a form with vinculated tables in a net database.

Well, I tried to share it in another PC's and its impossible for me to run it.
I have an error that i cant fix.

Syntax error or access violation.#0

I made it in Access 2010, my client has 2007 but i have installed 2010, still doesnt work...

PD: Yesterday, i dont know why, it worked once and connected perfectly... just once, i tried again today, and nothing.

Thanks for the help!

 

[vbaInet]

The program is a form with vinculated tables in a net database.

What do you mean by a net database? What database is Access connected to? This error sounds like a database error.

...(a bit slow because a complicated query).

By the way, you can explain this problem in a new thread and we'll able to advise.

 

[GinaWhipp]

Are you connecting to an Oracle database? Does this happen on open?

 

[Akhorahil]

What do you mean by a net database? What database is Access connected to? This error sounds like a database error.

By the way, you can explain this problem in a new thread and we'll able to advise.

I mean, im connecting to a Database by ethernet. It's a Oracle database.
And yes, the slow charge time of que query was just a comment. Thanks! ^^

Are you connecting to an Oracle database? Does this happen on open?

Yes, I'm conecting to an Oracle database, and YES it happends on open!


The error code that F1(help) gives me is 3146...

 

[Akhorahil]

Sorry for the double post.

I finally have got a solution.
I show the references in VBA and one was missing Office XP web components.
I unchecked it and compiled the code and then save the app.
I opened it again and.... it works!

I dont know if it's better if i find the refence OWC and try to fix it or dont touch nothing.

Thanks!

 

[GinaWhipp]

Well, I got busy but I see you found a solution. Thanks for posting it!

 

[vbaInet]

Good to hear as well!

I dont know if it's better if i find the refence OWC and try to fix it or dont touch nothing.

If you don't need the reference then you shouldn't add it. You're the developer so you can make that judgement.