We have a MS Access 2007 database that we want to convert. The DB has over 80 tables and a bit over 210 queries.
We would like to have a SQL 2005 database with the same structure as the MS Access. We don't know if there is any 'Upgrade' tool to actually do a transfer like this or we just create the DB and create each of every tables & queries.
The final product is having the data in Access in SQL exactly and functional.
What considerations and method should we look at when performing a project like this?
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …