Access Database Capacity
It’s recommended that you not try and put more than 1 Gig of data into a single access database as that’s about the most the Jet engine can effective handle.
View Answer
| June 25, 2009 1:39 AM
Access Data Volume, Access Database, Access Database Capacity, Microsoft Access
It’s recommended that you not try and put more than 1 Gig of data into a single access database as that’s about the most the Jet engine can effective handle.
View Answer
| June 25, 2009 1:39 AM
Access Data Volume, Access Database, Access Database Capacity, Microsoft Access
top values and ranking
You didn’t provide enough information, but the general syntax of the SQL RANK function is the following: <pre>RANK ( ) OVER ( [ < partition_by_clause > ] < order_by_clause > )</pre> Have a look at the following pages for more information and/or examples: <a href=”http://msdn.microsoft.com/en-us/library/ms176102.aspx”>RANK (Transact-SQL)</a> <a href=”http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php”>Oracle’s RANK, DENSE_RANK, FIRST and LAST Analytic Functions</a>
View Answer
| June 24, 2009 2:06 PM
RANK function, SQL
You didn’t provide enough information, but the general syntax of the SQL RANK function is the following: <pre>RANK ( ) OVER ( [ < partition_by_clause > ] < order_by_clause > )</pre> Have a look at the following pages for more information and/or examples: <a href=”http://msdn.microsoft.com/en-us/library/ms176102.aspx”>RANK (Transact-SQL)</a> <a href=”http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php”>Oracle’s RANK, DENSE_RANK, FIRST and LAST Analytic Functions</a>
View Answer
| June 24, 2009 2:06 PM
RANK function, SQL
enter key behavior on forms
You need to set the focus on the filed you want to bring the cursor back into. You don’t say what coding method you are using to get the info from the user. Is it VBA or a macro or some other code. You should know and post what language you are using with the [...]
View Answer
| June 24, 2009 1:58 PM
Access forms, Microsoft Access
You need to set the focus on the filed you want to bring the cursor back into. You don’t say what coding method you are using to get the info from the user. Is it VBA or a macro or some other code. You should know and post what language you are using with the [...]
View Answer
| June 24, 2009 1:58 PM
Access forms, Microsoft Access
Update Microsoft Access database from VB6
If I understood the question, I could give you some help toward the solution. Are you wanting to leave the old item and the new in the list box? You say “I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and [...]
View Answer
| June 24, 2009 1:51 PM
Database connectivity, Database programming, Microsoft Access, VB 6, Visual Basic 6
If I understood the question, I could give you some help toward the solution. Are you wanting to leave the old item and the new in the list box? You say “I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and [...]
View Answer
| June 24, 2009 1:51 PM
Database connectivity, Database programming, Microsoft Access, VB 6, Visual Basic 6
Execute a query on table in different db that will make a table in currentdb
You could create a link to the other database dynamically using the createtabledef method too. dim db as database, tdef as tabledef set db = currentdb() Set Tdef = db.CreateTableDef(“Table2009″) Tdef.Connect = “;Database=C:history.mdb” Tdef.SourceTableName = “Table2009″ db.TableDefs.Append Tdef Later you could simply delete the linked table object after using a query to append the records [...]
View Answer
| June 23, 2009 2:46 PM
Access 2007, Database, Visual Basic, Visual Basic .NET
You could create a link to the other database dynamically using the createtabledef method too. dim db as database, tdef as tabledef set db = currentdb() Set Tdef = db.CreateTableDef(“Table2009″) Tdef.Connect = “;Database=C:history.mdb” Tdef.SourceTableName = “Table2009″ db.TableDefs.Append Tdef Later you could simply delete the linked table object after using a query to append the records [...]
View Answer
| June 23, 2009 2:46 PM
Access 2007, Database, Visual Basic, Visual Basic .NET
Networking certifications
Good enough for what ? To start a career, a certification at least shows some ability and may well get you the job over someone who does not have this. But it will not mean that you start any further up the ladder, as experience is the key in networks, there is no substitute. If [...]
View Answer
| June 23, 2009 6:56 AM
Certifications, IT careers, Networking certifications
Good enough for what ? To start a career, a certification at least shows some ability and may well get you the job over someone who does not have this. But it will not mean that you start any further up the ladder, as experience is the key in networks, there is no substitute. If [...]
View Answer
| June 23, 2009 6:56 AM
Certifications, IT careers, Networking certifications
Configuration Management tool
Microsoft Project can do some of this. Microsoft has the Project Management Server and <a href=”http://office.microsoft.com/en-us/epmsolution/FX101935291033.aspx”>Enterprise Project Management solution</a> that might fit your requirements. There are likely bolt-ons that extend the functionality if the native products do not meet your needs. In the IT trenches? So am I – read my <a href=”http://itknowledgeexchange.techtarget.com/it-trenches”>IT-Trenches blog</a>
View Answer
| June 22, 2009 7:52 PM
Application management, Configuration management, Environment Variables, Relational databases
Microsoft Project can do some of this. Microsoft has the Project Management Server and <a href=”http://office.microsoft.com/en-us/epmsolution/FX101935291033.aspx”>Enterprise Project Management solution</a> that might fit your requirements. There are likely bolt-ons that extend the functionality if the native products do not meet your needs. In the IT trenches? So am I – read my <a href=”http://itknowledgeexchange.techtarget.com/it-trenches”>IT-Trenches blog</a>
View Answer
| June 22, 2009 7:52 PM
Application management, Configuration management, Environment Variables, Relational databases
Would you go with iSCSI or Fibre Channel for mass storage in this case?
When deciding your storage solution the TPS isn’t what’s important. The IO load, and the cache hit ratio are what matters. If you are running 10000 TPS and 100% of your data will be in cache, then it doesn’t matter. If you are running 2 TPS and 1% of data will be in cache then [...]
View Answer
| June 19, 2009 8:14 AM
Fibre channel, iSCSI, Oracle Benchmark Testing, Storage Channel, Storage management, Transactions Per Second
When deciding your storage solution the TPS isn’t what’s important. The IO load, and the cache hit ratio are what matters. If you are running 10000 TPS and 100% of your data will be in cache, then it doesn’t matter. If you are running 2 TPS and 1% of data will be in cache then [...]
View Answer
| June 19, 2009 8:14 AM
Fibre channel, iSCSI, Oracle Benchmark Testing, Storage Channel, Storage management, Transactions Per Second
How to show two query results in one Microsoft Access report
Yes you can do this. Simply call both recordsets and display each of them separately.
View Answer
| June 19, 2009 8:03 AM
Access 2003, Database programming, Microsoft Access, Micrsoft Access reporting
Yes you can do this. Simply call both recordsets and display each of them separately.
View Answer
| June 19, 2009 8:03 AM
Access 2003, Database programming, Microsoft Access, Micrsoft Access reporting
Information Systems Security or Computer and Information Science Degree?
From my experience, I have found two things to ALWAYS be necessary: 1.) Security 2.) Maintenance We will always need security. It will always be an issue. Our systems need to be maintained, and as long as we have them, that will be the case. Hope this helps! -Schmidtw
View Answer
| June 19, 2009 3:25 AM
Career development, CCNA, CCNP, Certifications, CIO, Computer and Information Science, Information Systems Security, IT careers, IT education, Network+, Security+
From my experience, I have found two things to ALWAYS be necessary: 1.) Security 2.) Maintenance We will always need security. It will always be an issue. Our systems need to be maintained, and as long as we have them, that will be the case. Hope this helps! -Schmidtw
View Answer
| June 19, 2009 3:25 AM
Career development, CCNA, CCNP, Certifications, CIO, Computer and Information Science, Information Systems Security, IT careers, IT education, Network+, Security+
What backend works best with Cognos frontend?
I don’t know if theres a best backend, thats question probably more suited for the Microsoft/Oracle debaters, but… We have a Cognos 8.4 installation and we are using a combination of SQL Server 2000 and 2005. They make it a point that you can use any database server or datasource you want to rather easily [...]
View Answer
| June 18, 2009 7:08 PM
Cognos, Microsoft Access, SQL Server
I don’t know if theres a best backend, thats question probably more suited for the Microsoft/Oracle debaters, but… We have a Cognos 8.4 installation and we are using a combination of SQL Server 2000 and 2005. They make it a point that you can use any database server or datasource you want to rather easily [...]
View Answer
| June 18, 2009 7:08 PM
Cognos, Microsoft Access, SQL Server
Access database table linked to Excel file question
Yes, its possible. Provided its saved on common folder/network folder Also, you will have to use ADO for updation/insertion. Regards, Sarfaraz Ahmed <a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a> How is it possible? In order to achieve this the Excel file would have to open in read only mode correct? The problem is Access open any linked Excel [...]
View Answer
| June 18, 2009 5:50 PM
Access 2007, Access Database, Excel worksheets, Microsoft Access, Microsoft Excel
Yes, its possible. Provided its saved on common folder/network folder Also, you will have to use ADO for updation/insertion. Regards, Sarfaraz Ahmed <a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a> How is it possible? In order to achieve this the Excel file would have to open in read only mode correct? The problem is Access open any linked Excel [...]
View Answer
| June 18, 2009 5:50 PM
Access 2007, Access Database, Excel worksheets, Microsoft Access, Microsoft Excel
Query showing vbCRLF in string data
Here is an example of how to detect LINEFEEDs in your data: SELECT [Property owners].OWNER_NAME, [Property owners].OWNER_NAM2, [Property owners].OWNER_ADDR, [Property owners].OWNER_ADD2, [Property owners].TAXMAP_PARCEL, [Property owners].DEEDBOOK FROM [Property owners] WHERE ( ( InStr([Property owners].[OWNER_NAME],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_NAM2],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_ADDR],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_ADD2],Chr$(10)) > [...]
View Answer
| June 18, 2009 2:42 PM
Access 2003, Access Database, Microsoft Access, SQL Query, vbCRLF
Here is an example of how to detect LINEFEEDs in your data: SELECT [Property owners].OWNER_NAME, [Property owners].OWNER_NAM2, [Property owners].OWNER_ADDR, [Property owners].OWNER_ADD2, [Property owners].TAXMAP_PARCEL, [Property owners].DEEDBOOK FROM [Property owners] WHERE ( ( InStr([Property owners].[OWNER_NAME],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_NAM2],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_ADDR],Chr$(10)) > 0 ) OR ( InStr([Property owners].[OWNER_ADD2],Chr$(10)) > [...]
View Answer
| June 18, 2009 2:42 PM
Access 2003, Access Database, Microsoft Access, SQL Query, vbCRLF
Is any AS/400 CBT (Computer Based Training) available for free
Local community college that has an Iseries operations class would work. Not free; but alot cheaper. If you can’t afford the class or have the time, maybe you can talk them into a crash course. There used to be self study programs from IBM (a couple of decades ago). Maybe some companies still have these [...]
View Answer
| June 17, 2009 2:58 PM
AS/400 training, Computer Based Training, IT careers, IT education
Local community college that has an Iseries operations class would work. Not free; but alot cheaper. If you can’t afford the class or have the time, maybe you can talk them into a crash course. There used to be self study programs from IBM (a couple of decades ago). Maybe some companies still have these [...]
View Answer
| June 17, 2009 2:58 PM
AS/400 training, Computer Based Training, IT careers, IT education
Capitalize First Character
You could use a combination of a few functions. Upper, Left, Substring, Len & Lower select upper(left(‘QUESTION’,1)) + substring(Lower(‘QUESTION’),2,len(‘QUESTION’)) select upper(left(‘question’,1)) + substring(Lower(‘question’),2,len(‘question’)) So you could make a function that passes in a parameter and returns your value so you don’t have to put all these functions in your insert and update statments. create function [...]
View Answer
| June 17, 2009 2:17 PM
INSERT statement, T-SQL
You could use a combination of a few functions. Upper, Left, Substring, Len & Lower select upper(left(‘QUESTION’,1)) + substring(Lower(‘QUESTION’),2,len(‘QUESTION’)) select upper(left(‘question’,1)) + substring(Lower(‘question’),2,len(‘question’)) So you could make a function that passes in a parameter and returns your value so you don’t have to put all these functions in your insert and update statments. create function [...]
View Answer
| June 17, 2009 2:17 PM
INSERT statement, T-SQL
ORA-01031 Insufficient privileges
The owner of the table in schema B needs to grant the REFERENCES privilege to the user of schema A. Example: <pre>grant references on table_on_schema_b to user_of_schema_a;</pre>
View Answer
| June 16, 2009 2:14 PM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys
The owner of the table in schema B needs to grant the REFERENCES privilege to the user of schema A. Example: <pre>grant references on table_on_schema_b to user_of_schema_a;</pre>
View Answer
| June 16, 2009 2:14 PM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys
IT Career advice
Certifications are helpful and in some cases are required to get a job for some companies. A certification is required where I work for instance. So I would suggest you do get certifications. Start with ones you know you can pass easily, maybe A+ and Net+ or MCP. These I was able to get without [...]
View Answer
| June 15, 2009 5:19 PM
Careers, Certifications, IT careers
Certifications are helpful and in some cases are required to get a job for some companies. A certification is required where I work for instance. So I would suggest you do get certifications. Start with ones you know you can pass easily, maybe A+ and Net+ or MCP. These I was able to get without [...]
View Answer
| June 15, 2009 5:19 PM
Careers, Certifications, IT careers
Career and certifications on Microsoft Platform
If you want to be a Microsoft-based engineer, then you appear to be on the right track. In addition, I would recommend you add a “security” course since security will always be needed in every environment even in a recession. Follow your interests. If you have a passion for something, that is the path I [...]
View Answer
| June 15, 2009 4:39 PM
CCNA, Certifications, Exchange certifications, IT careers, MCP, MCSE, Micrsoft Certifications, Networking certifications, SBS certifications
If you want to be a Microsoft-based engineer, then you appear to be on the right track. In addition, I would recommend you add a “security” course since security will always be needed in every environment even in a recession. Follow your interests. If you have a passion for something, that is the path I [...]
View Answer
| June 15, 2009 4:39 PM
CCNA, Certifications, Exchange certifications, IT careers, MCP, MCSE, Micrsoft Certifications, Networking certifications, SBS certifications
About the SAP Certification
If you are interested to do Genuine SAP Certifications test for Free for any modules you can find at <a href=”http://sapcertifications.ol-edu.com/home.html.”>http://sapcertifications.ol-edu.com/home.html.</a>All the test materials are prepared by SAP Certified Consultants by SAP AG, who performed Certification training programs at SAP Authorized Training center (ATC) in respective modules and having good knowledge of certification examination.
View Answer
| June 15, 2009 12:55 AM
Career development, Certifications, IT careers, SAP careers, SAP certifications, SAP training
If you are interested to do Genuine SAP Certifications test for Free for any modules you can find at <a href=”http://sapcertifications.ol-edu.com/home.html.”>http://sapcertifications.ol-edu.com/home.html.</a>All the test materials are prepared by SAP Certified Consultants by SAP AG, who performed Certification training programs at SAP Authorized Training center (ATC) in respective modules and having good knowledge of certification examination.
View Answer
| June 15, 2009 12:55 AM
Career development, Certifications, IT careers, SAP careers, SAP certifications, SAP training
Becoming a networking or database admin with a business information systems degree
It is hard to find jobs with this economy, but larger corporations should have helpdesk positions available. You’ll be lucky if you find a low level technical support technician position (but sometimes they are the same thing). When you get 2 years of experience, you should be ready to advanced if your not already climbing [...]
View Answer
| June 11, 2009 12:21 AM
Careers, Careers in networking, Database administration, Database Administrator, Degree, Job training, Networking, Networking careers
It is hard to find jobs with this economy, but larger corporations should have helpdesk positions available. You’ll be lucky if you find a low level technical support technician position (but sometimes they are the same thing). When you get 2 years of experience, you should be ready to advanced if your not already climbing [...]
View Answer
| June 11, 2009 12:21 AM
Careers, Careers in networking, Database administration, Database Administrator, Degree, Job training, Networking, Networking careers
