Set Warnings Off

[Ramu]

Hi

I am a new user for access 2000, I have developed a database with a multi user environment, I am using some macro to delete some records and paste the same record in other form, it is working properly (when only one user), If another user opens the same data - it showing a warning message as "your don't have access to this table, if you delete you can not save the table") - eventhough the result is perfect - Now I want to avoid this warning message - I am already using the set warning - no & after update & before update also using Docmd- warning False. BUT STILL I AM GETTING THIS WARNING MESSAGE- PLS HELP

Thanks
RAMU -
ramu_s@hotmail.com

 

[Calvin]

Check your record locking on the form, is it "Edited Record", "No Locks", or "All Records", make sure it is set to "Edited Record".

You should also check the Options (from the Tools menu), once open, select the Advanced tab, and in the upper right corner is "Default open mode", make sure it is set to "Shared" and below that is "Default record locking", make sure it is set to "Edited Record"

Convert your Macros to Code within the form that needs to execute it, this will be more efficient and stable as well.

Another problem could be if both users are using the exact same file on a shared network folder, the database should be split into a Frontend and a Backend, the Backend is where the tables are stored, and the Frontend is where the forms, reports, queries, macros and modules are stored.
The Frontend will LINK to the tables in the backend and you distribute the Frontend to each users workstation so they each have there own copy.

There could be some other issues as well, but try the above first.

 

[Ramu]

SET OFF WARNINGS

Hi Calvin

Thanks for the reply, I have tried all options as per your mail (exept the front end one) but still I am getting the message.

How to kill?

Please

Thanks
Ramu

 

[Calvin]

It still sounds like the table is being locked exclusively by the first user, if your absolutly sure that "All Records" is not the selected record locking feature then we'll have to keep trying.

The only thing that is coming to mind is that they are both using the same file simultaneously, they should really have their own copy.
If you can make a test copy and go through the process of splitting the database. Use the Database Splitter wizard under Tools/Database Utilities to quickly do this and try that.

 

[Ramu]

Set warnings off

Calvin

Thanks again

The DB is already splitted and all records are locked for Edited Records & in shared mode - But still problem!!!

Thanks
Ramu

 

[Calvin]

At this point, I'm at a loss, I would have to see it.

I'm sorry I've not been of more help.