Not unless VB is integrated with SQL server

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #187,887 by ben_tilly 12/22/04 6:28:24 PM Reply	Not unless VB is integrated with SQL server There is a lot of legacy Access code out there that uses functions written in VB from within SQL. Can you do that in SQL server? Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #187,889 by inthane-chan 12/22/04 6:47:37 PM Reply	Yeesh! I'll admit to not knowing that much about the dirty tricks that one can play within Access... VB inside the DB structure itself? Yeek. "Here at Ortillery Command we have at our disposal hundred megawatt laser beams, mach 20 titanium rods and guided thermonuclear bombs. Some people say we think that we're God. We're not God. We just borrowed his 'SMITE' button for our fire control system."
Post #187,894 by ben_tilly 12/22/04 7:50:13 PM Reply	That trick is actually useful..ugly, but useful I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #187,897 by ChrisR 12/22/04 7:57:27 PM Reply	The poor man's Control Tables
Post #187,904 by ben_tilly 12/22/04 8:40:28 PM Reply	That's one thing to use it for I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #188,171 by tablizer 12/26/04 3:24:20 AM Reply	Files systems are not much better. Trees too damned limited ________________ oop.ismad.com
Post #187,890 by ChrisR 12/22/04 7:06:12 PM Reply	Perish the thought SQL Server does integrate with VB via the Data Transformation Services, but that's just used for reporting services.
Post #187,900 by altmann 12/22/04 8:01:26 PM Reply	"In the Next Version" The next version of SQL Server ("Yukon") as well as it's MSDE replacing offshoot SQL Server Express will support hosting the .Net CLR in SQL Server. Not the same thing though, in regards to supporting legacy Access code. -- Chris Altmann

Why does something this simple, take soo long? - (folkert) - (21) - Dec. 7, 2004, 02:27:17 PM EST

Probably at the Access level - (JayMehaffey) - (1) - Dec. 7, 2004, 03:10:19 PM EST

Doesn't matter either way. - (folkert) - Dec. 7, 2004, 05:37:39 PM EST

Investigate Pass-Through Queries in Access -NT - (altmann) - (1) - Dec. 7, 2004, 04:35:46 PM EST

Thanks. I do that later. - (folkert) - Dec. 7, 2004, 05:39:12 PM EST

Latency between Access and SQL Server - (ben_tilly) - (2) - Dec. 7, 2004, 05:13:12 PM EST

That is just WRONG. - (folkert) - Dec. 7, 2004, 05:40:00 PM EST

Sometimes faster just to import the whole table - (ChrisR) - Dec. 7, 2004, 05:53:08 PM EST

I would ask for a showplan - (Simon_Jester) - (1) - Dec. 7, 2004, 05:25:51 PM EST

There is an osql - (altmann) - Dec. 7, 2004, 06:43:59 PM EST

The answer is in the first line of your post -NT - (tuberculosis) - (1) - Aug. 21, 2007, 06:34:31 AM EDT

Clever, cleaver, thine art. -NT - (folkert) - Dec. 8, 2004, 01:02:49 PM EST

Most questions that start, "why does Access......?" - (tablizer) - (9) - Dec. 22, 2004, 05:17:20 PM EST

That might change. - (inthane-chan) - (8) - Dec. 22, 2004, 05:38:40 PM EST

Not unless VB is integrated with SQL server - (ben_tilly) - (7) - Dec. 22, 2004, 06:28:24 PM EST

Yeesh! - (inthane-chan) - (4) - Dec. 22, 2004, 06:47:37 PM EST

That trick is actually useful..ugly, but useful -NT - (ben_tilly) - (3) - Dec. 22, 2004, 07:50:13 PM EST

The poor man's Control Tables -NT - (ChrisR) - (2) - Dec. 22, 2004, 07:57:27 PM EST

That's one thing to use it for -NT - (ben_tilly) - Dec. 22, 2004, 08:40:28 PM EST

Files systems are not much better. Trees too damned limited -NT - (tablizer) - Dec. 26, 2004, 03:24:20 AM EST

Perish the thought - (ChrisR) - Dec. 22, 2004, 07:06:12 PM EST

"In the Next Version" - (altmann) - Dec. 22, 2004, 08:01:26 PM EST

iwethey.org

Oh, you've got an umbrella. You've got a purse.
249 ms