Question Only 1 user cannot add records

[kayjenx]

Hello,

I have a database to track tasks within each department. The BE is hosted on a computer with a shared folder. There are only about 5 users so I didn't feel the need to put it on a server.

Background Info on Database:

This database is being used by more than 1 department. Each has their own records and its held independently of the other. Only 1 person cannot add new records. When she opens the form its totally blank. You can't see any fieldlabel or textbox. Its just the color of the background. I've checked the actual and it seems that she cannot add to the table. There is no blank record (where you can add a new record) and new record button is unavailable. No one else but this user has this problem.

I have never encountered this and I have several other databases that I have made and maintained for over 4 years.

I must also note that I am not using User level security in this database. The user name and passwords are stored in a table in the based and is only really used to add a name automatically for new records and for filtering records.

Any idea what could be causing this? I am tried searching but to no avail. Thanking you in advance.

 

[AccessMSSQL]

You can try a few things:

1. Try re-linking the tables on that specific user machine.
2. Try to open the back-end from that user's machine and see if the tables can be added to directly?
3. Also, is this user on the same version of Access and Windows as others?
4.Is this a user specific or machine specific problem? Have this windows user login to another machine and try using the database. This will narrow the issue down.

 

[kayjenx]

Thanks AccessMSSQL! She has left for the day so I will try these in the morning and let you know how it goes.

 

[kayjenx]

Alright MSACCESSSQL. I have not forgotten you. However, this person's computer crashed and she is awaiting replacement. Here's other information that I realize I should have specified earlier:

This user is the person who has the shared folder on her computer. I am wondering if that's the issue since the forms were linked by the IP address of the computer and its trying to access the same computer by IP. I will relink the tables after she gets a new computer.

Will be sure to update this and let everyone knows how it has worked out.

 

[kayjenx]

Thanks for the concern.

All users have their own FE on their computers. There are different BE depending on their department, and their FE's are linked to the appropriate BE according.


-----------
I've been doing this for a while so I think I understand the implications of sharing the one file with everyone.