On 11 touko, 18:06, Sandroid wrote:
On 11 touko, 15:00, "PieterLinden via AccessMonster.com" u49887@uwe
wrote:

Sandroid wrote:
Access 2007. Problem is when I delete the device (which has foreign
key, ipID) from device table the IP number from IP
table (has ID, primary key) also deletes (relation 1:1). *I want to
"free" ip number when I remove device from database so IP number is
not deleted and can be used later. How to accomplish this?

I must be forgetting how to read... or not awake yet. *Do you have cascading
deletes turned on between the two tables? *If so, turn it off.

--
Message posted viahttp://www.accessmonster.com

cascading turned off - no help
referential integrity turned off - no help

which way to create the relation from IP to Device or vice versa, does
it matter?

I don't want to delete IP address from tblIP, can I make tblIP lookup
table then? how to make make sure that each ip address is used only
once?
tblIP structu ID(primary),ip, ip2, ip3, ip4.