deleting a record from the database

[abdul]

I get an error message when I try to delete a record from an access made table.
I am using "Biblio.mdb" and whenever I try to delete a record, it gives me the following record:

The record cannot be deleted or changed because the table "Titles" include related records.

[abdul]

nobody???

[abdul]

???

[peet]

Open the database in access, and look at the relationships.

There will be relation between the Titles table and one or more other tables.

What vb is telling u is that u have to delete all the records in the related tables before u can delete the record in question.

[abdul]

So, it means that it depends on the type of database?
Do you have any link to other .mdb database that I can use to just create a simple database example program(Add,delete,search,sort,filter records)?

[peet]

Originally posted by abdul
So, it means that it depends on the type of database?
Do you have any link to other .mdb database that I can use to just create a simple database example program(Add,delete,search,sort,filter records)?

It depends on how the relationships (if any) has been built.

I seldom use it, because of this

I u have Access installed, u can just create one, or just remove the relationships in the biblio db or delete the related records before u delete the recs in the table in question.

Or I can mail u a db with some data in it, for u to test on

[abdul]

Actually, I have vb6.0 pro and I am using access 2002. Will vb version be compatible with access xp database?

[peet]

I think so... never tried the XP-version though.. but i think eiSecure did it a while back.