How do I copy an Access 2003 database and table?
I am a little confused by the question. Are you able to get into the database at all? If so, you can do a file save as and just rename the database whatever you want it to be. If you have started the creation of a new database and would like to copy the tables [...]
View Answer
| October 27, 2010 8:42 PM
Access 2003, Access Database, Access Functions, Access Tables
I am a little confused by the question. Are you able to get into the database at all? If so, you can do a file save as and just rename the database whatever you want it to be. If you have started the creation of a new database and would like to copy the tables [...]
View Answer
| October 27, 2010 8:42 PM
Access 2003, Access Database, Access Functions, Access Tables
Green Boxes in Access 2007 form after deleting O’s & 1′s from database
The green boxes are shading indicating that the value is null currently because you cleared out the value. A check box object is either yes or no / true or false / -1 or 0. If you want a count checked values you need to count where the value is true only. Ex. Say you [...]
View Answer
| October 27, 2010 2:03 PM
Access, Access 2007, Access 2007 forms, Access 2007 functions, Access Database
The green boxes are shading indicating that the value is null currently because you cleared out the value. A check box object is either yes or no / true or false / -1 or 0. If you want a count checked values you need to count where the value is true only. Ex. Say you [...]
View Answer
| October 27, 2010 2:03 PM
Access, Access 2007, Access 2007 forms, Access 2007 functions, Access Database
Windows Terminal Server 2008 timing out at client’s computer
First things first make sure that port 3389 in bound and outbound for tcp and udp are opened on your firewall for this machine. If it is then I would run a tracert from the effected machine like this: tracert terminalserver replacing terminalserver for the actual fqdn or ip address of the terminal server. If [...]
View Answer
| October 26, 2010 7:21 PM
Routers, Terminal Server 2008, Timeout, Windows 2008 Terminal Server, Windows Server 2008, Windows Terminal Server
First things first make sure that port 3389 in bound and outbound for tcp and udp are opened on your firewall for this machine. If it is then I would run a tracert from the effected machine like this: tracert terminalserver replacing terminalserver for the actual fqdn or ip address of the terminal server. If [...]
View Answer
| October 26, 2010 7:21 PM
Routers, Terminal Server 2008, Timeout, Windows 2008 Terminal Server, Windows Server 2008, Windows Terminal Server
Multiple identical relationships in one Access 2007 table
You want to create a table with a two column primary key. <pre>CREATE TABLE HouseHoldVolunteer (HouseHoldId INT, VolunteerId INT CONSTRAINT PK_HouseHoldVolunteer (HouseHoldId, VolunteerId)) </pre> This way you can have multiple volunteers for each household. You then need a HouseHold table which contains the information about each household.
View Answer
| October 26, 2010 4:03 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
You want to create a table with a two column primary key. <pre>CREATE TABLE HouseHoldVolunteer (HouseHoldId INT, VolunteerId INT CONSTRAINT PK_HouseHoldVolunteer (HouseHoldId, VolunteerId)) </pre> This way you can have multiple volunteers for each household. You then need a HouseHold table which contains the information about each household.
View Answer
| October 26, 2010 4:03 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions
To change career path
It is good for u and there r lots of hopes on ur way ! See, if u want to join IT there r mainly two ways either u join as sw developer nor as system admin or DBA admin. Though u completed B.Tech, so u may go for sw developer or DBA admin. for [...]
View Answer
| October 25, 2010 6:55 AM
IT career planning, IT careers, IT certification and training
It is good for u and there r lots of hopes on ur way ! See, if u want to join IT there r mainly two ways either u join as sw developer nor as system admin or DBA admin. Though u completed B.Tech, so u may go for sw developer or DBA admin. for [...]
View Answer
| October 25, 2010 6:55 AM
IT career planning, IT careers, IT certification and training
What have you done to stay up to date in your area or career?
The q is very much welcomed. I think, the first three points i.e. Follow the industry….., Take certifications…. and Learn from your….. are co-related to each other. When any person takes certification he/she must consider the current industry scenario. Because his/her employment depends according to his /her working capacity, knowledge on the same area (which [...]
View Answer
| October 25, 2010 5:52 AM
Career development, IT career development, IT career planning, IT careers
The q is very much welcomed. I think, the first three points i.e. Follow the industry….., Take certifications…. and Learn from your….. are co-related to each other. When any person takes certification he/she must consider the current industry scenario. Because his/her employment depends according to his /her working capacity, knowledge on the same area (which [...]
View Answer
| October 25, 2010 5:52 AM
Career development, IT career development, IT career planning, IT careers
Beginning DB2 programming in mainframes
Mainframe = IBM z/OS so DB2 on mainframe = IBM DB2 for z/OS How to get started in programming for DB2? First, do you already have programming skills? Are you a programmer? If not, first need to learn that. COBOL or Assembler or even Java. Next, learn about relational database management system (RDBMS) theory. This [...]
View Answer
| October 22, 2010 6:45 PM
DB2, DB2 administration, DB2 configuration, Mainframe, Mainframe programming
Mainframe = IBM z/OS so DB2 on mainframe = IBM DB2 for z/OS How to get started in programming for DB2? First, do you already have programming skills? Are you a programmer? If not, first need to learn that. COBOL or Assembler or even Java. Next, learn about relational database management system (RDBMS) theory. This [...]
View Answer
| October 22, 2010 6:45 PM
DB2, DB2 administration, DB2 configuration, Mainframe, Mainframe programming
MS Access 2007 IIF expression
I finally got it to work. I had to create an initial query to pull all court dates greater than today’s date. Then I tie that query into another query to pull just the first court dates and that gave me the correct # of records. thank you to everyone for their assistance.
View Answer
| October 20, 2010 5:00 PM
Access 2007, Access 2007 functions, Access query, IIF function
I finally got it to work. I had to create an initial query to pull all court dates greater than today’s date. Then I tie that query into another query to pull just the first court dates and that gave me the correct # of records. thank you to everyone for their assistance.
View Answer
| October 20, 2010 5:00 PM
Access 2007, Access 2007 functions, Access query, IIF function
SAP in IT
For Fees and Location in Mumbai : http://www.sap.com/asia/services/education/schedule/schedule_IN.htm OR BrentSheets provided some good resources that may be helpful to you in this other SAP Career prospects question. Follow this link : http://itknowledgeexchange.techtarget.com/itanswers/career-prospects-for-sap-fico-consultant/ hope it may help u Good Luck !
View Answer
| October 20, 2010 10:48 AM
IT career development, IT careers, SAP careers, SAP certifications, SAP IT, SAP training
For Fees and Location in Mumbai : http://www.sap.com/asia/services/education/schedule/schedule_IN.htm OR BrentSheets provided some good resources that may be helpful to you in this other SAP Career prospects question. Follow this link : http://itknowledgeexchange.techtarget.com/itanswers/career-prospects-for-sap-fico-consultant/ hope it may help u Good Luck !
View Answer
| October 20, 2010 10:48 AM
IT career development, IT careers, SAP careers, SAP certifications, SAP IT, SAP training
Need some detail about SAP course
Hi u may go for as told by EmNichs and as BrentSheets provided the link. Here I am providing more one link : http://www.sap.com/services/education/index.epx Bye !
View Answer
| October 20, 2010 10:39 AM
IT career development, IT careers, SAP, SAP certifications, SAP modules, SAP training
Hi u may go for as told by EmNichs and as BrentSheets provided the link. Here I am providing more one link : http://www.sap.com/services/education/index.epx Bye !
View Answer
| October 20, 2010 10:39 AM
IT career development, IT careers, SAP, SAP certifications, SAP modules, SAP training
Migrating MySQL hosts
According to the <a href=”http://dev.mysql.com/doc/refman/5.5/en/copying-databases.html”>official documentation</a>: “The easiest (although not the fastest) way to move a database between two machines is to run the following commands on the machine on which the database is located: <pre>shell> mysqladmin -h ‘other_hostname’ create db_name shell> mysqldump db_name | mysql -h ‘other_hostname’ db_name</pre> If you want to copy a [...]
View Answer
| October 19, 2010 5:29 PM
Backup and restore, Host management, MySQL, MySQL backup, MySQL Database
According to the <a href=”http://dev.mysql.com/doc/refman/5.5/en/copying-databases.html”>official documentation</a>: “The easiest (although not the fastest) way to move a database between two machines is to run the following commands on the machine on which the database is located: <pre>shell> mysqladmin -h ‘other_hostname’ create db_name shell> mysqldump db_name | mysql -h ‘other_hostname’ db_name</pre> If you want to copy a [...]
View Answer
| October 19, 2010 5:29 PM
Backup and restore, Host management, MySQL, MySQL backup, MySQL Database
Connecting a database in a linux system from a windows system through oracle 10g
Hey you can connect to your MS Access database through ODBC. Only thing is even Oracle database server should be installed on the same machine. Configure the Listener on the oracle server with required details about MS Access server, the same procedure should be adopted for MS Access server. TNS Ping should be done to [...]
View Answer
| October 19, 2010 2:40 PM
Database connectivity, Linux, Linux servers, Oracle 10g, Remote connection, Windows connections
Hey you can connect to your MS Access database through ODBC. Only thing is even Oracle database server should be installed on the same machine. Configure the Listener on the oracle server with required details about MS Access server, the same procedure should be adopted for MS Access server. TNS Ping should be done to [...]
View Answer
| October 19, 2010 2:40 PM
Database connectivity, Linux, Linux servers, Oracle 10g, Remote connection, Windows connections
New Windows Server 2008 on network
yes you can
View Answer
| October 19, 2010 2:15 PM
Shared databases, Windows Server 2008, Windows Server 2008 Directories, Windows Upgrades, Windows Vista Home Premium, Windows XP Home
yes you can
View Answer
| October 19, 2010 2:15 PM
Shared databases, Windows Server 2008, Windows Server 2008 Directories, Windows Upgrades, Windows Vista Home Premium, Windows XP Home
Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0
I have the same issue
View Answer
| October 18, 2010 1:56 PM
CSV, CSV input file, Oracle E-Business Suite, SQL
I have the same issue
View Answer
| October 18, 2010 1:56 PM
CSV, CSV input file, Oracle E-Business Suite, SQL
Converting text to number for calculation in Access 2003
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 5:53 PM
Access, Access 2003, Access 2003 forms, Access Functions
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 5:53 PM
Access, Access 2003, Access 2003 forms, Access Functions
Keep the “first” value using groupby – MYSQL
In MySql, you will probably need to do something like this: <pre>alter table yourTable add colX char; update yourTable t set colX = (select min from (select col2,min(col1) min from yourTable group by col2) temp1 where col2 = t.col2);</pre> Note that this may work, but it won’t be efficient. The inner subquery is needed because [...]
View Answer
| October 14, 2010 8:30 PM
GROUP BY statement, MySQL, MySQL Database, MySQL functions
In MySql, you will probably need to do something like this: <pre>alter table yourTable add colX char; update yourTable t set colX = (select min from (select col2,min(col1) min from yourTable group by col2) temp1 where col2 = t.col2);</pre> Note that this may work, but it won’t be efficient. The inner subquery is needed because [...]
View Answer
| October 14, 2010 8:30 PM
GROUP BY statement, MySQL, MySQL Database, MySQL functions
Copy a SQL Binary Large Object (BLOB) from one database to another
I don’t know what you are trying to do. I suppose it is some kind of test. Also, I don’t see much relation between the question title and the code you posted. <b>You are getting the error because your source blob is null.</b> I would recommend taking a look at this: <a href=”http://soft.buaa.edu.cn/oracle/bookshelf/oreilly/bipack/ch08_03.htm”>DBMS_LOB Interface</a> But [...]
View Answer
| October 14, 2010 7:56 PM
Binary Large Object, BLOB, SQL, SQL Database Transfer
I don’t know what you are trying to do. I suppose it is some kind of test. Also, I don’t see much relation between the question title and the code you posted. <b>You are getting the error because your source blob is null.</b> I would recommend taking a look at this: <a href=”http://soft.buaa.edu.cn/oracle/bookshelf/oreilly/bipack/ch08_03.htm”>DBMS_LOB Interface</a> But [...]
View Answer
| October 14, 2010 7:56 PM
Binary Large Object, BLOB, SQL, SQL Database Transfer
Are you worried about IT job security?
I think its just redefining some of those IT jobs being done inhouse and out sourcing them probably to meet business objectives – its still same old wine in a new bottle. But my fear is that IT professional in employment will take the bashing once they have little less challenging jobs to do and [...]
View Answer
| October 13, 2010 1:40 PM
Cloud Computing, IT careers, IT job situation, IT jobs, Open IT Forum, Outsourcing, Outsourcing services, SaaS
I think its just redefining some of those IT jobs being done inhouse and out sourcing them probably to meet business objectives – its still same old wine in a new bottle. But my fear is that IT professional in employment will take the bashing once they have little less challenging jobs to do and [...]
View Answer
| October 13, 2010 1:40 PM
Cloud Computing, IT careers, IT job situation, IT jobs, Open IT Forum, Outsourcing, Outsourcing services, SaaS
DLookup or IIF statement?
Do it as one SQL update statement. If both are always null, this will work. If not then split it up accordingly. NOTE: The dots after the ] bracket are critical. Its not going to work without them. This was tested in msAccess 2003 <pre>UPDATE tbl3Columns, [SELECT Col2 FROM tbl3Columns WHERE Col1='A'; ]. AS [tblSourceCol2 [...]
View Answer
| October 12, 2010 8:43 PM
DLookup, IIF, IIF function, IIF statement
Do it as one SQL update statement. If both are always null, this will work. If not then split it up accordingly. NOTE: The dots after the ] bracket are critical. Its not going to work without them. This was tested in msAccess 2003 <pre>UPDATE tbl3Columns, [SELECT Col2 FROM tbl3Columns WHERE Col1='A'; ]. AS [tblSourceCol2 [...]
View Answer
| October 12, 2010 8:43 PM
DLookup, IIF, IIF function, IIF statement
Do you have an IT blog or website and want to earn 100 knowledge points?
For the points I have added the link in my <a href=”http://tboxmy.blogspot.com/”>Linux, OpenOffice.org and Open Source Software</a> blog. ____________________________________________________________ <a href=”http://todaysbigpicture.blogspot.com/2010/10/it-knowledge-exchange.html”>Today’s Big Picture</a> by Shillu13
View Answer
| October 12, 2010 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
For the points I have added the link in my <a href=”http://tboxmy.blogspot.com/”>Linux, OpenOffice.org and Open Source Software</a> blog. ____________________________________________________________ <a href=”http://todaysbigpicture.blogspot.com/2010/10/it-knowledge-exchange.html”>Today’s Big Picture</a> by Shillu13
View Answer
| October 12, 2010 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
