I have an .mdb which holds one table. This table is referenced by two other Access applications which link to it. In one of the programs there's a form that all of the needed values are pulled into from that linked table (user name, administrator flag, etc...). A query filters into this form when the user logs in. This way it is not necessary to have the table open and I can read/write via the hidden form to the table.
This setup has worked perfectly to read from the table, however issues of sharing come up when trying to write. For some reason this table is locked on occasion which would prevent writing to this table. The issue does not occur when the user is running AccessRT, but happens when the full version is in use. I guess I can go around and locally turn off locking on the machines, but was wondering if there's a way to set the table so that it cannot be locked.
Here's what I'm trying to get the program to do...
A user logs in and goes to the main menu. Some links are hidden depending on their login and which flags they have checked when I setup the account in this table...this part works perfectly.
Now I've added a button at the bottom of the page that allows the user to go to "Read Messages" section. Next to this button I placed a picture that alerts users when new messages are input. The picture will show when 'Read' in the users table is "no" and will hide when 'Read' is "yes". When the user clicks on the Read Messages button it runs a macro which writes to this hidden form which writes to the table to enter a "yes" value for 'Read'. This works just fine except for the systems that have file locking enabled. When one of those machines is logged in, then it gives an error when going to Read Messages that the table is either locked, in design view, etc...
Any suggestions to be able to permanently unlock the table no matter what? Hope it was specific enough!
Thanks.
This setup has worked perfectly to read from the table, however issues of sharing come up when trying to write. For some reason this table is locked on occasion which would prevent writing to this table. The issue does not occur when the user is running AccessRT, but happens when the full version is in use. I guess I can go around and locally turn off locking on the machines, but was wondering if there's a way to set the table so that it cannot be locked.
Here's what I'm trying to get the program to do...
A user logs in and goes to the main menu. Some links are hidden depending on their login and which flags they have checked when I setup the account in this table...this part works perfectly.
Now I've added a button at the bottom of the page that allows the user to go to "Read Messages" section. Next to this button I placed a picture that alerts users when new messages are input. The picture will show when 'Read' in the users table is "no" and will hide when 'Read' is "yes". When the user clicks on the Read Messages button it runs a macro which writes to this hidden form which writes to the table to enter a "yes" value for 'Read'. This works just fine except for the systems that have file locking enabled. When one of those machines is logged in, then it gives an error when going to Read Messages that the table is either locked, in design view, etc...
Any suggestions to be able to permanently unlock the table no matter what? Hope it was specific enough!
Thanks.
