Many times, database administrators find it necessary to link two remote databases to each other for the purpose of sharing data. Oracle provides database linking technology that makes this a breeze. In a tip on SearchOracle.com, Brian Peasland explains how you can create such a link between two Oracle databases.

Read the full article: How to Create a Database Link in Oracle

The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or debit card transactions. These requirements stem from a series of affecting databases of consumer credit information over the past decade.

What does PCI DSS mean to you as a database professional? If you review the PCI DSS standard, you’ll find seventeen pages packed with detailed requirements for securing cardholder information. If your organization processes transactions, it’s a good idea to review the entire standard and ensure you’re meeting all of those requirements.

Read the full article: PCI DSS for Database Professionals

Photo by Avatar

In a recent forum posting, Brainhose wrote:

"I did an install of Access 2000 on my PC that already had Word and Excel 2000. Even though I selected to install Access VBA help, it will not work and always asks me to install the feature. I've been Googling the problem for 3 days and can't find an answer. Anyone have a clue?"

Can you help Brainhose? Interested in solutions to the same problem? Visit our forum and join the discussion!

The video collection database template, available for free from Microsoft, allows you to track your entire video collection. It includes fields for program name, program length, program type and the actors involved.

Download the: Video Collection Database Template

In a recent forum posting, Brainhose wrote:

"I sometimes run code to maintain data which deletes tables or queries and then recreates them. The Access 2007 interface doesn't seem to refresh properly so that the newly recreated objects show in the side bar. Has anyone seen a procedure for forcing the GUI to refresh?"

Can you help? Interested in solutions to the same problem? Join the forum discussion for more!

We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on:

• EuroConvert()
• Exp()
• FV()

This music collection database template from Microsoft's Office Community allows you to track your music collection by recording name, artist, genre, label, year released and other criteria.

Download the template: Music Collection Database

The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser software. If you're security-conscious, you've undoubtedly spent a significant amount of time setting appropriate security permissions on your databases and web servers. Have you also considered the security of the code that powers the database-web interface?

One common type of database attack, SQL Injection, allows a malicious individual to execute arbitrary SQL code on your server.

Read the full article: SQL Injection Attacks

In a recent forum posting, Brainhose wrote:

"Anyone have a code snippet for calling the ODBC dialog so an Access user can select the DSN they wish to use? I know it's possible."

Can you help Brainhose? Interested in solutions to the same problem? Visit our forum and join the discussion.

User-level security is quite powerful. It allows you to control the types of data that a user might access (for example, prohibiting sales personnel from looking at accounting data) and the actions they can perform (e.g. only allowing the HR department to change personnel records).

Read the full article: Getting Started with User Level Security in Microsoft Access