help needed please - error 2950

[ITSpecialist]

im trying to update a macros and i get this error

macro name: 01-update employee data
condition: true
ActionName: DeleteObject
Argument: Table, BenefitHeader
Error: 2905

im not really good with access but my supervisor just passed away and this was his database. and now finance needs it. can some one please help me.

i can set up a go to meeting if needed. thank you all.

 

[CJ_London]

This link provides the answer

http://support.microsoft.com/kb/931407

I presume it is error 2950 per your header.

 

[ITSpecialist]

thank you for rply, im going to re try this, i did this earlier but to no avail .ill keep you posted.

 

[CJ_London]

the attached may also help

 

[ITSpecialist]

hello ty very much for the helpful zip file. i have performed all these settings im going to test it now . i got this error as well . just as an fyi

 

[CJ_London]

this error message tells you exactly what the problem, there is a misspelling of the object or the object does not exist.

Given your original post

Table, BenefitHeader

does this table exist or is it spelt differently?

 

[ITSpecialist]

would you kindly look at this errors and guide me where the issue may be? thank you so much for your willingness to help

 

[ITSpecialist]

yes it does exist. and it look the same in syntax. from what i can tell

 

[CJ_London]

these are all telling you the object does not exist. You say it does - please can you send me an image proving it

 

[ITSpecialist]

yes sir , how would i do this?

 

[CJ_London]

On the left of the access screen, click on tables to see the list of tables - then take a screenshot as you have done before.

 

[ITSpecialist]

thank you illl do this now

 

[ITSpecialist]

here is the table view

 

[cpberg1]

On the far left under the heading all access objects expand the "tables", (in the jpg "macros" is expanded) ensure you have one called benefitheader.

 

[CJ_London]

you are showing me the macros - you need to click on tables at the top

 

[ITSpecialist]

here we go. i think its right

 

[ITSpecialist]

2950tablemiss

thankyou for helping me on this gentlemen

 

[CJ_London]

There is your problem - none of the tables are called BenefitHeader - they are all called BenefitHeader1, BenefitHeader10, BenefitHeader11 etc. - looks like that are produced every 10-15 days.

I wouldn't like to guess as to why you have so many copies - presumably it is a regualr update of some kind.