Posted
by Vivek Chandraprakash
on Stack Overflow
See other posts from Stack Overflow
or by Vivek Chandraprakash
Published on 2010-04-05T01:22:55Z
Indexed on
2010/04/05
1:33 UTC
Read the original article
Hit count: 323
is it possible to restore deleted records in MDB?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and…
>>> More
as seen on Super User
- Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files.
In one case, the user has 2007 on his PC and opend the front end in 2007. No problems.
When the the user is done, he clicks a button that executes a macro full of update queries. The macro…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products.
>>> More
as seen on ASP.net Weblogs
- Search for 'ASP.net Weblogs'
If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments.
with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'
If logical file name…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently.
Here is a quick definition of the subject from Book On Line:
A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version?
-Vivek
>>> More
as seen on Server Fault
- Search for 'Server Fault'
When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA is properly mapped to the right Windows user in the database. After the Restore, Web_SqlA is still…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version?
>>> More
