Update Access Databse
This site has several examples on how to connect/edit databases http://www.asp101.com/samples/index.asp Regards

View Answer   |  April 4, 2009  3:17 PM
Access 2002, Access Database, Microsoft Access

Creating Ref numbers from two fields
I’m not really good at Access but as far as I know triggers are not available in Access but anyway you may use Form events to grab the first three digits with something like MYCODE = LEFT(FIRSTNAME,3) + LEFT(LASTNAME,3) I strongly suggest you adding more “items” for this ID otherwise it will surely happen that [...]

View Answer   |  April 4, 2009  3:09 PM
Access Database, Microsoft Access, Microsoft Access Unique ID

Access 2003 using VBA
The ‘CONSTRAINT’ keyword is missing before the constraint name of the primary key (PK_WeeklyUnitStaffRota). Please let us know if you get more errors.

View Answer   |  April 3, 2009  3:07 PM
Access 2003, Microsoft Access, RDBMS, VBA

Matching External lists to your Database?
How do i start. I also work fo a comapny where we have lists come in every day that we need to de-dupe from what in our SQL Server database. We get lists from Alliance as well a lot of other vndors so i know your pain. As far as software tools we use MatchIT [...]

View Answer   |  April 3, 2009  12:23 AM
Query optimization, SELECT statement, SQL, SQL queries

Optimizing a SQL Server stored procedure
There are many factors that could affect performance. Without more information, it will be really hard to answer. Can you post your code ? ——— The first thing that you need to do is identify what statement within your stored procedure is causing you the most problems. You can do this by looking at the [...]

View Answer   |  April 2, 2009  6:27 PM
EXEC, SQL Server stored procedures, SQL Server tables

SAP – Create CSV from Text format
Do a find and replace all on the file. Replace all “;” with “,”. No ..we can replace but while uploading from CSV file again we are getting error. The CSV file now downloading into this manner: A B C D E 01;10102009;3040490 02 ;10092009;3040494 but it has to be: A B C 01 10102009 [...]

View Answer   |  April 2, 2009  6:21 AM
CSV format, isSAP_CONVERT_TO_CSV_FORMAT, SAP development, SAP Import/Export

Resizing fields to see content in Microsoft Access 2003
When you put your mouse between columns, the pointer will change to a line with two arrows pointing outward. Click and hold to drag the box size out.

View Answer   |  April 2, 2009  2:29 AM
Access 2003, Microsoft Access, Microsoft Access 2003

Hosting multiple websites on IIS 6
Have it run on another port or use host header names.

View Answer   |  April 2, 2009  2:22 AM
IIS, IIS 6.0, Internet Information Services, SharePoint, SharePoint Services, sp_helprotect

DoCmd.OpenReport not working right with WHERE clause
From the discussion below, It seems that Access executes the base query first, and then apply the dynamic ‘where’ condition, and thus you can only filter by columns included in your select list. This worked: SELECT B.Owner, A.Fundno,Sum(B.AvLand) AS SumOfAvLand, Sum(B.AvImpv) AS SumOfAvImpv, Sum(A.TaxAmt1) AS SumOfTaxAmt1, Sum(A.TaxAmt2) AS SumOfTaxAmt2, Sum(A.Unpaid1) AS SumOfUnpaid1, Count(A.Napn) AS CountOfNapn [...]

View Answer   |  April 2, 2009  12:02 AM
Access 2003, DoCmd.OpenReport, Microsoft Access 2003, VBA, Visual Basic for Applications, WHERE statement

How to connect Oracle 9i to Visual Basic by ODBC?
Here’s an example of a connection to an Oracle 10g Express Edition instance, but there should be no difference if you use it to connect to a 9i database. The oracle client software needs to be installed, and in this case ‘XE’ is the database alias defined in the tnsnames.ora file. <pre>Private Sub Form_Load() Dim [...]

View Answer   |  April 1, 2009  5:10 PM
ODBC, Open Database Connectivity, Oracle 9i, Oracle connectivity, VB 6, Visual Basic 6

printed out in Access to populate the box
Easy – on the report footer insert an empty text box. Inside the text box type =DATE(). If you want this on every page or in a specific spot on your report, do the same thing wherever you want the current date to appear. Cheers! Not sure about this because it has been a long [...]

View Answer   |  April 1, 2009  12:50 PM
Access 2007, Access Custom Fields, Microsoft Access

Simple SQL server question?
Using SQL 2000 you’ll need to create a temp table (a table with a # as the first character in the table name) then put the selected rows into the temp table. Update the values in the temp table as needed, then write those values to the destination table then delete them from the source [...]

View Answer   |  March 31, 2009  10:55 PM
dBASE, Microsoft Access, SQL Server 2000

Plausability of natural key as primary key
Personally, I prefer to use surrogate keys. If there is some chance that the Program Name could change in the future (and names are usually subject of change as the business changes), then I would strongly recommend to use a surrogate key (Program ID). ———————————- If there is a natural key which makes sense to [...]

View Answer   |  March 31, 2009  5:21 PM
Natural Keys, Primary keys, Surrogate Keys

How to find out which embedded SQL taking more time in RPGIV program
Hi, If you can start debug before running the program (using STRDBG) then the query optimizer will give you some details in the joblog. I normally find this enough to find where SQL problems occur. Regards, Martin Gilbert.

View Answer   |  March 31, 2009  1:13 PM
Embedded SQL, RPG IV, RPGILE

Convert Oracle code to Microsoft SQL code
Have a look at the <a href=”http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx”>SQL Server Migration Assistant (SSMA) for Oracle</a>. It might help you.

View Answer   |  March 30, 2009  9:51 PM
Database conversion, Oracle import/export, Oracle triggers, PL/SQL, SQL, T-SQL

Barcode scanner that dumps into text file
Symbol scanners are high quality and durable scanners, we still use several over 5 years old. Symbol was recently bought out by Motorola, but the DS6700 should be a good choice.

View Answer   |  March 30, 2009  8:17 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional

oracle9i
- <a href=”http://www.oracle.com/technology/software/products/database/index.html”>Oracle Database Downloads</a> - <a href=”http://www.oracle.com/technology/documentation/database.html”>Oracle Database Documentation </a> - <a href=”http://www.oracle.com/technology/dba/index.html”>Getting Started: DBA</a> - <a href=”http://www.oracle.com/technology/obe/10gr2_db_single/index.htm”>Oracle by Example Series: Oracle Database 10g</a>

View Answer   |  March 30, 2009  1:41 PM
DBA, DBA training, IT careers, Oracle 9i

Paste from Microsoft Excel cells to Microsoft Access table successfully but…
If i understood correctly. You have some data in MS Excel which you want to move to MS Access and you are using Paste Apppend option. The issue you are facing is that link are getting truncated in MS Access. Please check the type and size of field. You can change the field type of [...]

View Answer   |  March 30, 2009  1:11 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel

How to use lookup query to return only entries matching the related field of active record
This one shouldn’t be that difficult. I’ll assume you want to use 2 combo boxes, with the first selecting a category and the 2nd the lookup value. (You can’t do this in 1 combo with multiple fields – at least not without some fancy VBA code). Ok, you have combo1 and combo2. Place them on [...]

View Answer   |  March 29, 2009  4:11 PM
Access 2007, Access query, Microsoft Access

How can we migrate Oracle database to Microsoft Access?
You may want to review some of the following references <a href=”http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx”>http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx</a>.

View Answer   |  March 29, 2009  1:57 PM
Database migration, Microsoft Access, Microsoft Access import/export, Oracle import/export, Oracle migration