Recent content by warthog72

We upgraded from 2000 to 2005 and haven't changed any code between either version. We're rolling it back now - cost-based decision. I haven't played much with entire db moves inside DTS - I'm hoping its not a manual table-based process as there are hundreds of tables. Never played with BCP (at...

So, best bet for getting a 2005 database setup in a 2000 server is going to using DTS? I read somewhere I could bring on-line a 2000 server and then use DTS to import/move the data to it? I'd love to know an easier way.

Does anyone know if you can run a backup in SQL Server 2005 and install it in SQL Server 2000? I am hoping they are backward compatible otherwise I may have an issue. Thanks in advance for your help.

I have a SBS2000 running with 20 workstations connected. My 2x 36gb HDs are getting full and I wanted to move all my file storage to a different machine (file server). I was looking at Buffalo NAS 250gb boxes as they seemed very easy to use, but I couldn't find any business models or examples...

I think I may be running into this issue fairly soon as well. I have 19 desktops accessing one server w/ 1gb memory and a xeon 2.5ghz processor. I have 2 distributed apps accessing DBaseIV, Access, and SQL Server as well as internal Outlook email and file storage/sharing all on the one server...

Are there settings in Group Policy Objects that can also restrict that type of access?

SWEET! I figured it out and its really as easy as downloading the GPMC from Microsoft. The funny thing is this plug in just makes it work - all the settings were in place, OUs defined (appropriately enough) - it applied the GPOs to the OUs and I was done.

If you are using an ODBC, when you link the table into Access, in Options, you can select to save the password. Its not the best option, but if you are already using that connection method. Steps - 1. Choose Link Table from Access 2. Choose ODBC from type 3. Select your Data Source 4. Type in...

If you want to recalc the total after you change each combobox then I'd do something like Private Sub Recalc() txttotal = NZ(cbo1,0)+NZ(cbo2,0)+NZ(cbo3,0)+NZ(cbo4,0) End Sub Then in each After_Update of the comboboxes, add the line Recalc Example Private sub cbo1_AfterUpdate()...

I like the class object use; and use it frequently with my apps - storing and using variables between forms. Properties for each variable and you should be good.

Ok, I think I'm missing something here. My user shows up as part of the OU I created but the Group Policy I set for that OU, by right-clicking on the OU, selecting Group Policy from the tab and adding a new policy (named Deny Internet - with no override selected) isn't showing up anywhere. When...

I'll give that a try. My structure is like this: Domain has OU - Deny Internet Deny Internet has Security Group - No Internet No Internet has members A,B,C and D I don't need to add each User separately to the OU do I? Thanks.

I'm having a similar issue as atracy but I know my server is running DNS already. I'm trying to redirect the My Docs to a network share and I'm also trying to redirect a few users internet connection to a dead proxy (123.123.123.123) to keep them from browsing the web. I thought I could create...

30k records should be a walk-in-the-park for any version of Access better than 97 (unless like previously stated, you have 100+ fields per record). You really shouldn't be seeing a drop in performance at that size; you can see others have larger - mine particulary sits around 120mb after...

Thank you all for you insightful replies. I based my final decision on TIME :) I just didn't have enough to do it myself. I'm currently using TrueCommerce's application/network and its going nicely. $ for $ and hour for hour - we're very pleased. I did, on my own time, start writing a...