Access 2007 db works differently on computers

I created an Access 2007 database on my computer.  When I send it to my client (the also have Access 2007) they get an error that I do not get.  It works fine on my computer. Help!

They get a Cannot delete from specified tables error at this line of code:
DoCmd.SetWarnings False
DoCmd.RunSQL ("Delete * from tblSecurityHospitalAccess")

I created a query instead and they get an Operation must use an updateable query error message:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryDeleteSecurityHospitalAccess", acViewNormal
Sasha42Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
Is this a spilt (front end/back end) database?

My first thought would be that you need to refresh or correct links to tables in the Back End for this user.
0
mbizupCommented:
Also make sure that the user has full permissions (read/write/execute/delete) privileges on the folder that the database/ back end is stored in.
0
clarkscottCommented:
Remove the setwarnings false and see what it tells them....

Scott C
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

mbizupCommented:
Another thought... If tblSecurityHospitalAccess is a table that you have recently added while developing this database at your own location, make sure that you have also added it to the back-end at the client's location
0
Jeffrey CoachmanMIS LiasonCommented:
1. Also, consider doing the delete in a different manner...

CurrentDB.Execute "Delete * from tblSecurityHospitalAccess"


2. Just curious.. can the user open tblSecurityHospitalAccess directly and delete records...?
0
Sasha42Author Commented:
That database is not split.  I have created a new database and imported all the objects.  They still get the error. Docmd.setwarnings has no bearing on it.
0
mbizupCommented:
Have you verified the folder permissions and that tblSecurityHospitalAccess is indeed there and usable (not corrupted for instance)?

If this is a shared database, you should consider splitting it after resolving this (helps prevent corruption, and a multitude of other problems).

Is this problem consistent for all users, or does it vary?
0
Sasha42Author Commented:
Yes, I will split it out after it is tested.  I sent it to another client on a different server and they get the same error message too.
0
mbizupCommented:
Again, verify that the table is there and not corrupted...

Make a backup and compact/repair the database.
0
Sasha42Author Commented:
I have compacted and repaired, created a blank database and imported all the objects, completely rebuilt the problem table.  The properites show under attributes that it is not read only. Could it have something to do with their security settings?  Thanks so much for your help.
0
mbizupCommented:
Possibly - your users should have read,write,execute and delete privileges on the folder your database resides in.
0
Sasha42Author Commented:
The database is not on network.  I send a zipped copy of the database to the client for testing.
0
peter57rCommented:
Users must have full permissions on the FOLDER containing the database, otherwise it becomes read only.

Can you users save say, an Excel file into the database folder , and also delete it from that folder?
0
Jeffrey CoachmanMIS LiasonCommented:
0
datAdrenalineCommented:
>> I send a zipped copy of the database to the client for testing. <<

Please ensure that your client is EXTRACTING the database file from the Zip folder you are sending them!   If the client opens the database within the Zip folder, it is Read-Only and you will get errors like you are seeing.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.