can not rerun Make table query - say has to delete prev.

B

babs

I set up a make table query to get a List of Jobs that I care about
scheduling for the month - at the end of each Day I would like to update and
Over write this with a New list of Jobs that I care about - the make table
that I am creating is calls JobstoSched when I try and rerun the make table
query it gives me an error- You can't delete the table JobstoSched; it is
participating in one or more relationshiops. I went to the relationships
window an delted the only line there was. I am using this table to populate
a dropdown list of jobs to sched. - not sure why I can't reMake the table
when all forms and queries are closed-?? what am I missing???

Thanks,
Barb
 
J

Jeff Boyce

Barb

Rather than start over each time from scratch, what about the idea of
defining the table structure one time, then using a pair of queries to first
delete the "previous" records and then append the "new" records? That way,
you may not be running afoul of table interrelationships.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
K

KARL DEWEY

You probably have a join in a query. Even then Access will not overwrite the
table, it will just create another with a suffix '_1' the first time and '_2'
the next.

Did you try running a delete query then an append instead?

Why a table instead of a report?
 
B

babs

I am populating a dropdown list for a list of JOBs that I want to schedule.
The LIst is generated from a query based on Many parameters queries prompting
for jobs invoice dates, material dates, Write-up dates and one more all start
and finish dates. I did not want to base the drop down off the this crazy
query because I don't want the user to have to INPUT all of these date sets
Each time they have to choose from the dropdown list.

Would an append work to the original Make table???

Thanks,
Barb
 
K

KARL DEWEY

You append (add records) to an existing query. If you have successfully run
the query and made the table you can create delete query to remove the
records and then add new records.
 
B

babs

Thanks got it - Makes sense!!
Barb

KARL DEWEY said:
You append (add records) to an existing query. If you have successfully run
the query and made the table you can create delete query to remove the
records and then add new records.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top