Lesson 12 Data Exchange

Do a search on the Internet: what are the limitations of exchanging database objects and text using Access 2003?

Items being exchanged may not always be compatible with each other and this may limit text exchanges with Access. Also when using mail merge within WORD, only tables and queries are acceptable formats for Access objects. It seems easier to export information from Access than to import information but it really depends on the programs being used to exchange database objects and text.

Is there anything you cant do?

You are not able to append imported data into existing tables, you must first import the table and then run an append query to add the information to the other table. You will get error messages if you try to do it any other way. When importing a form, you must be sure to include everything that is involved with that form which may include tables or queries. Failure to include all components of the form will result in error messages and failure to access the form as intended.

Why?

Access reads information used in other programs differently and some items may not be compatible.

What are the complications associated with sharing Access data and objects in a multi-user environment?

It can compromise the data in the database and there is less security when the information is shared between users. Also, setting up the right amount of security for each user so that they can do what they need to do within the datasheets. Adding new users and taking away users from the group can also cause complications.