Recent content by databasepnt

Hi saseymour, I think I found the answer. Basically it happened to me because my macro codes of displaying a record by pulling a so called "holding table" which should be owned separately of a FE file instead of being shared. To fix this problem: 1/ I exported that "hold" table as Excel...

Hi Pat, Thanks much for your question! I am not sure if there is any. But my FE file has a few simple forms. One main form is to pull a record by record ID then update or clear any data in the form. However I have one table so called 'holding record'. This table will hold the data of the...

Hi Pat, What happened was that Let say I and another user (2 users) open the two different FE files. I pull the information of record ID - 01. I haven't had a chance to update or done anything with this record yet. The information of the same record ID - 01 on my form is also automatically...

Hi Pat, Sorry about that! Thanks for your answer! I rechecked and found that the .ldb was also created. I also checked the permission and found that all users have all of the rights: full control, modify, read & execute, read, and write; except "Special permissions". Not sure if the...

Hi all, Hope I can find an answer here. My database has successfully split. However, the FE acts like not being split - Only one person can access the database at a time. For example, I am accessing a record - ID 01 by using a form. And as soon as another user is about to use the same...