• Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression

    Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression "...

    RajeshP20 pointsBadges:
  • File attribute DFU

    I have come across an object whose type is *File and attribute is DFU? What does this mean?

    Niklethaldan10 pointsBadges:
  • Dymo Printer programmatically with VB.NET

    For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as IDE and MS Access 2007 as backend. Any fast help is...

    Honeyprogrammer35 pointsBadges:
  • Missing Database Name and toolbar

    Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

    LarryThompson5 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • Q+A 5 Recover Database FAIL. Get File In Use

    We are running Q+A 5 and cannot do a successful “Recover Database”. Get “FILE IN USE BY aaa, bbb, aaa, ccc, bbb, bbb, bbb” message. All users were out of Q+A. Also we had the users mentioned in message re-boot their XP PRO workstations. Please Note: UIDs repeat in the in-use message.

    CGuy5 pointsBadges:
  • SQL or VBA code to loop through two columns of data

    I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product...

    Limey5 pointsBadges:
  • How can I synchronize three instances of MySql

    I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.

    Kcornell5 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • Changing Database Collation

    Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

    Db23290 pointsBadges:
  • Performance Issue with an Access File Updated through an .accde file with Linked Tables

    I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...

    EngTech5510 pointsBadges:
  • Access 2007 removing completed data

    I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

    MeBrainHurts5 pointsBadges:
  • How a S/W in c# working in N/W accesses access database from other computer not having access

    hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?

    Fairy5 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • Paragraph marks in an ASP blog page.

    My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but ignored when...

    Boblafferty20 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • SQL Studio Express scheduled backup

    I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license

    James015 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following