Search results

GPGeorge: Since you were kind enough to go to all the trouble to put out those definitions, and since I'm posting on this forum, I'll do my best in any future posts to follow those definitions to keep that thread on track. Not to cause another off-topic discussion, but: In that regard here is...

---------------- The-Doc_Man ---------------- Thank YOU. -------------- Ms. Hartman: --------------- While I have a lot of respect for you, based on your posts, I respectfully disagree. An SQL can use IFs, ANDs. ORs, NOTs, and SubQueries, which IMHO is programming logic. An object does NOT...

Personally we are beyond the point of this thread and in a debate over whether one calls a "toma'to" a "to'mato". Since I am unable to post a link, hopefully putting it in quotes will work. ERRORED even as a quote. I'm deleting the internet prefix in the hopes that works. It does. This...

cheekybudda and CJ London: When I stated stored / unstored procedure, I was referring to stored/unstored ACCESS queries. IMHO they are really the same. A query is a procedure. AND unless you know otherwise, ACCESS STORED queries (procedures) require table field names in the SELECT clause...

cheekybuddha and "The_Doc_Man" In code (most OPP languages and Classice VB -- not sure about VBA but believe VBA does Not have a compiler) objects can be early bound or late bound. An early bound object is known to the compiler when compilying (e.g. oPBox As Picturebox, or oText As...

This is a test. Twice previously I've unchecked "Stay logged In" and my posts have disappeared. What I don't understand is Pat Hartman response after Nautical Gent is also missing.

my post this morning did Not take for some reason. ----------------------------------------- NauticalGent: Thanks for responding. --------------------------------------------- Not familiar with TempVars, but looked at M$ docs about them. Basically a collection of variables. AFAIK: Stored...

NauticalGent: Thanks for responding. Link: (for some reason forums will not accept a link). Will have to play with it to see if can be accessed from Code other than Access VBA.. If it can be used in stored procedure, this would greatly reduce the number of stored procedures I use. In compiled...

The_Doc_Man: So now I have a decision to make, stay with ACCESS or go with a new Db. One Hopes for that. I always try and get things to work first, then optimize for speed. ---------------------- FWIW----------------------- Data files originally started out as flat files. When "Revelation"...

Thanks to everyone for their responses ------------------------------------------------------------------ Knowing What I'm Doing, Most Likely Will Help Responses ----------------------------------------------------------------- The App is a real-time trading program, for ALL markets. It was...

Thanks to all for responding -- Happy Holidays. For some reason, posted responses got lost in my EMail client -- I didn't notice the line until today. Had pretty much determined there wasn't a solution. The_Doc_Man The link to JET SQL IN states: The way I read this is ONLY one DB open at a...

CJ_London and The_Doc_Man: Thanks for responding. CJ_London My post, previous to yours (which they had a post number to reference) and the original code post, reflects having two database objects will NOT get me anywhere, since all DB procedures are hard coded to use>>. dbDAO. {whatever}...

The Doc Man: Thank you for that excellent response. FWIW I started out on a CDC 6400 myself in 1969, While I recognize a certain amount of speculation is involved, based on my efforts to date it rings true. I now post the background of my problem (as I perceive it)., and my second question...

I have a number of question in this area. I will post them one at a time based on answers. ================ Question #1 ================ If I run the following code,, the two databases are added to the Workspace Collection. NOTE: GetPath is a function that returns the database Path...

UPDATE Working as it should. (My Error as forgot to change which DB in one of my test code line.) ORIGINAL The Source DB resides on a CD. The CD drive device is CDRW. The Destination DB is on the HD (hard Drive). What my script does is Open Each Database (CD is opened exclusive, HD is open...

Just ran into another problem. The CD database is opening in exclusive mode, and is finding the table of interest. HOWEVER, the copying to the database on the HD, appears to be failing with a 3078 error. SO MY GUESS is: even though the DB's are on different drives, the fact ACCESS is exclusive...

Thanks to ALL for responding. The_Doc_Man:: 1) CJ_London offered this up, and my ability to use the CD now confirmed. 2) I am using VB code to do the heavy work (which includes opening the DB to execute the SQL, UNLESS there is way (???) to execute the SQL without opening the DB ).

CJ_London: That is the exact SQL I am using. However to execute that SQL statement, I'm using> dbDest.Execute SQL which I believe requires the DB to be open. Otherwise how does one: 1) Execute the SQL 2) The SQL known which destination database I'm referring to IF I have more than one in a...

Gasman: OWE YOU ONE. That worked. Did some reading on lock files, so learned something too., (FWIW, thought I had tried making exclusive, but guess Not).

Gasman: Program already works if the two DB's reside on the same drive, but different folders. Haven't tested if hard disk drive letter is different. Will do now. TEST Works fine if ON Same HD, two different drives. theDBGuy: Agree CD is read only. But that, IMHO, should not have anything...