I have a database that is out on a server and is accessed by about 15 users in several locations across the state. I am using Access 2002 and all the user have Office XP loaded. Everyone can access and use the database with no problem except for one user. He can get into the program but when he tries to run a process he gets a debug error saying it can't find a specific query. He is the only one to get this error. I have looked the code and it looks fine and works for me and everybody else. He can access and use other programs we have out on the server that are written in Access 2002. Does anybody have any idea why this is happening?

Thanks,
Scott

__________________
ScottP

Ive had this issue too, what i had to do was replace the db file i was using as the interface and then compact and repair the database and after a reboot of the client it worked again, its a strange problem that i havent come across before. So replace the GUI and do compact and repair and you should be back up and running.

Its weird i know but it worked.

s.wright, thanks for your reply. I am not sure what you mean by interface?

ScottP

Hi Mate, on the database i created, i made 2 files, one on the server with all the data, and another with all the gui and queries and reports on. That was linked to the main DB file. Thats what i meant about the interface, the GUI.

Ah, I have not split the data from the GUI so as not to increase the processing time. Thanks anyways.

ScottP