Time limit for use of Access application
This <a href=”http://3d2f.com/programs/0-334-vbolock-download.shtml”> site </a> has a program add in for VB that adds the functionality you are looking for. There are also links to related products at the bottom of the page. The FAQ on the authors home page located <a href=”http://www.moonlight-software.com/vbofaq.htm”> here </a> indicates it would be a good match for your purpose. [...]
View Answer
| September 12, 2008 12:22 PM
Microsoft Access, Software development, Trial period software
This <a href=”http://3d2f.com/programs/0-334-vbolock-download.shtml”> site </a> has a program add in for VB that adds the functionality you are looking for. There are also links to related products at the bottom of the page. The FAQ on the authors home page located <a href=”http://www.moonlight-software.com/vbofaq.htm”> here </a> indicates it would be a good match for your purpose. [...]
View Answer
| September 12, 2008 12:22 PM
Microsoft Access, Software development, Trial period software
Incremental Materialized View
Yes. Its called MQT on the iSeries. In most cases a full refresh is done using the SQL REFRESH command. However, it possible to insert, update, or delete from the MQT. You will have to write your own script for this.
View Answer
| September 12, 2008 2:47 AM
AS/400 database, Materialized Views
Yes. Its called MQT on the iSeries. In most cases a full refresh is done using the SQL REFRESH command. However, it possible to insert, update, or delete from the MQT. You will have to write your own script for this.
View Answer
| September 12, 2008 2:47 AM
AS/400 database, Materialized Views
Data mirroring
Hi, I am not very sure about waht typw of files exists in the libraries you are reffering to. But if these are the system libraries which are small size binary files, then you can implement rsync between the two servers. All the changes will be copied to the DEV server. You can automate the [...]
View Answer
| September 11, 2008 4:24 PM
Database mirroring, Mirroring
Hi, I am not very sure about waht typw of files exists in the libraries you are reffering to. But if these are the system libraries which are small size binary files, then you can implement rsync between the two servers. All the changes will be copied to the DEV server. You can automate the [...]
View Answer
| September 11, 2008 4:24 PM
Database mirroring, Mirroring
Moving SQL 2005 databases with no downtime between servers
You’ll need to drop the database, and restore the database again to get mirroring working. Drop all the logins as well before restoring the database. Go to MSKB <a href=”http://support.microsoft.com/kb/918992″>918992</a> and install sp_help_revlogin on the current system. Then run sp_help_revlogin. This will give you the SQL Scripts needed to create the logins using the same [...]
View Answer
| September 10, 2008 10:18 PM
Database mirroring, Microsoft SQL Server Management Studio, SQL Server 2005, SSMS
You’ll need to drop the database, and restore the database again to get mirroring working. Drop all the logins as well before restoring the database. Go to MSKB <a href=”http://support.microsoft.com/kb/918992″>918992</a> and install sp_help_revlogin on the current system. Then run sp_help_revlogin. This will give you the SQL Scripts needed to create the logins using the same [...]
View Answer
| September 10, 2008 10:18 PM
Database mirroring, Microsoft SQL Server Management Studio, SQL Server 2005, SSMS
Read Only Table
If I remember my Microsoft Access correctly you have to have a primary key on the table in the SQL Server database for Microsoft Access to be able to write to the table. Assuming your first column in the primary key the CREATE TABLE command would look something like this. <pre> CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [...]
View Answer
| September 10, 2008 3:12 AM
File permissions, Microsoft Access, SQL scripts, SQL Server 2005
If I remember my Microsoft Access correctly you have to have a primary key on the table in the SQL Server database for Microsoft Access to be able to write to the table. Assuming your first column in the primary key the CREATE TABLE command would look something like this. <pre> CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [...]
View Answer
| September 10, 2008 3:12 AM
File permissions, Microsoft Access, SQL scripts, SQL Server 2005
SQL Database Migration Process
If the table structure between the two databases is different then you will need to map where each piece of data needs to go to. You can then use SSIS to move the data from the source database to the destination database. There isn’t much more help that can be provided via a forum. If [...]
View Answer
| September 10, 2008 3:01 AM
Database migration, SQL Database, SQL Server 2005, SQL Server migration
If the table structure between the two databases is different then you will need to map where each piece of data needs to go to. You can then use SSIS to move the data from the source database to the destination database. There isn’t much more help that can be provided via a forum. If [...]
View Answer
| September 10, 2008 3:01 AM
Database migration, SQL Database, SQL Server 2005, SQL Server migration
Need Help Importing Data
There is a process explained here: <a href=”http://faculty.washington.edu/larsson/conf/aiha98/primer/excel-c.htm”>http://faculty.washington.edu/larsson/conf/aiha98/primer/excel-c.htm</a> that you might find helpful. It becomes relevant to your situation starting at step 2 Good Luck
View Answer
| September 9, 2008 6:29 PM
Access 2007, Microsoft Access
There is a process explained here: <a href=”http://faculty.washington.edu/larsson/conf/aiha98/primer/excel-c.htm”>http://faculty.washington.edu/larsson/conf/aiha98/primer/excel-c.htm</a> that you might find helpful. It becomes relevant to your situation starting at step 2 Good Luck
View Answer
| September 9, 2008 6:29 PM
Access 2007, Microsoft Access
export to csv file from java app
To copy an iSeries database file to csv, use CPYTOIMPTF To start a job on the iSeries, you can use FTP and QUOTE sub-command.
View Answer
| September 9, 2008 5:27 PM
AS/400, CSV, DB2, Java applications
To copy an iSeries database file to csv, use CPYTOIMPTF To start a job on the iSeries, you can use FTP and QUOTE sub-command.
View Answer
| September 9, 2008 5:27 PM
AS/400, CSV, DB2, Java applications
Trigger statement
Not knowing what database are you using, I can tell that Oracle has a limit on recursive calls in a trigger, and moreover, it does not let you modify objects that are “mutating”. From the documentation: “A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or [...]
View Answer
| September 9, 2008 3:55 PM
Database programming, Triggers
Not knowing what database are you using, I can tell that Oracle has a limit on recursive calls in a trigger, and moreover, it does not let you modify objects that are “mutating”. From the documentation: “A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or [...]
View Answer
| September 9, 2008 3:55 PM
Database programming, Triggers
SAP Job for end user.
I have found though my own experiences and those others have shared with me, that certifications are at least as valuable, IF NOT MORE SO, than degrees for getting IT related jobs. Bite the bullet and get the certification.
View Answer
| September 9, 2008 3:53 PM
IT careers, IT jobs, SAP certifications, SAP jobs
I have found though my own experiences and those others have shared with me, that certifications are at least as valuable, IF NOT MORE SO, than degrees for getting IT related jobs. Bite the bullet and get the certification.
View Answer
| September 9, 2008 3:53 PM
IT careers, IT jobs, SAP certifications, SAP jobs
Certifications and breaking into the IT field
Depending on how many years of experience you have either a junior or mid level network admin, or telecommunication admin. ***************************************************** You might want to check into jobs with your local hospital. Leverage your telephone system experience. Hospitals usually have a huge telephone system, and then once in the door, you can pick up experience [...]
View Answer
| September 9, 2008 3:21 PM
A+, Career development, CCNA, Certifications, Cisco certifications, IT careers, IT jobs
Depending on how many years of experience you have either a junior or mid level network admin, or telecommunication admin. ***************************************************** You might want to check into jobs with your local hospital. Leverage your telephone system experience. Hospitals usually have a huge telephone system, and then once in the door, you can pick up experience [...]
View Answer
| September 9, 2008 3:21 PM
A+, Career development, CCNA, Certifications, Cisco certifications, IT careers, IT jobs
Where to start?
Shane, Pretty much no matter what getting in IT means starting in an entry level position. Degrees mean less in the IT world than they do in most other parts of business. In IT its all about having real world experience. Without the real world experience the degree is only good for getting passed the [...]
View Answer
| September 9, 2008 3:01 PM
Career development, Certifications, IT careers, IT jobs, IT training
Shane, Pretty much no matter what getting in IT means starting in an entry level position. Degrees mean less in the IT world than they do in most other parts of business. In IT its all about having real world experience. Without the real world experience the degree is only good for getting passed the [...]
View Answer
| September 9, 2008 3:01 PM
Career development, Certifications, IT careers, IT jobs, IT training
ISeries ODBC Connection to Microsoft Word
See this IT Jungle site for this information… http://www.itjungle.com/mpo/mpo120502-story01.html
View Answer
| September 9, 2008 2:56 PM
CL, Microsoft Word, Microsoft Word merge, ODBC, ODBC on i5
See this IT Jungle site for this information… http://www.itjungle.com/mpo/mpo120502-story01.html
View Answer
| September 9, 2008 2:56 PM
CL, Microsoft Word, Microsoft Word merge, ODBC, ODBC on i5
Collating Sequence
Hello… All clauses of the OBJECT-COMPUTER paragraph apply to the program that explicitly or implicitly specifies them. They also apply to any program contained within that program. The MEMORY SIZE clause is for documentation only. It has no effect on program execution. The PROGRAM COLLATING SEQUENCE clause causes the program to use the collating sequence [...]
View Answer
| September 9, 2008 2:48 PM
COBOL/400, Collating Sequence, EBCDIC
Hello… All clauses of the OBJECT-COMPUTER paragraph apply to the program that explicitly or implicitly specifies them. They also apply to any program contained within that program. The MEMORY SIZE clause is for documentation only. It has no effect on program execution. The PROGRAM COLLATING SEQUENCE clause causes the program to use the collating sequence [...]
View Answer
| September 9, 2008 2:48 PM
COBOL/400, Collating Sequence, EBCDIC
Export in db2 iseries
Hello, Client Access has a built in utility for Excel that brings the data transfer utility directly into Excel. If you are in Excel, click on Tools, Add-ins, then click on browse and go to C:Program FilesIBMClient AccessSharedcwbtfxla. select it. An option of iSeries data access will apear in your add ins. Check this option [...]
View Answer
| September 9, 2008 1:48 PM
CSV, DB2, iSeries
Hello, Client Access has a built in utility for Excel that brings the data transfer utility directly into Excel. If you are in Excel, click on Tools, Add-ins, then click on browse and go to C:Program FilesIBMClient AccessSharedcwbtfxla. select it. An option of iSeries data access will apear in your add ins. Check this option [...]
View Answer
| September 9, 2008 1:48 PM
CSV, DB2, iSeries
Help needed – About Networking Related Jobs
How to land these jobs? Well you are on the right path earning your certs. Given that you achieve that you will still be trying to enter a profession where job experience is highly valued. You will have no choice but to seek out entry level roles and employers who have such roles available. Given [...]
View Answer
| September 9, 2008 1:35 PM
CCNA, Certifications, Cisco certifications, IT careers, IT jobs, MCSA, MCSE, Microsoft certifications, Networking certifications
How to land these jobs? Well you are on the right path earning your certs. Given that you achieve that you will still be trying to enter a profession where job experience is highly valued. You will have no choice but to seek out entry level roles and employers who have such roles available. Given [...]
View Answer
| September 9, 2008 1:35 PM
CCNA, Certifications, Cisco certifications, IT careers, IT jobs, MCSA, MCSE, Microsoft certifications, Networking certifications
Access 2007 Report displaying the content of three different fields in one box?
This page: <a href=”http://www.yevol.com/en/access2007/Lesson11.htm”>http://www.yevol.com/en/access2007/Lesson11.htm</a> has an explanation about halfway down the page (and it is a L-O-N-G page…) The page has other handy info on Access 2007 as well.
View Answer
| September 9, 2008 1:24 PM
Access 2007, Access reports, Microsoft Access, Office
This page: <a href=”http://www.yevol.com/en/access2007/Lesson11.htm”>http://www.yevol.com/en/access2007/Lesson11.htm</a> has an explanation about halfway down the page (and it is a L-O-N-G page…) The page has other handy info on Access 2007 as well.
View Answer
| September 9, 2008 1:24 PM
Access 2007, Access reports, Microsoft Access, Office
SORT/MERGE
You might try this site: <a href=”http://www.code400.com/”>http://www.code400.com/</a> Particularly this page: <a href=”http://www.code400.com/qlgsort.php”>http://www.code400.com/qlgsort.php</a> Good Luck
View Answer
| September 9, 2008 12:20 PM
COBOL/400, MERGE statement, SORT statement
You might try this site: <a href=”http://www.code400.com/”>http://www.code400.com/</a> Particularly this page: <a href=”http://www.code400.com/qlgsort.php”>http://www.code400.com/qlgsort.php</a> Good Luck
View Answer
| September 9, 2008 12:20 PM
COBOL/400, MERGE statement, SORT statement
Sorting hierachy data alphabetically in SQL Server 2005
Assuming that you use code similar to this: <pre>WITH EmployeeCTE AS ( SELECT EmployeeID, 1 AS Level FROM HumanResources.Employee WHERE ManagerID IS NULL UNION ALL SELECT E.EmployeeID, x.Level + 1 AS Level FROM HumanResources.Employee E JOIN EmployeeCTE x ON x.EmployeeID = E.ManagerID ) SELECT EmployeeID, Level FROM EmployeeCTE </pre> You can do an order by [...]
View Answer
| September 9, 2008 10:49 AM
Hierarchy data, Sorting, SQL Server 2005
Assuming that you use code similar to this: <pre>WITH EmployeeCTE AS ( SELECT EmployeeID, 1 AS Level FROM HumanResources.Employee WHERE ManagerID IS NULL UNION ALL SELECT E.EmployeeID, x.Level + 1 AS Level FROM HumanResources.Employee E JOIN EmployeeCTE x ON x.EmployeeID = E.ManagerID ) SELECT EmployeeID, Level FROM EmployeeCTE </pre> You can do an order by [...]
View Answer
| September 9, 2008 10:49 AM
Hierarchy data, Sorting, SQL Server 2005
Error accessing Oracle data using SQL job
Sounds like someone has uninstalled the Oracle drivers from the SQL Server. Try reinstalling the Oracle drivers on the SQL Server.
View Answer
| September 9, 2008 9:40 AM
DTS Package Scheduled Task, OLE DB, Oracle 7, SQL Server 2000
Sounds like someone has uninstalled the Oracle drivers from the SQL Server. Try reinstalling the Oracle drivers on the SQL Server.
View Answer
| September 9, 2008 9:40 AM
DTS Package Scheduled Task, OLE DB, Oracle 7, SQL Server 2000
