Error -2147217900

[D Collins]

Hello,

I have a database that I've created on my home computer,
yet when I install it on the client's computer, one of
the functions that I created and wrote code for doesn't
work. It brings up that error code number and says there
is something wrong with the SQL statement.

Therefore, I was wondering why it works perfectly on my
computer and several other computers that I've tried it
on, yet it fails to work (just this command button which
brings up a calendar) on their computer?

I did make sure that the .ocx file was registered. They
are using Office 2000 Professional and I suggested they
upgrade their Access program to XP version ('cause I
thought that would resolve the problem.)

I typed this error code into the knowledge base and it
came up with a lot of hits, but I didn't see one in
particular that matched my scenario.

Does anyone have any thoughts on this? It's driving me
mad, as I cannot replicate the problem at my site.

Thanks!!

 

[Tony Toews]

yet it fails to work (just this command button which
brings up a calendar) on their computer?

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

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