Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Saving changes is not permitted (SQL Server tables)…

You upsize your tables up to the SQL Server but you used some BIT fields and/or you want to make some other table changes. So, you navigate to the first table and uncheck the *Allow Nulls* for your BIT field and make your other adjustments and you go to Save. Instead of the table saving […]

 787 total views

So you’re ready to upsize…

Here are a few tips when upsizing tables to an SQL Server that I have picked up along the way…

Make a Back-Up of your Database… (added 7.26.2013)

Need I say more?

Just say *NO* to…

…Special Characters or Symbols

These characters have meaning when used in Access and on an SQL Server. While wrapping […]

 2,799 total views