D
Doug B
I am trying to find out why a delete query that has worked well for months
has suddenly stopped working. I am getting the message "Could not delete
from specified tables.
Here is the SQL
DELETE [Beginning MEDICAL ONLY Inventory].*, [CURRENT ALL CLAIMS].[WC Claim
Type]
FROM [CURRENT ALL CLAIMS] INNER JOIN [Beginning MEDICAL ONLY Inventory] ON
[CURRENT ALL CLAIMS].[Claim Number] = [Beginning MEDICAL ONLY
Inventory].[Claim Number]
WHERE ((([CURRENT ALL CLAIMS].[WC Claim Type])="IN"));
When I look up the error in the help it says the database could be set to
read only but I am the original creator of the database and I am the only
user.
Any help would be greatly appreciated.
has suddenly stopped working. I am getting the message "Could not delete
from specified tables.
Here is the SQL
DELETE [Beginning MEDICAL ONLY Inventory].*, [CURRENT ALL CLAIMS].[WC Claim
Type]
FROM [CURRENT ALL CLAIMS] INNER JOIN [Beginning MEDICAL ONLY Inventory] ON
[CURRENT ALL CLAIMS].[Claim Number] = [Beginning MEDICAL ONLY
Inventory].[Claim Number]
WHERE ((([CURRENT ALL CLAIMS].[WC Claim Type])="IN"));
When I look up the error in the help it says the database could be set to
read only but I am the original creator of the database and I am the only
user.
Any help would be greatly appreciated.