I have to add new records to both tables at the same time, otherwise they won't have a relationship.<BR><BR>See table1 I add a new entry and therefore I have to add a new entry to table2 as well ...

Select each table you want to copy from the SQL Server database to your Access database. Choose "OK" to start the import and then "Close" when the import is complete.

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

Hopefully someone has a little experience with this. <BR><BR>Here is the setup:<BR>I've got an old access database that stores purchasing information from a system we used for the past 10 years.

How to Encrypt or Decrypt Data in Access Tables. If your business uses Microsoft's Access database software to manage sensitive data, you'll want to encrypt your database and its tables to prevent ...