RE: delete row blocked by non-existant relationship

Leslie:

I'm going to guess that there is still a relationship out there, somewhere.
You could try to look up dependencies, and see if it is there.

As an option, you could create a second field, with all the correct
information, and switch it to the PK, and then remove the offending field.
However, I would expect Access to tell you it needs to delete a relationship
to do so. And I expect you will find the broken relationship as you begin
testing the db.

Good luck.

Sharkbyte



"Leslie S." wrote:

> Running Access 2003 on Windows 2000.
>
> I have developed a database, no data in it yet. Once I was almost finished
> with my basic design, I had to change the field name and size that I am using
> for my primary key in one table and delete the unused field of the same name,
> size, type from another. I checked the relationships window and selected show
> all relationships. In the first table, no relationships had been established
> yet. In the second table one relationship exists but not to the field in
> question.
>
> Next, I opened the first table in design view. I changed the name of the
> variable and then tried to change the size of the field. An error message
> popped up telling me I couldn't change the size of the field because of a
> relationship that had been established. It told me to modify the relationship
> in order to make the change.
>
> In the second table I tried to delete the field and received the same error
> message.
>
> I double checked the relationship window and it was exactly as I stated
> above.
>
> On an off chance the last thing I did was select Tools > Database Utilities
> > Compact and Repair Database. No change.
>
> Please help. I can recreate these tables but would rather not.
.

Relevant Pages

  • delete row blocked by non-existant relationship
    ... with my basic design, I had to change the field name and size that I am using ... An error message ... I double checked the relationship window and it was exactly as I stated ... On an off chance the last thing I did was select Tools> Database Utilities ...
    (microsoft.public.access.tablesdbdesign)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Cannot open my own Databases
    ... Windows Administrator and loads each of these service packs. ... If I have guessed correctly about the error message you see, ... See http://www.QBuilt.com for all your database needs. ... it's possible that the correct workgroup information file ...
    (microsoft.public.access.security)
  • RE: Form loading error
    ... Compact and repair your database; ... I just noticed that I get the same error message when I close the ... An error occured while loading Form_FrmXYZ. ... This Form (XYZ) is not the switchboard nor is it set to auto open. ...
    (microsoft.public.access.formscoding)