Is there a way to change the permissions of a table (or other object)
via an SQL statement?

UPDATE TEST_Table AS T SET T.Comments = Replace([Comments],"*","")
Error I am getting is cannot update due to conversion type failure.
Comments is a memo field.
Many fields are empty. Some fields contain just text.  Many fields look like

Hi.  At my company, we have an internal application for updating access
databases.  It allows the user to select an access database to update
and a text which contains a series of SQL statements to be executed on
the database.

Hello all people.
I am running into some problems with a query. Basically what I want to
pull out from a table are all contract dates that ended 6 months from
todays date. So in a nutshell I am filtering out 6 months of past data

I want to compute taxes on salaries in a test access payroll query.
Conditions are as follows:
salary is a calculated field in the query and is monthly.
It must be converted to annual-salary(salary*12) before computation based on

I have a table that displays  some advert costs for an agency.
one colum is 'order total'
i can get total for all orders but cannot filter on a date range
i think the sum query should be used to do the calculation on the fly

I've got a table with the following structure (I realize it's not properly
normalized, but I plan to do that after I get this problem solved):
tblRatingData
-------------

I'm trying to put together a business sources report for my real estate
database.
The problem I am having is a result of the requirements of the report.
The report needs to show the total number of each business source for

The following operation in a query, expenses/sells generates the following
msg: Divide by zero error encountered. I would imagine it's because some
fields have 0s (no expenses or sells). How do I get around it?
TIA

I'm trying to delete all records in a table called "Temp_Person" from a
larger table called "Entity_Contact_Join."
Both tables contain two primary key fields "Entity ID" and "Contact ID," so
basically what I'm trying to say is delete every record from

My append query will not append ALL of my records, due to key violations.  I
had a multi-field primary, but during experimenting, I took it off.  I STILL
get key violations for all 10,526 records, and all of my indexed fields allow
duplicates.  What else could it be?

I have some code which should import data from an Excel Worksheet, but
it's not quite working.
The user is prompted to enter a workbook, a worksheet name and then
(via some other code) the columns for two fields to import.  So before

I have a query "Q2" that depends on data generated by query "Q1". Query SQL
is at bottom of message.
Q1 has a field that calculates the difference between two weeks of inventory
levels to produce a sales quantity figure for that period.  If the current

typical yes/no......turns to .....0/-1.....but this is in a Union....i can't
find a way to edit the format properties in the UNION....any ideas....and if
the idea is some code...please explain where to go to write in the
code....i'm not and brand newbie....more like a pretty dumb ...

I already have a field in my database with a complete date (month, day,
year) in Date/time format. I'm trying to build an expression in a query to
pull the month from that date and put it in a new field. I've tried fooling
around with the date/ time built in functions with no ...