Questions to ask about Access / SQL Server conversion

1. Problem with Booleans in combo boxes after converting SQL Server 7.0 data
to Access 2000 data.
In a SQL Server 7.0 you use a bit as a Boolean. A bit can have the values
0 or 1. After converting the SQL Server data to Access data the values have
changed to 0 or –1.
How do I turn these values to ‘Yes’ or ‘No’ in combo boxes?

2. Problem with Autonumber in Access GUI after converting SQL Server 7.0
data to Access 2000 data.
When you create a new post in Access (using a Access GUI) you can show the
autonumber or identity field of that post at once, while in SQL Server you
can’t.
Is there an easy way to solve this problem without a lot of programming work
in the GUI?

3. Problem with assignments in Access GUI after converting SQL Server 7.0
data to Access 2000 data.
When using an Access DB you can assign a variable the value of an autonumber
or identity (see problem number 2) before the post is saved, while in SQL
Server you can’t. The variable will therefore not get a value.
How to solve this problem in the easiest way?