Printable View
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:
Quote:
The record cannot be deleted or changed because the table "Titles" include related records.
nobody???
???
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.
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.Quote:
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)?
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 :)
Actually, I have vb6.0 pro and I am using access 2002. Will vb version be compatible with access xp database?
I think so... never tried the XP-version though.. but i think eiSecure did it a while back.