Set up your router to be a DHCP client on the WAN side and a DHCP server on the LAN side ie it will get its own IP address plus...

Hi CJ

Well, I know the setup as I described will work, cos that's what I have on my own network at the mo. Also it will connect to a SQLS...

Hi CJ

DHCP is just a way of streamlining IP addresses, so that you don't have to manage them on paper, as you would with fixed addresses.  It has no bearing...

PMFJI - I'm not sure where you guys are going with the DNS stuff? - It's all on one subnet, so wouldn't DNS only be required for resolving names on the...

Absolutely - no doubt sp's are the preferred way to go.  Especially for web enabled apps, or any other scenario where you can't trust the users not to attempt a...

For the sake of completeness, another way to do it programmatically which isn't mentioned in this thread or the one referred to by Stewart, is to use the ASCII code...

Hi Paul

I was looking at your reply about dealing with the existing data - in order to format this onto a report, I meant you could get the block of...

OK how about this then -

Write some code in vb that structures the text the way you want, then populates a temporary table with the results. Then report from...

Depending on exactly what and why you want to do this, how about designing your input form with 15 textboxes stacked vertically, edge to edge, picking up the keypress event and...

Hi Frank

Y'know, sometimes when it's someone else asking the same question that's been circulating round your head for a day or two, it makes all the difference. . .I'd kind...

Thanks Adam - unfortunately the article is on a restricted part of the site, but your reply does say that there are situations where EM is unusable. Seems like a bit...

Thanks Antares - and you've answered another question too, which is 'does the position of the added field make a difference'

But my original question is really this - Is it...

For What It's Worth ! = I don't want to get into an argument with pro dba's on their own turf - but as a developer, I've never personally seen...

Yaip, FWIW as a developer not a dba I've always done what you proposed ie use one user id in the code and a user table, for the reason that...