HELP !! Problem in using Access 2000 db in Access 2003 !! 1

[linsu]

Hi
I have the databases created in Access 2000 were kept in the server with Access 2003. The users have Access 2000/2003 to access the database. Everything was alright until I opened one database directly in the server and edited and saved. This specific database is now having problem that some of the functions are not working. For example, it does not know 'comparing the strings' for e.g. "abc" = "abc". It gives the error. It was ok before I edited (just adding a few more text boxes).
I think the problem is because of 'References'. I removed and added back the 'References' too. It is totally frustrating and does not work at all. Is there any way to solve this problem?
Please, Help!!
Thanks in advance.

 

[TomCologne]

One thing you can always try is importing all db objects into a new db.

If a module could be causing the trouble, import those one by one.


TomCologne

 

[linsu]

Thanks, TomCologne. I created a new db and imported all the objects from the old db. Now, when I click any of the buttons in the form, It gives the following error message -
-----------------------------------------------------
The expression On click you entered as the event property setting produced the following error:
User-defined type not defined.

* The expression may not result in the name of a amcro, the name of a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro
-----------------------------------------------------

In new db, I made all the 'References' as the old one.

 

[linsu]

It works if I commented out the line - "Option Compare Database" from the source code. I don't understand it either.

 

[TomCologne]

This is what I found yesterday:


How to resolve reference issues in an Access database

http://support.microsoft.com/?kbid=310803

• "Variable not defined" or "User-defined type not defined"

You may receive one of these error messages if you use the User-Level Security Wizard to secure a database that references libraries other than the libraries that are included by default. For example, references to libraries that existed in the unsecured database are not automatically created in the new, secured database.

The procedure decribed in:

How to loop through the references to view their properties in Access 2000

http://support.microsoft.com/kb/209849/

may come in handy when dealing with reference issues.


Did you have "Option Compare Database" twice in your code?

I've had similar problems once after copying & pasting a sub because of a duplicated declaration.

I found that line using "Debug>Compile dbXYZ".



TomCologne