I have an Access database (containing checkboxes for Yes or No). I just converted it to a SQL 2005 database and the checkboxes tranlated into a bit datatype with a True and a False. Now, I need to link that table back to an Access 2007 database (need to make it easier for some staff here to write queries using Access). When I link the SQL 2005 table, I see a -1 and a 0.
How would I translate the -1's and the 0's to a checkbox in a linked table scenario?
Please advise.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Just to make sure I am on the same page - I checked the data type on the SQL 2005 table and it's a bit. I checked the data type on Access 2007 linked table and it shows up as 'Yes/No'. I then went ahead and created a "select *" query based on the linked table and I still see a -1 and a 0 instead of a checkbox.
Wonder what I am missing here.
'Yes/No' is the correct data type for check box column and the data is being converted correctly as SQL Server uses 1 and 0 for true and false respectively (can test by doing a select on your SQL server, should see as much) so the fact that seeing -1 and 0 means MS Access recognizes the data to be 'Yes/No' values. I will take a look in my MS Access see if I did something else by instinct that I didn't realize was necessary.
Ok, guess I just never noticed that. I looked at my Office 2007 with a linked table and did query and sure enough was showing as -1 and 0.
In design view of the query, you click in the field and on the property sheet click on the lookup tab and change the display control to 'Check Box'. Similarly, if you are not using a query and just opening the data directly in the linked table, you can use design view on the table to change the lookup --> display control for each check box style field. Defaulted to Text Box in my case which sounds like what you are seeing.
Business Accounts
Answer for Membership
by: mwvisa1Posted on 2009-08-10 at 14:50:07ID: 25064406
From what I have seen MS Access takes care of this for you as -1 is 'true' and 0 is 'false' so if you create a view (MS Access Query) to this data you should see that it converted that column to check box and that -1 rows have a check mark.