Visual Basic :: VB6, Access 2000, Windows XP

Access Database And Windows 2000
I am using VB6, DAO 3.6, Jet 4.0, and Access 4.x (Access 2000). Everything works just fine on Windows 9x and Windows NT, but on Windows 2000, if there are multiple users modifying and updating the data at the same time, the data corrupts. Even after it corrupts and one user is getting an unrecognized database format error, the other users can still enter data until they close the program and re-start it. From what I can tell, this seems to be a problem with the way Windows 2000 interfaces with the client side data cursor in Access. I cannot find a fix for this problem. Has anyone else run accross this or do you have any ideas on how to fix it? Thanks.

Access To Active Directory Windows 2000
I want to Ask one question,

I wanto make previlage for my application, but i want to get user name from windows 2000.
Can you explaint to me?
Please help me

Thanks.

Windows NT/2000 Security And VBA In Microsoft Access
Hello all,

First off, I'd just like to say I am not trying to write a hacking tool......this is a genuine, work related task! :-)

Basically what I have got is a series of remote computers for which I have the IP address and a list of possible passwords which can number between 1 and 10 or so. My application at present runs an external application, which starts from the first password and then if this is incorrect then it moves to the next password, all the way up to the last if none of the others are correct.

The problem I have is that the external application takes a LONG time to run, even if the first password is correct, so as you can imagine if it has to go through all ten then it will become unusable.

What I need to know is if there are any Windows API functions, which will allow me to perform some kind of dummy logon, i.e test each of the passwords in turn until either one is found that is correct or all have been checked and then I can use the correct password to run my external app.

Any help or advice would be most welcome!

Andrew

VB6 With Access 2000 (DAO3.6) Generates Windows Error...
I have a VB6 SP5 project I converted from Access 97 support with the DAO3.5 to the Access 2000 using DAO 3.6. I changed all the Connect properties to Access 2000 and the Reference to DAO 3.6. The weird thing is that in the VB IDE, everything works fine. When I compile the EXE and run it, I get a "...has encountered a problem and needs to close..." error under XP and a "KFI2000.exe has generated errors and will be closed by Windows" error in Windows 2000. If I look at the details it shows the module name as dao360.dll where the error occurred. I've tried unregistering and re-registering the dao360.dll and that did not help. Thanks in advance...

VB6 Service On Windows 2000, Sending/recieving Mail Via Outlook 2000
I have a service running, when I try to connect to a MAPI Session it gives me an "-2147221231 Collaboration Data Objects - [MAPI_E_LOGON_FAILED] (80040111)" error.

If I run it as just a regular Executable and NOT a service it connects fine...

Any Ideas?

Create An New User In Windows 2000/Whistler, Or 2000 Server
I need some informations about how to create an new user account in Windows 2000/Whistler, or 2000 Server.

This is necessary because I have to create some accounts automaticaly.

E.g. I have to create accounts from 01 to 36.
On each account there stands a string before the number.

This should look like [string][number] (e.g. 2ben01).

Any suggestions?

thx, vbzero

Migration To Office 2000 And Windows 2000
I have a general question concerning Access 97 to Access 2000 migration and operating system migration.

I am in the midst of writing a program using VB 6 Professional with Access 97 as storage in the Windows NT 4.0 operating system.

We are about to change over to Office XP and Windows 2000 professional.

Are there any known issues with either change that I can prepare for now?

Installation On Windows 2000 And Outlook 2000
I have a vb application developed on a windows 2000 machine with outlook 98. i used the package and deployment wizard to create the package. The package seems to install fine on a windows 2000 machine with outlook 2000 but when the user ran the application it opened the login form and after entering the user id and password after clicking ok, windows prompts for the outlook 2000 cd. The application worked fine only when the user put the outlook 2000 cd and windows could find the file it was looking for. i assume it is probably looking for some dll but it is kind of strange. Please help. Is there something in the package and deployment wizard?
Thanks

Custom Database Viewer Will Open In Windows XP But Not Windows 2000 Operating System
Hello,

I have a VB 6.0 program that was created in Windows XP that allows people to view microsoft access data in a custom form using ADO technology. In order for this to work I have code that will check the users system folder to see if MSBIND.dll is in there. IF it isn't then it will install it as it is needed to view the data. The program works fine in Windows XP but now I have tested it out in Windows 200 and I get databinding errors.

