A quick search of the MS Knowledge base for Error 438 turned up two possibilities. I
don't know if either of these possibilities might apply in your case, but they're worth
checking out KB 236469 and KB 246237. See
http://tinyurl.com/3xbv7
Error 2105: "You can't go to the specified record. You may be at the end of a recordset."
This is the text of error 2105. It seems to indicate that you are already at the end of a
recordset, when you are clicking on the command button to add the new record.
Have you ruled out missing references on the PC's that are having this problem?
Other general questions include:
1.) Which version of Access (97, 2000, 2002, 2003)?
2.) What service release level are the PC's at--and are they all at the same SR level?
See Help > About Microsoft Access for an answer to these two questions.
3.) What service pack of Jet is being used? You should be at service pack 8.
See
http://support.microsoft.com/?id=239114
Tom
________________________________________
Thanks for replying! I either get a : 2105 - You can't go to specified rec. or a 438:
Object doesn't support property or method. However this only occurs for users other than
myself. We all use admin.
________________________________________
What error message does it sometimes give you? This could help others identify the issue.
While the DB app. gives me no problem, when I login as the other user and select a
command button....
Are you doing this on the same PC that is working properly for you, when you are logged in
as yourself? Has Access security been enabled on this database? (Actually, every Access
database has security enabled, but the default Admin user has no password assigned).
Check for any references marked as MISSING on the computers that are having a problem. If
you don't find any missing references, then try
refreshing the references collection, by selecting a new reference, clicking on OK, and
then go back and deselect it.
Solving Problems with Library References
http://members.iinet.net.au/~allenbrowne/ser-38.html
Access Reference Problems
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Tom
________________________________________
I am maintaining a DB and getting the following: While the DB app. gives me no problem,
when I login as the other user and select a command button that basically creates a new
record via DoCmd.GoToRecord , , acNewRec, it either gives me an error message or recently
does nothing when the button is selected. Checked Win2000 user permis. for files (front &
back end DB) and have tried giving user same permissions as I. Even tried having another
user in the Win2000 administrators group open the DB and they were getting the same error.
Any body have a clue as to why the DB works for me, but not for another user?
