Notifications Microsoft Access and Outlook
You can write a query block into the Access database to handle the sending of the emails. You would need to write some software to open the Access database and run the query. VBA should include the ability to send email. —————————————– There is a way to include SMTP functionality within Access itself to send [...]
View Answer
| June 13, 2008 2:31 PM
Microsoft Access, Outlook
You can write a query block into the Access database to handle the sending of the emails. You would need to write some software to open the Access database and run the query. VBA should include the ability to send email. —————————————– There is a way to include SMTP functionality within Access itself to send [...]
View Answer
| June 13, 2008 2:31 PM
Microsoft Access, Outlook
Data Sources for SSAS 2000
Yes you can setup SSAS 2000 to talk to a SQL 2005 database.
View Answer
| June 12, 2008 6:08 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, SSAS 2000
Yes you can setup SSAS 2000 to talk to a SQL 2005 database.
View Answer
| June 12, 2008 6:08 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, SSAS 2000
Table creation in SQL Server 2005
Basically no. The CREATE TABLE privilege must be granted to the user in order a stored procedure they run to create a table dynamically. The exception is a temp table.
View Answer
| June 12, 2008 6:05 PM
CREATE TABLE statement, SQL Server, SQL Server 2005
Basically no. The CREATE TABLE privilege must be granted to the user in order a stored procedure they run to create a table dynamically. The exception is a temp table.
View Answer
| June 12, 2008 6:05 PM
CREATE TABLE statement, SQL Server, SQL Server 2005
How to optimize results coming from database
Sounds like your table isn’t correctly indexes. You will want to look at the queries which are being run and make sure that the table(s) are correctly indexed.
View Answer
| June 11, 2008 11:13 PM
Database performance and tuning, Java, MySQL
Sounds like your table isn’t correctly indexes. You will want to look at the queries which are being run and make sure that the table(s) are correctly indexed.
View Answer
| June 11, 2008 11:13 PM
Database performance and tuning, Java, MySQL
Optimizing Query
If you are returning all records adding indexes won’t do you any good. A table scan is being done. How much data is in the table? What is the latency between you and the SQL Server?
View Answer
| June 11, 2008 11:12 PM
Database performance and tuning, Query optimization, SELECT statement
If you are returning all records adding indexes won’t do you any good. A table scan is being done. How much data is in the table? What is the latency between you and the SQL Server?
View Answer
| June 11, 2008 11:12 PM
Database performance and tuning, Query optimization, SELECT statement
Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
//XXXXXX JOB (9999,9999,,99),’UTIL JOB’, // CLASS=A,MSGCLASS=U,MSGLEVEL=(1,1),REGION=0M, // NOTIFY=&SYSUID //JOBLIB DD DISP=SHR,DSN=SYS2.xxxx.DB2.RUNLIB.LOAD /*ROUTE PRINT Rxx //* //STEP10 EXEC PGM=IKJEFT01 //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2) RUN PROGRAM(DSNTEP2) //SYSIN DD * put statements here // You can use this. Anything marked with an X is isnstallation depenedent, basicallly a [...]
View Answer
| June 11, 2008 6:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
//XXXXXX JOB (9999,9999,,99),’UTIL JOB’, // CLASS=A,MSGCLASS=U,MSGLEVEL=(1,1),REGION=0M, // NOTIFY=&SYSUID //JOBLIB DD DISP=SHR,DSN=SYS2.xxxx.DB2.RUNLIB.LOAD /*ROUTE PRINT Rxx //* //STEP10 EXEC PGM=IKJEFT01 //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2) RUN PROGRAM(DSNTEP2) //SYSIN DD * put statements here // You can use this. Anything marked with an X is isnstallation depenedent, basicallly a [...]
View Answer
| June 11, 2008 6:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
How do I Autopopulate a few field on my my form?
Hello Lisarod in MSAccess you should have some field types that can be lookup fields so you can: 1) choose appropriate lookups or 2) write some VBA that, at the change of a value of a component, perform queries and fill up other fields. Bye Don’t forget to visit my blog: <a href=”http://itknowledgeexchange.techtarget.com/it-support/”>If it has [...]
View Answer
| June 11, 2008 5:17 PM
Access 2007, Access autopopulate
Hello Lisarod in MSAccess you should have some field types that can be lookup fields so you can: 1) choose appropriate lookups or 2) write some VBA that, at the change of a value of a component, perform queries and fill up other fields. Bye Don’t forget to visit my blog: <a href=”http://itknowledgeexchange.techtarget.com/it-support/”>If it has [...]
View Answer
| June 11, 2008 5:17 PM
Access 2007, Access autopopulate
Entry Level IT job??
Everyone says that they want a degree. Pretty much no one actually requires one. I’ve been working in IT for over 10 years now and an a Senior Database Administrator and Architect and have one not gotten one job because I don’t have a degree. Certs are designed to help you prove that you can [...]
View Answer
| June 11, 2008 11:08 AM
A+, Certifications, Degree, degrees, Entry level IT, IT careers, just starting, Network+, rookie, Security+, Server+
Everyone says that they want a degree. Pretty much no one actually requires one. I’ve been working in IT for over 10 years now and an a Senior Database Administrator and Architect and have one not gotten one job because I don’t have a degree. Certs are designed to help you prove that you can [...]
View Answer
| June 11, 2008 11:08 AM
A+, Certifications, Degree, degrees, Entry level IT, IT careers, just starting, Network+, rookie, Security+, Server+
Database Permissions
Books OnLine can provide you with the bulk of this information. Most GRANT statements go what the name says. For example GRANT VIEW DEFINITION allows the user to view the Definition (source code) of any view, procedure, function that you have granted the right to. So if you run: <pre>GRANT VIEW DEFINITION ON schema::dbo TO [...]
View Answer
| June 9, 2008 10:25 PM
Database, Database permissions
Books OnLine can provide you with the bulk of this information. Most GRANT statements go what the name says. For example GRANT VIEW DEFINITION allows the user to view the Definition (source code) of any view, procedure, function that you have granted the right to. So if you run: <pre>GRANT VIEW DEFINITION ON schema::dbo TO [...]
View Answer
| June 9, 2008 10:25 PM
Database, Database permissions
table storing in oracle 10g
The default location is the system tablespace. This is bad because if the system tablespace gets full, the database fails. Create a new tablespace, and have a different user own any tables you create. You can alter the user to use the new tablespace as a default. create tablespace data datafile ‘/directory/datafile.dbf’ size 100M autoextend [...]
View Answer
| June 9, 2008 4:36 PM
CREATE TABLE statement, Oracle, Oracle 10g
The default location is the system tablespace. This is bad because if the system tablespace gets full, the database fails. Create a new tablespace, and have a different user own any tables you create. You can alter the user to use the new tablespace as a default. create tablespace data datafile ‘/directory/datafile.dbf’ size 100M autoextend [...]
View Answer
| June 9, 2008 4:36 PM
CREATE TABLE statement, Oracle, Oracle 10g
database
When you find a stack trace in the error log you should look into the dump files and see what caused the error and why. If might be something as minor as an unchecked bug in xp_sendmail, or something much more serious. If you aren’t sure what caused the problem, post the issue on a [...]
View Answer
| June 7, 2008 10:17 AM
Database administration, DBA, Server errorlog
When you find a stack trace in the error log you should look into the dump files and see what caused the error and why. If might be something as minor as an unchecked bug in xp_sendmail, or something much more serious. If you aren’t sure what caused the problem, post the issue on a [...]
View Answer
| June 7, 2008 10:17 AM
Database administration, DBA, Server errorlog
DB Web interface
Hello Jaco, the most used language is ASP and its evolution ASP.NET so i suggest you starting from these points. If you want to have a WYSIWYG database itnerface wizard you can consider using Microsoft Frontpage or Visual Studio that can help you through your learning. A good site that talks about ASP (Active Server [...]
View Answer
| June 6, 2008 3:11 PM
Database frontend, Database programming, Microsoft Access
Hello Jaco, the most used language is ASP and its evolution ASP.NET so i suggest you starting from these points. If you want to have a WYSIWYG database itnerface wizard you can consider using Microsoft Frontpage or Visual Studio that can help you through your learning. A good site that talks about ASP (Active Server [...]
View Answer
| June 6, 2008 3:11 PM
Database frontend, Database programming, Microsoft Access
Microsoft Access – I would like to have the first character of a field print without the first character?
Hello, you can do as follows: <pre> SELECT REPLACE(MYFIELD,LEFT(MyFIELD,1),”) FROM MY TABLE </pre> Bye
View Answer
| June 6, 2008 5:30 AM
Access 97, Microsoft Access
Hello, you can do as follows: <pre> SELECT REPLACE(MYFIELD,LEFT(MyFIELD,1),”) FROM MY TABLE </pre> Bye
View Answer
| June 6, 2008 5:30 AM
Access 97, Microsoft Access
Date Picker
yes, try to see http://www.glump.net/content/accessdatepicker/ it’s free access module. enjoy !!!!! Don’t want to improve the answer – just want to say thanks a lot for the help – much appreciated.
View Answer
| June 5, 2008 2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access
yes, try to see http://www.glump.net/content/accessdatepicker/ it’s free access module. enjoy !!!!! Don’t want to improve the answer – just want to say thanks a lot for the help – much appreciated.
View Answer
| June 5, 2008 2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access
Convert OO Base to MSA
Hello Naomih, I know the opposite process MDB–>OOB but know what you need but I think you can accomplish to this taks with the following: <li>Create a DSN that point to your OOB database</li><li>Create your Access Database</li><li>In the Tables view right click and select Import</li> At this point you <i>should</i> be able to read your [...]
View Answer
| June 5, 2008 8:14 AM
Access, Microsoft Access, OO, OpenOffice, VB
Hello Naomih, I know the opposite process MDB–>OOB but know what you need but I think you can accomplish to this taks with the following: <li>Create a DSN that point to your OOB database</li><li>Create your Access Database</li><li>In the Tables view right click and select Import</li> At this point you <i>should</i> be able to read your [...]
View Answer
| June 5, 2008 8:14 AM
Access, Microsoft Access, OO, OpenOffice, VB
copying docs while retaining unique doc id
Assuming that you are restoring the data because it was deleted unintentionally I would remove the deletion stubs and then push data from the backup replica into the production replica. Below is a link to a technote on how to remove deletion stubs from IBM support. http://www-1.ibm.com/support/docview.wss?rs=203&context=SW000&dc=DA410&dc=DA450&dc=DA430&dc=DA440&dc=D600&dc=D700&dc=DB510&dc=DB520&dc=D800&dc=D900&dc=DA900&dc=DA800&dc=DB540&dc=DB400&dc=DB560&dc=DB530&dc=DA600&dc=DA420&dc=DA460&dc=DB300&dc=DA470&dc=DA480&dc=DB100&dc=DA4A10&dc=DA4A20&dc=DA700&dc=DA4A30&dc=DA400&dc=DA100&dc=DA500&dc=D200&dc=DB700&dc=DB600&dc=DB550&dc=D100&q1=purge+document+deletion+stubs&uid=swg21095683&loc=en_US&cs=UTF-8&lang=all
View Answer
| June 4, 2008 2:50 PM
LotusScript, Replicating databases
Assuming that you are restoring the data because it was deleted unintentionally I would remove the deletion stubs and then push data from the backup replica into the production replica. Below is a link to a technote on how to remove deletion stubs from IBM support. http://www-1.ibm.com/support/docview.wss?rs=203&context=SW000&dc=DA410&dc=DA450&dc=DA430&dc=DA440&dc=D600&dc=D700&dc=DB510&dc=DB520&dc=D800&dc=D900&dc=DA900&dc=DA800&dc=DB540&dc=DB400&dc=DB560&dc=DB530&dc=DA600&dc=DA420&dc=DA460&dc=DB300&dc=DA470&dc=DA480&dc=DB100&dc=DA4A10&dc=DA4A20&dc=DA700&dc=DA4A30&dc=DA400&dc=DA100&dc=DA500&dc=D200&dc=DB700&dc=DB600&dc=DB550&dc=D100&q1=purge+document+deletion+stubs&uid=swg21095683&loc=en_US&cs=UTF-8&lang=all
View Answer
| June 4, 2008 2:50 PM
LotusScript, Replicating databases
Problem converting Access SQL query to T-SQL 2005
Department_Essential is a <b>column alias</b>, and column aliases are not allowed to be referenced in the same SELECT clause (well, they are allowed in Access, and there’s the source of your problem) so just “push down” the calculations into a subquery: <pre>SELECT DEPT_DESC , Department_Essential , EOC_Essential , Total_Employees , 100.0 * Department_Essential / Total_Employees [...]
View Answer
| June 4, 2008 2:20 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL
Department_Essential is a <b>column alias</b>, and column aliases are not allowed to be referenced in the same SELECT clause (well, they are allowed in Access, and there’s the source of your problem) so just “push down” the calculations into a subquery: <pre>SELECT DEPT_DESC , Department_Essential , EOC_Essential , Total_Employees , 100.0 * Department_Essential / Total_Employees [...]
View Answer
| June 4, 2008 2:20 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL
Oracle 10g Clone Database
Well, basically you have to reproduce in the new server the same layout you have in the original one. I mean paths for datafiles, redo log files, dump files, parameter and password files and so on. This is not mandatory, but it greatly simplifies the operations. So, the first thing you need to do is [...]
View Answer
| June 4, 2008 9:18 AM
Clone database, Hot Backup, Oracle, Oracle 10g
Well, basically you have to reproduce in the new server the same layout you have in the original one. I mean paths for datafiles, redo log files, dump files, parameter and password files and so on. This is not mandatory, but it greatly simplifies the operations. So, the first thing you need to do is [...]
View Answer
| June 4, 2008 9:18 AM
Clone database, Hot Backup, Oracle, Oracle 10g
Business Reports Sybase
Hello 006, you can use VBA (Visual basic for Applications) or use the Excel integrated feature to get data from a database. First create your DSN that points to the Sybase DB, then in Excel under the data menu choose to import the data from your DSN and then with appropriate queries you can get [...]
View Answer
| June 3, 2008 5:43 PM
Business Reports, Scripts, Sybase
Hello 006, you can use VBA (Visual basic for Applications) or use the Excel integrated feature to get data from a database. First create your DSN that points to the Sybase DB, then in Excel under the data menu choose to import the data from your DSN and then with appropriate queries you can get [...]
View Answer
| June 3, 2008 5:43 PM
Business Reports, Scripts, Sybase
how to prevent users from pc to use odbc
Hi ! You can use the exit point to validate users that are authorized to use ODBC. Sample program exist in the IBM information Center under this adress : http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaik/rzaikodbcexitprog.htm As you will see, it is pretty easy to write variance into this example to fulfill your need’s. Dont forget to register your exit program [...]
View Answer
| June 3, 2008 4:26 PM
AS/400 security, ODBC
Hi ! You can use the exit point to validate users that are authorized to use ODBC. Sample program exist in the IBM information Center under this adress : http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaik/rzaikodbcexitprog.htm As you will see, it is pretty easy to write variance into this example to fulfill your need’s. Dont forget to register your exit program [...]
View Answer
| June 3, 2008 4:26 PM
AS/400 security, ODBC
