Viewing 15 posts - 3,091 through 3,105 (of 6,216 total)
Have you looked at the new freeware tool Lumigent released?
Andy
October 14, 2002 at 4:27 am
October 14, 2002 at 4:23 am
Sorry it took so long. The checked property only applies to foreign keys. Primary keys are represented as indexes even though they are also indexes - the index being the...
October 12, 2002 at 8:12 pm
Good question. Took me a while to work out the norecovery part of the answer, long enough that I wrote it up for general release! You can see it now...
October 12, 2002 at 7:30 pm
Nope, it works. The data structures get upgraded automatically/transparently. One thing they got right.
Andy
October 12, 2002 at 2:59 pm
It is a scoping issue. To prove it, just change to global temp tables using ## instead of #.
Andy
October 12, 2002 at 8:35 am
If you're adding a domain group then everyone in the everyone group will have access. Doesnt matter where you add from. If you use a local (machine) group, then only...
October 11, 2002 at 1:16 pm
October 10, 2002 at 7:55 pm
I agree that a basic understanding of VB.Net or C# is worth acquiring. Basic flow control and how to use the new data access that is built in. I believe...
October 10, 2002 at 5:42 pm
Pleased to see most of the responses here are reasonable sane! I have zero experience with Oracle so can't really do a fair comparision, just pretty much agree with what...
October 10, 2002 at 5:28 pm
Hopefully one of our readers will be able to help, but just in case you might want to try the MS Access newsgroups or find an Access centric site.
Andy
October 9, 2002 at 8:13 pm
Reasonable. DTS exists to do tasks a lot like this. I use a simple VB exe that runs on the server to pick up mdb's dropped for processing, just runs...
October 9, 2002 at 5:38 pm
That works good. An added benefit (possibly) is that by using a TOP you can also use an order by - normally you cannot.
Andy
October 9, 2002 at 5:35 pm
I'd guess it is a bit unusual. Typically my recordsets are built from the results of a proc. Possibly the proc builds a temp table, but I wouldnt pass it...
October 9, 2002 at 5:34 pm
Agree. Either one rec at a time or chunks (need to test to see what chunk size works, append 500 or so at a time).
Andy
October 9, 2002 at 4:30 am
Viewing 15 posts - 3,091 through 3,105 (of 6,216 total)