• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

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
0
Sasha42
Asked:
Sasha42
  • 6
  • 4
  • 2
  • +3
1 Solution
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 6
  • 4
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now