I use the system function "GetWindowsDirectory" and when I check to see where msbind.dll is being stored it says C:WINNTSystem32MSBind.dll

I guess my question is, is this where I should be putting my msbind.dll? If so and the dll is not my problem, does anyone know of any problems that could be encountered by a Windows 2000 machine but not a Windows XP machine?

Thank you

Windows Socket Problem Between Windows 2000 Server And XP Professional
It used to work between Windows 2000 server and 2000 professional. When windows 2000 was upgraded to XP prof., it didn’t work. It can’t connect to the remote machine.

Is it possible related to XP's config. such as firewall? i turned the firewall off and it didn't work either.

Is it might related to the new WinSock APIs from XP (Mswsock.dll)? BTW, some codes were copied online posted by Mr. Oleg Gdalevich.

Did anyone have this problem or similar problem? Does anyone has an idea what’s the problem and how to fix it? Thank you so much.

Porting VB6 Project From Windows 2000 To Windows XP
Hello
I was wondering how easy would it be to port a VB6 project from windows 2000 to windows XP?

what would the pitfalls be that i need to watch out for?

Calendar Control Windows XP <-> Windows 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....

I've registered mscall.ocx on Windows 2000.

Hope somebody can tell me what's going wrong.

Thanks in advance!

Tinne.

Calendar Control Windows Xp <> Windows 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....

I've registered mscall.ocx on Windows 2000.

Hope somebody can tell me what's going wrong.

Thanks in advance!

Tinne.

VB 6 Print Differences Under Windows 98 And Windows 2000
I have a VB 6.0 program that works as expected in Windows 98 but under Windows 2000 it appears print out to a form is delayed or buffered and I get unexpected results. Any ideas of what is going on.
I want to be clear this is not a printer command but print to a form on the computer screen.
Example I print a message to a form; use a delay (Sleep 2) and then do another print command. Under 98 all happens as expected. But under Windows 2000 I get the delay and then the two print messages.

Thanks for any enlightment that you may shed on this.
Bruno

Edited by - brunowolff on 1/23/2004 11:16:17 AM

Moving IIS Server From Windows NT 4 To Windows 2000
Hi all,

Has anyone done migration of IIS server from Windows NT 4.0 to Windows 2000 Advanced server? I like to know the steps involved and complication that may occur during the process. Are there more than one way to do this?

Any help will be highly appreciated.
Thanks.

Distribute A VB Program That Reads An Access 2000 Db On Machine Without Office 2000
Hi. I want to develop and package a VB6 program which will read an access 2000 database. I use DAO 3.6. Doesn't work on another machine without access 2000 installed. I've been told I can use MDAC_typ.exe in setup program BUT they said MDAC2.6 doesn't contain Jet files etc... I am a it confused. What should I do???
a) MDAC_typ.exe OR b) Copy certain files directly into the setup program. c) Have a beer?

Mail Merge Access 2000 With Word 2000/XP And Pass Variables
Hi, I debated posting in newbies, because I'm kind of learning VBA on the fly, and am not very good at all.

I am trying to Mail Merge an Access 2000 database with Word 2000 & Word XP.

I modified the code I got from the Microsoft Solution Base to try to introduce variables to allow me to merge more than one table and SQL query with more than one Word document.

This code works without the variables, when I just type everything directly. Unfortunately, I need the ability to merge multiple documents/tables.

Sorry if its sloppy code, I haven't really got much of an idea of what I'm doing in VBA yet.
Can anyone help me debug this, and maybe give me the syntax to use in my Macro for MergeIt(var,var,var)

I also need a way to email similar form letters. This is for a membership expired notice - some get mailed/faxed, so need to be printed, while some should be emailed. I've read that sendobject doesn't do so well. - is there a way to merge into Word (or Outlook) and automatically email these notices?

