In a recent forum message, Campwood wrote:

"I have Access 2010, but do not have the Access Open screen that permits one to open a table in exclusive mode. When I click on the OPEN button, under the FILE column, I get a regular Windows open screen. Do you know why my recently purchased ACCESS 2010 software would be missing that open screen?"

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!

Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks. Some of the core benefits of this technology include:

• Precompiled execution
• Reduced client/server traffic
• Efficient reuse of code
• Programming abstraction
• Enhanced security control

Read the full story: SQL Server Stored Procedures

Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Read the full story: Installing SQL Server 2012 Express Edition

In a recent forum message, DeppG wrote:

"I am having a database with thousands of records , so if any record is changed, I want to know the specific record that has been updated , I cannot use forms, I tried Timestamp , but it does not update if any existing row is updated, it works only once for the new row only. Is there any way if any row is edited and i can get to know which row had been updated."

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!