Works fine, never any major errors. If I compact and repair it reports no errors.
When i transfer to access 2002 it complains about a few references to libraries like some activex for pdf. But thats probably coz i have acrobat on one of the machines.
If you can't create MDE file in Access 2000 on your PC, then the question is: is this the problem with your MDB file? What about other MDBs? Can you create MDE file from any MDB on your PC? I would assume that you've developed several application and have a couple of MDBs to try.
I would recommend you to split your application into 2 MDBs: one for front end and another for backend. It improves perfomance of the application (put dront end mdb on user's PC) and gives you some (not too much though) protection against changes of the tables' structure, because the structure of the linked tables can't be changed.