Thanks very much!!
--------------------------------------


   Function MergeIt(docaddy, sqltable, sqlstr)

    DoCmd.SetWarnings False

     DoCmd.OpenQuery "Dues Expired Calculate"
     DoCmd.OpenQuery "Dues NOT Expired Calculate"
     DoCmd.OpenQuery "Dues Are Expired"

    Dim objWord As Word.Document

    Set objWord = GetObject(docaddy, "Word.Documents")

        ' Make Word visible.

    objWord.Application.Visible = True

    ' Set the mail merge data source.

    objWord.MailMerge.OpenDataSource _

       Name:="F:workooo dbOOO Main Database.mdb", _

       LinkToSource:=True, _

       Connection:=sqltable, _

       SQLStatement:=sqlstr

    ' Execute the mail merge.

     objWord.MailMerge.Destination = wdSendToNewDocument

     objWord.MailMerge.Execute

'The following line must follow the Execute statement because the

'PrintBackground property is available only when a document window is

'active. Without this line of code, the function will end before Word

'can print the merged document.

     objWord.Application.Options.PrintBackground = False

     objWord.Application.ActiveDocument.PrintOut

End Function

------------------------------------

Thanks for any help!

Edited by - case on 7/31/2003 7:40:22 AM

Using Access 2000 To Send Emails Through Outlook 2000
I remember running across a very small piece of code a few weeks ago but for the world of me, cannot find it now and I desperately need it. This piece of code was vbscript, it basically created an smtp server and sent mail using that smtp server instead of relying on outlook to do it.

I have an access database that needs to send roughly 520 individual messages based on criteria for that specific requested area (this is not spam either, this is requested information). It worked fine until I upgraded Outlook to the latest service packs and therefore no longer works. It prompts you with the standard MS security dialog asking for permission to send the email, I can tell it yes, it will prompt me once more, I tell it yes, then it just stops. The job process never completes. I do not want to have to revert back to an "unpatched" version of outlook and the piece of code I mentioned earlier would be ideal to use.

Any help would be greatly appreciated.

Thanks in advance
Todd

Looking For Access 2000 To Sql Server 2000 Sql/query Converter
Hi guyes . I am looing for a simple to use tool that easily convert the access 2000 query or sql code to sql server 2000 code and visa versa. Thanks

Problems-Upsizing MS Access 2000 DB App To SQl Server 2000
Hi all,

I am facing some problems while upsizing my current MS Access2000 database (.mdb file) to SQL server 2000 ( trying to make a client/server application by creating a .adp file).

I did everything using Upsizing wizard available with the MS Access2000. During the Upsizing using wizard I selected the option to create a new database, connected to the SQL server out there on the network( made sure that connection was tested OK), exported all the tables( was not sure what attributes of the table to select, so i selected all the options-indexes, validation rules, defaults, table relationships using DRI and even added time stamps).

Then i selected the option to create a new Access client/server application. I got two syntax errors while upsizing(one was while upsizing queries and the other was a form).But i clicked OK and the upsizing continued with no further errors.

When i looked at the snapshot created by the wizard. All the tables were upsized properly,but none of the queries were upsized. I got errors like "The wizard was unable to analyze the SQL for this query" or "This query is not upsizeable because it depends on a Form parameter". There was no information regarding forms or reports on this snapshot.

When i opened the .adp file created by the wizard, some of the components on the Forms were not working and giving the error messages like "The record source specified on this form or report does not exist".

I am new to this field and I would appreciate if anybody suggest me something related to these problems.

Thanks in advance.

VJ

A Good VBA 2000 Reference Book For Access 2000
Hi,

I have some experience with VB6 and VB.Net, as well as Access 2000.

I can query tables and retrieve, update records, etc. What I'm looking for is a good reference book where I can look up something and find the VBA code to do it.

I'm talking about compacting the database, transferring data, attaching tables to a back-end mdb from a front-end interface, and the such. I have found that I can make a macro to do the things I've listed here and then save the macro as a module to look at the VBA code, but I need a desk reference.

I bonus would be if it detailed Access built-in functions like saving a query to transfer text in a certain format (I had to get help here for that one).

I searched Amazon.com and read some feedback, but that's tough because you don't really know the author's abilities and they don't know what mine is.

So, now that I told you what my bacic ability is and what I'm looking for, I would sure appreciate your experiences in selecting the right book for me.

Thanks,

Tom

Windows 2000 To Windows XP Migration
I have a project, which is quite extensive, developed in a Windows 2000 environment using vb6. Our office is currently in the process of migrating to Windows XP. The project consists of multiple forms and accesses an MS Access 97 db.

