Search results for query: *

Have you checked whether ADO2.8 which has recently been released has fixed this? CID8

Has anyone come across this problem; When using a bound DBGrid (DAO Library control) in a vb6 project which is connected to a SQL Server 2000 database via an ODBCDirect connection, the data in the columns appears normal when any other format other than text columns, ie. dates and numbers are...

No i don't believe there is, microsft recommend using the find method instead. cid8

Does anyone know whether I need to do 3 separate statements to achieve the following, a single statement doesn't seem to work? ALTER TABLE AdmixCorr ALTER COLUMN AdmixCorrID INT NOT NULL, ALTER COLUMN AdmixCorrRef VARCHAR(20) NOT NULL, ADD COLUMN DateImp DATETIME NOT NULL Thanks in advance

Hi, i take it this has been resolved by now!! I have the exact same think - how did you resolve it? Thanks CID8

I've solved the pinging problem; having consulted with a colleague whose more experienced in this area he suggested disabling all DHCP and DNS servers and having static IP addresses internaly and adding a line to "HOSTS" file naming my FQDN of the server. This enabled the laptop to...

Experts, My problem is very similiar to many others on this site where people are having trouble joining a domain, only I also can't even ping the server from my XP Laptop. I have a small home network setup thus; 1 x XP Pro Laptop with a 3Com wireless network adaptor 1 x Small Buisness Server...

This all seemed like it would help solve my problem - but not so. My problem is very similiar only I also can't even ping the server from my XP Laptop. I have a small home network setup thus; 1 x XP Pro Laptop with a 3Com wireless network adaptor 1 x Small Buisness Server 2000 with a 3Com...

Hi there, I can't believe this hasn't been discussed before but I can't find the answer in the forums - so anyway heres my problem; I've got 1 form which has a combo box of employees, when you choose an employee the app creates an instance of separate form, makes it visible, adds it to a forms...

An alternative to this to use an Outlook Mail Template. Create a new Message Template with your text in the body part of the template, this allows you to be more creative with the formatting of the document. This is the jist of the code i have used where strOFT is the full file path of Message...

not sure where you'll find an official paper on it, but the limit is 2GB per database. SQL Server 1TB some difference!! Craig

Does anyone know how to connect to a calender folder which is not set as the cdoDefaultFolderCalendar? Or can the default folder be changed at run-time? Much appreciated CID8

whats a JRN file? CID8

Is it me, or would it not be simpler just to use the WorkGroup administrator, the builtin Access Security tools? Thanks CID8

Hi, Following on from this I recentlt had the pleasure of installing a new application which used a VB front end and SQL2000 backend. However the backend was developed using a developer edition of SQL Server 7.0, I attached the developer pc to the network, registered the SQL7 server into the...

Hi, I've installed MS Small Business Server 2000 on a small network, with access to the Internet going through Proxy Server & ADSL. All users have email and internet access. Prior to setting up the Proxy Server the users also had ftp access, now they don't!! The server does have ftp access...

This should work if the previous answer doesn't. In the record source for the report change [UPC Code] to UCase([UPC Code]) AS UPC. CID8

Hi I've created a Standard *.exe project with 4 built-in ActiveX User Controls. When running from within Design mode the application works fine, but when packaged and installed from as a working application on the same pc or different pc it comes up with "[Adodc] Unknown Error" and...

Have you looked at the Data Report from the Designer components list. This uses the same engine as MS Access. CID8

Someone earlier suggested upsizing to SQL Server, this is one of the best ways to solve the performance issues. Access and SQL work in opposite ways. Access is technically a front end tool, when you send a request from the front end for particular data to the back end, access sends the whole...