Search results for query: *

I haven't used Access much in the last 5 years, but back then it was never recommended to try to connect to a remote database. At best you got a very slow connection, usually you would just end up damaging your database. Access wasn't designed to work remotely.

>>> We have recently moved to Oracle 11g <<< Have you upgraded the Client software to your computer for 11g? My first step would be to independently verify you can connect to your database, through SQLPlus or try setting up a DSN in ODBC Administrator and see if you can connect from there. If...

Not sure exactly what you are askingn, but in relational databases you don't "have fields that will contain values from other tables". Rather, you have a foreign key field that relate to the other table, and the foreign key would have the same data type as the primary key of the related table.

>>> Sub A and Sub B are as above, one directly after the other, no code in between. <<<< That doesn't matter at all, what matters is the order that the subs get called. Either one of the following is happening: 1. You are calling Sub B before Sub A 2. In between calling Sub A and Sub B, you...

I don't think anyone can really tell you without a lot more information about the architecture of your application. Perhaps your database is perfect but your ASP (.NET ?) is badly implemented, or vice versa.

Using VB and ADO you could insert/update a blob field by chopping up the data into chunks and sending each chunk one at a time with ADO command (I think it was AppendChunk or something like that). There is probably some ADO.NET equivalent.

I guess that is how it happened. You don't need to be an "installation" program to write to the registry.

The file extension "VNC" has been associated with VNCViewer.exe, just like Microsoft Word is usually associated with the .DOC extension. Associating file extensions with particular executables has been part of the Windows operating systems for a very long time. Right click on a file and choose...

Have you confirmed this is a data error (i.e. the actual underlying database record is wrong) versus a presentation error (e.g. the query for the form or report is displaying it wrong)? If you have an audit log, can you not find out when one of the affected records had it's value changed? Your...

Between the two choices I prefer the SELECT statement because you can tell the user exactly what the problem is. The latter just tells the user there was "some error" and you can't just assume the only error that might happen is a duplicate record (i.e. don't show the user a "duplicate record...

For most of us, a "VB6 App" means an executable that was compiled with Visual Basic 6 code. You don't load "apps" into Visual Basic, you load "projects" (.vbp means "Visual Basic Project"). Hence the confusion.

So you are saying there are no two people with the same Last Name in either [Data from pdf Latest] or [WordCalendarDirectoryDump]? I agree with lameid that this is the most likely cause of your trouble. Otherwise, I suspect your [EMail Address] and [Email] fields look the same but are actually...

<<Hi could I get a hand on how I would sum the following number sequence.>> Simple: SELECT SUM(Value) FROM WhateverTable <<The datetimes can change as well as the values.>> How is that relevant? <<I have a starting value of 78913 and an ending value of 3212.>> How is that relevant? <<My...

As per my comment in your other thread, this is why I would leave logic handling in a higher level application level and leave stored procedures for simply retrieving the data you need.

If you run this query: SELECT attachment_3 FROM mwo.dbo.mwo Do you see the full path in all your records? If it were my task, I would be doing all this message building and sending in my front-end application (which I guess is Access in your case). First of all, I like my database server to...

Are you doing the exact same update for every record? If so, I would scrap using a recordset altogether and just run a simple SQL statement, e.g.: UPDATE MyTable SET SomeField = Something WHERE <whatever criteria your query uses>

If all you want to know is how many records the query returns, use simple SQL to get a count (Why would I want the overhead of loading a million records just to find out that is how many the query returns, for example?). rstADO.Open "SELECT Count(SomeField) As RecCount FROM qryTexShipped"...

Regarding error # 3265, it means that an identifier you have used in a collection doesn't exist. In this case, there is no field called "# FIELD5 #". The names of fields do not get modified with special characters based on the data type. Just use the field name exactly as it is spelled in the...

VB6AccessSQL - start your own thread to ask your question rather than posting in somebody else's thread.

Are your tables actually linked to some database server, such as SQL Server or Oracle? If so, the updates may be caused by triggers that exist in the database. I agree with Duane's suggestion of using SQL INSERT statement instead of recordsets. I gave up using recordsets for anything other...