I am able to open my vbp and create an executable in XP. However, when installing the package (created using the PDW) it fails at the very beginning of the installation with no error message. I beleive it is related to MDAC. However, I cannot be sure.

Any guidance would be appreciated.

Windows 2000 Vs Windows XP Compatibility
I am looking at buying windows 2000 or windows XP. My questions is, if I program under Windows XP will all Windows 2000 machines be 100% compatible with my programs?!

Windows 98 Apps On Windows ME And 2000
I'm running into problems installing VB 6, Windows 98 applications on Windows 2000 and Windows ME machines.
CABs are on floppies which get read followed by messages:
1. Some system files are out of date. Windows update- Yes.
2. Restart now - Yes.
System reboots, returns to new software install, rereads disk1 and returns to Step 1. above.
Anyone run into this?
How do I break the loop?
Thanks.

Windows 2000 / Windows XP Question
Hello!

I know this is the VB Forums, but I don't know where else to ask.

First, I have a simple Win 2000 question:

How do you share a folder in Win 2000 so a Win 98 or Me user can access it? Or a Win 2000 does no have to log in to use it?

Second, I have some Win XP questions:

Does anyone know how many computers you can install Win XP on with one license?

Two, what version is the best value, Home or Professional?

Thanks!

Windows 2000? More Like Windows 1970!!!
I'm not exactly a strong supporter of MS products but w2k is ~29 million lines of code. So even though there are 60000 errors that averages out to about 8-9 per 1000 lines of code. Not too great but hey, this is just MS.

Convert To SQL 2000 From Access 2000
I have VB application gets data from access, now I want to use sql 2000, hre is my connection, what I need to change in order to connect to sql instad. Ihave the table setup and no password or user name so I will use the=91sa=92 thank you

yMstConn.Mode = adModeShareDenyNone
MyMstConn.CursorLocation = adUseClient
MyMstConn.Provider = "Microsoft.Jet.OLEDB.4.0"
MyMstConn.ConnectionString = _
"Persist Security Info=False;" & _
"Data Source=" & App.Path & "Client_DB.mdb"

MyMstConn.Open
Set MyMstCmd.ActiveConnection = MyMstConn
MyMstCmd.CommandType = adCmdText
MyMstCmd.CommandText = sql
MyRS.LockType = adLockOptimistic
MyRS.CursorLocation = adUseClient
MyRS.CursorType = adOpenKeyset 'adOpenForwardOnly
If MyRS.State = 1 Then
MyRS.Close
End If
MyRS.Open MyMstCmd

Windows 2000
Hello all

I have an app that has been installing fine on Win 9x NT4. I am told that one of my customers has even installed it on an XP machine without any problems.

However on a Win 2000 machine recently the machine (laptop) went through the normal installation routine but after re-booting proceeded to Disk-Check the hard drive it then went into a continual loop, disk-checking time after time after time.

I wasn't at the machine when the installation was attempted but the user is adament that he has had the machine checked out and that it was the installation that casued the problem.

Anybody had this happen before?

I guess that one of the OS files was corrupted but I am not sure if this is releted to VB6 with Windows 2000.

I have checked out the Microsoft kb which refers to some file registration errors and a re-boot loop error.

I am running VB6 SP5. I am not sure of the SP on the Windows 2000 machine.

Thanks in advance.

VB6 And Windows 2000
I work for a company that develops test equipment. I mainly program in C but at times I'm required to program VB6 apps to control our equipment through a PC interface. I just ran into a huge problem with some of our customers.

It apears you need service pack 3 on windows 2000 to install any VB6 installation application created with the vb6 package and deployment wizard. This is killing us because some of our customers computers are on secured networks with no internet access. Also, some of them are on service pack 2 and not allowed to upgrade to service pack 3.

Do any of you guys know a way I can get an install package to work on a windows 2000 system with service pack 2 or less?????

I will be forever greatful

VB6, Windows 2000 And XP
Could you help me please.

I have written a VB programme using WebBrowser object. The programme works smoothly in my previous computer (Windows 2000). Now it creates "run-time error -2 (...)" when it runs on my new computer (Windows XP). What could be the problem?

