How to implement crosstab query in Access?
Hi Shamu. A Google search would return many results. Here’s one: <a href=”http://articles.techrepublic.com.com/5100-10878_11-6121381.html”>How do I… create a crosstab query in Microsoft Access?</a>
View Answer
| September 22, 2010 1:43 PM
Access, CrossTab Query, SQL Server, SQL Server 2000
Hi Shamu. A Google search would return many results. Here’s one: <a href=”http://articles.techrepublic.com.com/5100-10878_11-6121381.html”>How do I… create a crosstab query in Microsoft Access?</a>
View Answer
| September 22, 2010 1:43 PM
Access, CrossTab Query, SQL Server, SQL Server 2000
Migrate MYSql database to SQL 2005
Microsoft has a <a href=”http://www.microsoft.com/Sqlserver/2008/en/us/migration.aspx”>conversion tool</a> available.
View Answer
| September 21, 2010 6:12 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
Microsoft has a <a href=”http://www.microsoft.com/Sqlserver/2008/en/us/migration.aspx”>conversion tool</a> available.
View Answer
| September 21, 2010 6:12 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
Trying to Design a Split Database Access 2007/SQL Server Express
There are lots of people out there that use SQL for the backend and Access for the front end. Once you do this, as long as the access front end is designed correctly there should be no performance problems. Data security is always important. You need to protect the data from outside threats as well [...]
View Answer
| September 21, 2010 5:53 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
There are lots of people out there that use SQL for the backend and Access for the front end. Once you do this, as long as the access front end is designed correctly there should be no performance problems. Data security is always important. You need to protect the data from outside threats as well [...]
View Answer
| September 21, 2010 5:53 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Changed Foxpro 2.6 .dbf file and change doesn’t show up when I run the .exe
I think u made a mistake to open the .dbf file. In this dir, there is a .bak file in the same name, just change the name from .bak to .dbf of the same file and before doing that copy the all .dbf files in a safe place. Hope u will gain….
View Answer
| September 21, 2010 6:00 AM
Database Files, FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro for DOS
I think u made a mistake to open the .dbf file. In this dir, there is a .bak file in the same name, just change the name from .bak to .dbf of the same file and before doing that copy the all .dbf files in a safe place. Hope u will gain….
View Answer
| September 21, 2010 6:00 AM
Database Files, FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro for DOS
“Network Security Engineering” vs “computer software engineering”
For the most part all degrees are created equal. It doesn’t so much matter what the degree is in as long as you have one. Now that said, having a degree doesn’t mean a whole lot once you have some real world experience under your belt.
View Answer
| September 20, 2010 4:35 PM
Computer engineering, IT careers, IT certification and training, Network security, Network Security Management, Software engineering, Software Engineers
For the most part all degrees are created equal. It doesn’t so much matter what the degree is in as long as you have one. Now that said, having a degree doesn’t mean a whole lot once you have some real world experience under your belt.
View Answer
| September 20, 2010 4:35 PM
Computer engineering, IT careers, IT certification and training, Network security, Network Security Management, Software engineering, Software Engineers
Get data from one MySQL datebase server to another in real time
Using a free MySql tool called SQLyog, ou can download the latest version of SQLyog at Webyog <a href=”http://www.webyog.com/sqlyog/download.html”>here</a> You can read their whitepaper that will go into detail on how to use the tool for real time syncing. . <a href=”http://www.databasejournal.com/sqletc/article.php/1584401/Synchronizing-Your-MySQL-Databases-Using-a-Free-MySQL-Admin-Tool—SQLyog.htm”>http://www.databasejournal.com/sqletc/article.php/1584401/Synchronizing-Your-MySQL-Databases-Using-a-Free-MySQL-Admin-Tool—SQLyog.htm</a>
View Answer
| September 17, 2010 3:24 PM
MySQL, MySQL 5.0, MySQL Database, MySQL functions
Using a free MySql tool called SQLyog, ou can download the latest version of SQLyog at Webyog <a href=”http://www.webyog.com/sqlyog/download.html”>here</a> You can read their whitepaper that will go into detail on how to use the tool for real time syncing. . <a href=”http://www.databasejournal.com/sqletc/article.php/1584401/Synchronizing-Your-MySQL-Databases-Using-a-Free-MySQL-Admin-Tool—SQLyog.htm”>http://www.databasejournal.com/sqletc/article.php/1584401/Synchronizing-Your-MySQL-Databases-Using-a-Free-MySQL-Admin-Tool—SQLyog.htm</a>
View Answer
| September 17, 2010 3:24 PM
MySQL, MySQL 5.0, MySQL Database, MySQL functions
Zipping CSV to AS/400
There are various ways to create usable .ZIP files on AS/400s. One obvious way is to purchase a 3rd-party product or utility that provides a nice, clean user interface into functions on the system or into program code that implements the algorithms used for “zipping” files. I don’t have a list of providers, but I’m [...]
View Answer
| September 16, 2010 10:12 PM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
There are various ways to create usable .ZIP files on AS/400s. One obvious way is to purchase a 3rd-party product or utility that provides a nice, clean user interface into functions on the system or into program code that implements the algorithms used for “zipping” files. I don’t have a list of providers, but I’m [...]
View Answer
| September 16, 2010 10:12 PM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
Basic Access Database query question
We would need to know your tables’ design to provide an accurate answer, but something like this will probably give you the desired result: <pre>SELECT * FROM [Early voter list] WHERE <i>voterId </i>NOT IN (SELECT <i>voterId </i>FROM [Identified Early Dems])</pre>
View Answer
| September 16, 2010 1:55 PM
Access 2003, Access Database, Access query, BASIC, SQL Query
We would need to know your tables’ design to provide an accurate answer, but something like this will probably give you the desired result: <pre>SELECT * FROM [Early voter list] WHERE <i>voterId </i>NOT IN (SELECT <i>voterId </i>FROM [Identified Early Dems])</pre>
View Answer
| September 16, 2010 1:55 PM
Access 2003, Access Database, Access query, BASIC, SQL Query
Replicating a partitioned table to a secondary server
if you only want merge it,I do suggest you using Partition Wizard to do it,because two days ago,I used it to merge my windows7 partitions,and found it is easy-to-use
View Answer
| September 16, 2010 6:18 AM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning
if you only want merge it,I do suggest you using Partition Wizard to do it,because two days ago,I used it to merge my windows7 partitions,and found it is easy-to-use
View Answer
| September 16, 2010 6:18 AM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning
SAP advice
SearchSAP has some great resources that cover <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification</a>. Hope this helps! - Melanie Kumark suggests you consult those with experience in SAP as well.
View Answer
| September 15, 2010 3:05 PM
IT careers, SAP careers, SAP certifications
SearchSAP has some great resources that cover <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification</a>. Hope this helps! - Melanie Kumark suggests you consult those with experience in SAP as well.
View Answer
| September 15, 2010 3:05 PM
IT careers, SAP careers, SAP certifications
SQL Server 2005 database design
If its what I think it is it is describing the links between you tables eg 1 – many 1 -1 0 – many many – many etc You need to read a database design book for more details ————– kccrosser ——- The values seem to be a mixture of regular expression terms and fragments [...]
View Answer
| September 14, 2010 10:48 PM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005
If its what I think it is it is describing the links between you tables eg 1 – many 1 -1 0 – many many – many etc You need to read a database design book for more details ————– kccrosser ——- The values seem to be a mixture of regular expression terms and fragments [...]
View Answer
| September 14, 2010 10:48 PM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005
Deduplication Backup strategy
You can look at the following vendors: Exagrid, FalconStor, and Data Domain. As per “additional licensing”, you would still need to purchase the hardware which in turn may require you to purchase “features” via licenses.
View Answer
| September 13, 2010 7:31 PM
Backup, Backup Strategy, Data Deduplication Software, Database Backup Strategies, Deduplication, NetBackup
You can look at the following vendors: Exagrid, FalconStor, and Data Domain. As per “additional licensing”, you would still need to purchase the hardware which in turn may require you to purchase “features” via licenses.
View Answer
| September 13, 2010 7:31 PM
Backup, Backup Strategy, Data Deduplication Software, Database Backup Strategies, Deduplication, NetBackup
Rename Clause
-> Renames is used to regroup the elementary items of a group into a new group. -> Renames should be coded with 66 level number. -> There should not be any picture class coded for 66 level number. -> The renames field will be allocated with the same memory space as defined or elementary items [...]
View Answer
| September 11, 2010 10:59 AM
COBOL, COBOL/400, Level-66, RENAME statement
-> Renames is used to regroup the elementary items of a group into a new group. -> Renames should be coded with 66 level number. -> There should not be any picture class coded for 66 level number. -> The renames field will be allocated with the same memory space as defined or elementary items [...]
View Answer
| September 11, 2010 10:59 AM
COBOL, COBOL/400, Level-66, RENAME statement
How do I use primary keys in SQL server?
No you can’t use the course to map to the teacher. You’ll need to do a many to many mapping as some teachers may be able to teach more than one subject. This would be a separate table, typically called SubjectTeacher or TeacherSubject, which has two columns subject_id and teacher_id. For each subject that a [...]
View Answer
| September 9, 2010 10:06 PM
Primary keys, SQL, SQL Server, SQL tables
No you can’t use the course to map to the teacher. You’ll need to do a many to many mapping as some teachers may be able to teach more than one subject. This would be a separate table, typically called SubjectTeacher or TeacherSubject, which has two columns subject_id and teacher_id. For each subject that a [...]
View Answer
| September 9, 2010 10:06 PM
Primary keys, SQL, SQL Server, SQL tables
Merging Excel or CSV file to Active Directory
You can use Ldifde to import that list . This is a tool included on the Windows 2000 resource cd and is installed with 2000 and 2003 server. ldifde.exe is provided natively with the W2K and W2K3 OS and is located in %systemroot%system32 This is what MS has to say about it: The LDAP Data [...]
View Answer
| September 8, 2010 3:39 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
You can use Ldifde to import that list . This is a tool included on the Windows 2000 resource cd and is installed with 2000 and 2003 server. ldifde.exe is provided natively with the W2K and W2K3 OS and is located in %systemroot%system32 This is what MS has to say about it: The LDAP Data [...]
View Answer
| September 8, 2010 3:39 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
Display External File Properties in Excel
here is a function I use for accessing a file date in Access VBA Function GetFileDate(FileName As String) As Date ‘ get the creation date for a file Dim fso As FileSystemObject Dim f1 As File Set fso = CreateObject(“Scripting.FileSystemObject”) If fso.FileExists(FileName) Then Set f1 = fso.GetFile(FileName) GetFileDate = f1.DateLastModified End If End Function
View Answer
| September 6, 2010 1:29 PM
Access 2003, Access Database, Excel 2003, External file properties, Office 2003, Windows XP
here is a function I use for accessing a file date in Access VBA Function GetFileDate(FileName As String) As Date ‘ get the creation date for a file Dim fso As FileSystemObject Dim f1 As File Set fso = CreateObject(“Scripting.FileSystemObject”) If fso.FileExists(FileName) Then Set f1 = fso.GetFile(FileName) GetFileDate = f1.DateLastModified End If End Function
View Answer
| September 6, 2010 1:29 PM
Access 2003, Access Database, Excel 2003, External file properties, Office 2003, Windows XP
SQL Express 2005 query times lagging
Odds are the problem is because the production server already has the data in cache and your workstation’s SQL Express doesn’t have the data loaded into the cache. If you run the same query a second time on the SQL Express instance does it run quickly then? If it does this is the problem. The [...]
View Answer
| September 5, 2010 4:28 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query
Odds are the problem is because the production server already has the data in cache and your workstation’s SQL Express doesn’t have the data loaded into the cache. If you run the same query a second time on the SQL Express instance does it run quickly then? If it does this is the problem. The [...]
View Answer
| September 5, 2010 4:28 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query
Special character in a PF
Use Notepad ++’s find and replace! … ================================================= Since Notepad++ has no relevance to the question, I’m replacing almost all of the previous “Answer”. The real answer is to stop allowing invalid characters from being accepted at the point of entry. If you would simply validate the input properly, it would never get into the [...]
View Answer
| September 3, 2010 7:53 AM
Database, iSeries, iSeries database, PF/LF, Physical File
Use Notepad ++’s find and replace! … ================================================= Since Notepad++ has no relevance to the question, I’m replacing almost all of the previous “Answer”. The real answer is to stop allowing invalid characters from being accepted at the point of entry. If you would simply validate the input properly, it would never get into the [...]
View Answer
| September 3, 2010 7:53 AM
Database, iSeries, iSeries database, PF/LF, Physical File
Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
First you are talking about two different database platforms Microsoft SQL Server and MySQL. There are a lot of features that are different between the two. If you are thinking about moving a database into the cloud you should look at SQL Azure which is a Microsoft SQL Server database hosted in the cloud by [...]
View Answer
| September 2, 2010 4:17 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration
First you are talking about two different database platforms Microsoft SQL Server and MySQL. There are a lot of features that are different between the two. If you are thinking about moving a database into the cloud you should look at SQL Azure which is a Microsoft SQL Server database hosted in the cloud by [...]
View Answer
| September 2, 2010 4:17 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration
DB Table/Query Layout for Ranking System
tbl_Member with MID, Name etc tbl_Rank with RID, rank_name, Description etc tbl_Member_Rank with MID, RID, Effective_From (date), Effective_To (date) When a member gets a rank, if they have a previous rank, then set their effective_to date as the current date for that record (using mid, rid parameters), and then create a new record with the [...]
View Answer
| September 2, 2010 2:02 PM
Access 2007, Access Database, Access query, Database, Query
tbl_Member with MID, Name etc tbl_Rank with RID, rank_name, Description etc tbl_Member_Rank with MID, RID, Effective_From (date), Effective_To (date) When a member gets a rank, if they have a previous rank, then set their effective_to date as the current date for that record (using mid, rid parameters), and then create a new record with the [...]
View Answer
| September 2, 2010 2:02 PM
Access 2007, Access Database, Access query, Database, Query
