Prev: Design Mode Button?
Next: DB guide
From: gmg on 13 Dec 2009 19:19
I have used the Access Documenter to list the indexes in my tables.
Several of the tables have an Index that looks like it's in Hexidecimal.
Ex: C1D060E6-4206-11D7 etc.
I never created it and don't know what it's for.
When I migrate to SQL Server, there is a warning that it could cause a
conflict.
Does anyone know where this index could have come from?
If it isn't necessary, how can I remove it?
Thanks
From: Allen Browne on 13 Dec 2009 21:17
When you create a relationship with referential integrity (RI) enforced,
Access creates a hidden index to manage the RI. It attempts to create an
index name such as Table1Table2. If that name is taken, it uses a GUID
(globally unique identifier.) Looks like what you struck.

You can't remove the relationship and leave the RI intact. You could remove
it, and then enforce the rule in SQL Server.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"gmg" <gmg(a)discussions.microsoft.com> wrote in message
news:7DBD11DE-72F8-4437-AC02-7507DEF69F00(a)microsoft.com...
> I have used the Access Documenter to list the indexes in my tables.
> Several of the tables have an Index that looks like it's in Hexidecimal.
> Ex: C1D060E6-4206-11D7 etc.
> I never created it and don't know what it's for.
> When I migrate to SQL Server, there is a warning that it could cause a
> conflict.
> Does anyone know where this index could have come from?
> If it isn't necessary, how can I remove it?
> Thanks

 | 
Pages: 1
Prev: Design Mode Button?
Next: DB guide