Recent content by sbayeta

Hi, I have a field 'lote' containing unique values like TM07082004 TT07082004 TN07082004 TM08082004 TT08082004 I'd like to know whether I should use this field as primary key for my table, or create an autonumeric field and use that instead. What are the drawbacks/advantages of each approach...

Thanks a lot for those replies. I'll try them both.

Hi, I've just setup security in my database, and it works fine. Now I'd like to know if it is possible to determine the currently logged user from VBA, since I'll be logging the actions users perform. Is there any function that returns the logged user ? Thanks in advance.

Hi, I'm creating a little db to use at work, and I'd like to allow different user's use different tables/forms. How does Access handles users' permissions ? Is it possible to allow some users to only see the data while others can enter/edit data ? Thanks

I think it does. Thanks a lot. Cheers!

Hi, I'm creating a little Access 2002 database and I have a few questions on how to do it. The main purpose of the database is to store defects we found in our production. So when a defect is detected, we add an entry to the database specifying the defect, the machine causing the defect, the...