Thank you.

WY

Windows XP And 2000
Im running Windows XP Pro. Ive made a program with VB6 in which Im printing all the fields into a Rich Text box. The loop is as follows

Do until partsRs.EOF = true
RichTextBox1 = RichTextBox1 + PartsRs("PartNo") & Chr(13)
partsRs.Movenext
Loop

Output example 1:

Part1
Part2
Part3
Part4
Part5

Im using the Chr(13) to move the cursor to a new line. This is working fine on my computer.
My question is this. I ran the same program on a win2000 computer and the output ends up looking like this

Output example 2:

Part1Part2Part3Part4Part5

Why???
Any help will be superb
Gruffymax

Windows 2000 SP3
SP3 became official today. I installed it yesterday with no problems. For more information:

http://www.microsoft.com/windows2000...p3/default.asp

Vb And Windows 2000
Hi

I just upgraded my old Windows 95 to Windows 2000 and have encountereds a few VB problems. My shell comands no longer work, my got focus does not work and F1 access to HTML help does not work. Anyone have any ideas/suggestions? Thanks.

Windows 2000 Pro
will vb6 work with Win 2000 pro? the msdn library disc says it only works with win98 & winNT.

VB3 And Windows 2000
Hi,

I have an app that I developed in Visual Basic 3. When running my application's .exe file under Windows 2000 it doesn't display screens properly, although it works fine on my Win 9x machines.

Is this a known issue and is there a simple workaround (other than porting to a higher version of VB)?

Thanks

Mark

VB5 & Windows 2000
I have written a program in VB5 which runs on Windows 9X, will it run OK on a PC using Windows 2000?

Windows 2000 / MTS
Here is the scenario, and I'm sure that it is not unique...

We are developing MTS Components for a web app running on IIS 4.0 (NT Server 4.0). Our development machines are running Windows 2000 Professional, and with that of course comes COM+. I was wondering, is there anyway to continue developing with the MTS library for servers that have not been upgraded to Windows 2000. Essentially (from what I've seen), the development machine tries to act "smart" by automatically upgrading the MTS reference to the COM+ dll. I would rather move forward with COM+, BUT upgrading the server is not a possibility. Any input would be welcomed.

VB4 16 Bit On Windows 2000
I have a program written in VB4 16 bit that uses the 16 bit ODBC driver for Oracle 7. Our database is 8i and the client is 7.2. We wish to run this application on Windows 2000 without having to rewrite the application. Can anyone assist us in knowing what issues that may lead to? Has anyone done this? Is it even possible? Please e-mail me your responses at william.kochevar@mmoh.com

Dns In Windows 2000
Hi there! I'm in big trouble, i just accept a job to upgrade a system using vb+access to another using sql-server 7. The point is that i never used a windows 2000 server before ( i only programmed vb with sqlserver in win98, using odbc and a dns that i ajusted manually).
The point is, vb is not locating the database server ( i am sure it is running).
The point is: how can i setup the dns or something like that so all the computers running my aplication can see the database?
If dns is not the best way, which is?
Thanks for helping!
Note, when i say dns setup i mean the icon in the control panel for odbc drivers, who looks to don't exist in windows 2000...

ADO With Windows 2000
I seem to be having difficulties with ADO & Access on Windows 2000

Background:

I have an application that uses ADO 2.6 written in VB6 sp5 running on Windows 2000 WS.

On load the app creates a connection to an Access 2000 database held on the network. I have a function that uses the connection to add a record to table A and then add a record to table B. The function is wrapped in side a connection.Transaction.

The problem is the following:

PC1 runs the function - saves OK
PC2 runs the function - system hangs and corrupts the database.

If however if I place a message box after the Table A update and before the Table B update, the function works fine!.

The app also works fine on Win NT 4.0. and also runs fine as a standalone app.

Questions:

1: Do you know if W2K deals with ADO differently from NT?
2: It seems that the Update on Table A has not been completed before the Update on table B, have you come across this kind of speed issue before?
3: Do you know why placing a stop/Msgbox in between the two updates would cause the app to run correctly?

I would greatly appreciate any help or Ideas you might have as I have been stuck on this for a week now and I do not want to re-install NT to get the project rolled out.