By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

How Common are Work-Arounds?

Sandboxer
P: 11
I created a table "Contacts". In the table I included a look-up field so that I could look up and select "CompanyName" for each Contact.

Sometime later I must have changed the Data Type of "CompanyName" from Text to Number, Long Integer. Afterwards when I would create a report it was impossible to get the report to sort by "CompanyName" alphabetically, because it was sorting by ID number. I tried to change it back to text. I tried to delete it from "Contacts" and re-insert it. Nothing doing. Access kept telling me that "CompanyName" belonged to one or more relationships and I had to delete the relationships. I deleted all relationships and Access tells me there is still a relationship. YiKeS.

My work-around was to create a NEW "CompanyName" look-up field in my "Contacts" table with a slightly different name, and with the correct Data Type of Text. Then I re-established relationships, and presto! was able to create alphabetically ordered reports, etc. with the caveat that I have to make the bad field invisible every time, or not include it.

So...my questions are: Are these sort of work-arounds common to Access? Is there such a thing as a pristine database? Is there a way to delete my bad "CompanyName" field from "Contacts" or am I stuck with it forever?

Thanks!
Nov 7 '07 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,365
It always depends on the person. For me, if I'm still in the development process I'll choose to redesign the structure rather than use a workaround. But once it's live, I'll go for a workaround instead.

As for your relationship problem, maybe your database is corrupt, have you tried a compact and repair?
Nov 8 '07 #2

Sandboxer
P: 11
It always depends on the person. For me, if I'm still in the development process I'll choose to redesign the structure rather than use a workaround. But once it's live, I'll go for a workaround instead.

As for your relationship problem, maybe your database is corrupt, have you tried a compact and repair?
No ... good idea. I'll give it a go.
Nov 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.