Recent content by meekon5

I have created an access database as a front end, linked through ODBC to our SQL server tables for a certain project. The access database is a convenient report generator for the project. I am also importing the same tables into another (identical) version of the database to zip and send to our...

I have heard that it is possible to link excell spreadsheets to access data. Does anyone know anything about how to do this please.

OK five days of doing everything to everything without any joy. Install it, uninstall it, re-install it. Spent most of yesterday digging through '.iss' files, logs for this, logs for that, and anything I could find. Adjusted all the tcp/ip ports to the same thing across the network. As I did...

After a recent re-build of my PC I have re-installed SQL2k. We are running three development machines (including mine) in the office, and a smallish dedicated SQL server on the network. I have installed the Personal Editon of SQL2k and anything the Development Edition adds. The Enterprise...

We are just iplementing a conversion from a unix clone (ManMan) to SQL2k. We have sights across the world (including US and Austrailia). We are setting up VPN (Virtual Private Network) connections for those subsidiaries that have no dedicatede line access to the main server/s. The only problem...

We've just signed up to a third party virus protection from Star. We re-direct our dns to and from the company through their server and all incoming and outgoing mail is filtered through four comercial virus checking packages and their own heuristic scan. Any problem mail is held on their server...

thanxs for that hints from the thread and related links seem to have cleared this up. Again thank you.

We have a SQL2k installation on an NT4 box. We have set up a number of DTS's which run fine when they are run from SQL Enterprise Manager by either of the two of us (SQL admins). But every time we attempt to schedule the things they refuse to run. Any DTS we set up no matter wether we use our...

Thanks for that. Enough for me to release a general warning to the company on this one. Thank you again.

I have two mails this morning (one from ZDNet another from NW Security) both warning about the above virus. I have no other information (checked NAI.Com and CERT both in virus and hoax areas) apart from these two sources, one claiming it's a version of the lovebug virus, the other claiming it's...

If your not using Dr Watson you do need to sometimes hack the registary using regedit. Search on "Watson" (ctrl + F), then change the key that gives the Dr Watson warning (\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DrWatson\VisualWarning) from 1 to 0. Some versions of MS operating systems...

Myself and a colleague have been asked to supervise the implementation of SQL2k (Hardware and software). We are working on forecasting and production databases, plus beginning a data warehousing project, for a small manufacturing company in Hampshire. We anticipate a high level of data enquiry...

Darn, I was trying to avoid the fact that its my process that is causing the problem. I was brought in to build a bridge between two processes for eight weeks, decided that Excel was not the platform an put everything onto access. Unfortunately ten months later I'm still here and have built a...

I'm running a forecasting system across a number of access databases. Unfortunately one of the databases has undergone heavy corruption of the data, but not in any logical method. I have run queries to find what extent data differs in the matrices and found some seventy lines have become...

The stated maximum is 1G for tables. But software I'm writting at the moment using access seems to run into problems with a lot smaller size of tables. Had to spec SQL server to get over the problem. Find that memory on machine can have big effect. Using an NT workstation with 256M I can run...