I wrote a VB program on my Windows XP machine. It does multi table queries,
you can add/delete and edit records, it all worked very beautifully. I was
very careful to validate data, and on my machine it works very well.
I compiled it, and sent the executable, which works fine on my machine, to a
business elsewhere.
They also have a Windows XP machine. When they run my executable, using the
same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces. When he makes a change to any
record, that change is copied to every record.
Has anyone seen any strange things happening when moving code from machine
to machine?
Adrian
13  2642 
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote in message
news:L_******************@news20.bellglobal.com... They also have a Windows XP machine. When they run my executable, using
the same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces.
Your text fields are most likely set to a "data source". The data source
points to the database and data. So the database might be pointing to your
local drive and directory which won't exist on your customer PC (unless you
reproduce the exact environment).
This of course can be done programatically, for example:
Data1.DatabaseName = "c:\whereever\whatdb.md"
Data1.RecordSource = "Select * from ..whatever"
Data1.Refresh
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> skrev i en meddelelse
news:L_******************@news20.bellglobal.com... I wrote a VB program on my Windows XP machine. It does multi table
queries, you can add/delete and edit records, it all worked very beautifully. I
was very careful to validate data, and on my machine it works very well.
I compiled it, and sent the executable, which works fine on my machine, to
a business elsewhere.
They also have a Windows XP machine. When they run my executable, using
the same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces. When he makes a change to any
record, that change is copied to every record.
Maybe a stupid question , but are you sure you've made the path to mdb
files to "app.path" and not a static path that it was on your machine ??
It seems like blank spaces in all your text boxes on init, is a database
not found !!
Has anyone seen any strange things happening when moving code from machine
to machine?
Adrian
"Steen Gellett" <He*******@NoSpam.Net> wrote in message
news:40***********************@dread16.news.tele.d k...
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> skrev i en meddelelse
news:L_******************@news20.bellglobal.com... I wrote a VB program on my Windows XP machine. It does multi table queries, you can add/delete and edit records, it all worked very beautifully. I
was very careful to validate data, and on my machine it works very well.
I compiled it, and sent the executable, which works fine on my machine,
to a business elsewhere.
They also have a Windows XP machine. When they run my executable, using
the same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces. When he makes a change to any
record, that change is copied to every record.
Maybe a stupid question , but are you sure you've made the path to mdb
files to "app.path" and not a static path that it was on your machine ??
Yes. His machine opens the database, because the data in one of his
non-bound controls (a combo box) is properly receiving data from a query,
and is being populated properly.
Adrian
"Raoul Watson" <Wa*****@IntelligenCIA.com> wrote in message
news:17*****************@nwrdny01.gnilink.net...
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote in message
news:L_******************@news20.bellglobal.com...
They also have a Windows XP machine. When they run my executable, using the same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces.
Your text fields are most likely set to a "data source". The data source
points to the database and data. So the database might be pointing to your
local drive and directory which won't exist on your customer PC (unless
you reproduce the exact environment).
This of course can be done programatically, for example:
Data1.DatabaseName = "c:\whereever\whatdb.md"
Data1.RecordSource = "Select * from ..whatever"
Data1.Refresh
I used a relative path. Or, in other words, I left the directory prefix off
and just quoted the filename. Hi DB is in the same folder as is the EXE,
which is correct.
It's finding the database, because some of the data is displayed properly.
I have a combo box which is filled using an sql query.
Adrian
Adrian Parker wrote: I wrote a VB program on my Windows XP machine. It does multi table queries,
you can add/delete and edit records, it all worked very beautifully. I was
very careful to validate data, and on my machine it works very well.
I compiled it, and sent the executable, which works fine on my machine, to a
business elsewhere.
They also have a Windows XP machine. When they run my executable, using the
same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces. When he makes a change to any
record, that change is copied to every record.
Has anyone seen any strange things happening when moving code from machine
to machine?
Adrian
Usually, when I do database programming, and the fields are blank, its
because MDAC isn't installed on the target machine, or some other
databasing component (depending on what you're using to connect to the
data file).
The best thing to do is use the Package & Deployment Wizard to create an
installation for your program, then install it on the target machine.
This will ensure the target machine has all the needed ActiveX Controls
that VB so heavily relies on.
It usuallt works without a hitch, or installation on the development
machine because by installing the development enviroment, that also
installs all the needed controls, etc.
Hope this helps
g
z
"Gemini" <sp**@nospam.org> wrote in message
news:66***************************@dcanet.allthene wsgroups.com... Adrian Parker wrote:
I wrote a VB program on my Windows XP machine. It does multi table
queries, you can add/delete and edit records, it all worked very beautifully. I
was very careful to validate data, and on my machine it works very well.
I compiled it, and sent the executable, which works fine on my machine,
to a business elsewhere.
They also have a Windows XP machine. When they run my executable, using
the same database I use, the program opens and sets all textboxes (which are
linked to table fields) to blank spaces. When he makes a change to any
record, that change is copied to every record.
Has anyone seen any strange things happening when moving code from
machine to machine?
Adrian
Usually, when I do database programming, and the fields are blank, its
because MDAC isn't installed on the target machine, or some other
databasing component (depending on what you're using to connect to the
data file).
That'll be it!
Thanks.
He won't have MDAC installed, he'd have no reason too.
The best thing to do is use the Package & Deployment Wizard to create an
installation for your program, then install it on the target machine.
This will ensure the target machine has all the needed ActiveX Controls
that VB so heavily relies on.
It usuallt works without a hitch, or installation on the development
machine because by installing the development enviroment, that also
installs all the needed controls, etc.
Hope this helps
Very much, thank you.
Adrian
"Gemini" <sp**@nospam.org> wrote in message
news:66***************************@dcanet.allthene wsgroups.com... Adrian Parker wrote:
Usually, when I do database programming, and the fields are blank, its
because MDAC isn't installed on the target machine, or some other
databasing component (depending on what you're using to connect to the
data file).
The best thing to do is use the Package & Deployment Wizard
Where do you find this Package & Development Wizard? My school has VB 6
licenses, but I do not see this utility anywhere in VB.
Adrian
Nevermind, found it.
It's output is really messy. Makes a LOT of files, a new directory, etc.
Adrian
"Adrian Parker" <ad***********@NOSPAMsympatico.ca> wrote in message
news:Nv********************@news20.bellglobal.com. ..
"Gemini" <sp**@nospam.org> wrote in message
news:66***************************@dcanet.allthene wsgroups.com... Adrian Parker wrote:
Usually, when I do database programming, and the fields are blank, its
because MDAC isn't installed on the target machine, or some other
databasing component (depending on what you're using to connect to the
data file).
The best thing to do is use the Package & Deployment Wizard
Where do you find this Package & Development Wizard? My school has VB 6
licenses, but I do not see this utility anywhere in VB.
Adrian
Adrian Parker wrote: Nevermind, found it.
It's output is really messy. Makes a LOT of files, a new directory, etc.
Adrian
<snip>
Right, but the core of those (only a couple of files) is all thats
needed. The ones in SUPPORT aren't needed for distribution. I think you
just need the setup.exe, setup.lst and the CAB file and you're good to
go. The files in the SUPPORT directory basically represent whats in the
CAB file.
Also, you can d/l the updated Visual Studio Installer. It has a great
script for creating VB Installations.
Scott Zielinski
"Gemini" <sp**@nospam.org> wrote in message
news:e6**************************@dcanet.allthenew sgroups.com... Adrian Parker wrote:
Nevermind, found it.
It's output is really messy. Makes a LOT of files, a new directory,
etc.
Right, but the core of those (only a couple of files) is all thats
needed. The ones in SUPPORT aren't needed for distribution. I think you
just need the setup.exe, setup.lst and the CAB file and you're good to
go. The files in the SUPPORT directory basically represent whats in the
CAB file.
Also, you can d/l the updated Visual Studio Installer. It has a great
script for creating VB Installations.
How does one make a single file EXE which installs everything needed?
Also, when you create a package on Windows 2000, then install on XP, it
replaces system files. Then XP complains that your system might be
unstable.
Adrian
Adrian Parker wrote: "Gemini" <sp**@nospam.org> wrote in message
news:e6**************************@dcanet.allthenew sgroups.com...
Adrian Parker wrote:
Nevermind, found it.
It's output is really messy. Makes a LOT of files, a new directory,
etc.
Right, but the core of those (only a couple of files) is all thats
needed. The ones in SUPPORT aren't needed for distribution. I think you
just need the setup.exe, setup.lst and the CAB file and you're good to
go. The files in the SUPPORT directory basically represent whats in the
CAB file.
Also, you can d/l the updated Visual Studio Installer. It has a great
script for creating VB Installations.
How does one make a single file EXE which installs everything needed?
Also, when you create a package on Windows 2000, then install on XP, it
replaces system files. Then XP complains that your system might be
unstable.
Adrian
You could package those couple of files into a self-extracting archive.
Like WinZip, or something similar.
Also, the Vis Stud Inst creates a single .msi file (much like an .exe
file, but requires the Windows Installer to be on the system) Most
Win2k+ computers have it built in.
Scott C. Zielinski
"Gemini" <sp**@nospam.org> wrote in message
news:e2**************************@dcanet.allthenew sgroups.com... Adrian Parker wrote:
"Gemini" <sp**@nospam.org> wrote in message
news:e6**************************@dcanet.allthenew sgroups.com...
Adrian Parker wrote:
Also, when you create a package on Windows 2000, then install on XP, it
replaces system files. Then XP complains that your system might be
unstable.
You could package those couple of files into a self-extracting archive.
Like WinZip, or something similar.
Also, the Vis Stud Inst creates a single .msi file (much like an .exe
file, but requires the Windows Installer to be on the system) Most
Win2k+ computers have it built in.
When I make a package on Windows 2000, then use the installer on XP, it
replaces required Windows librairies. The system then complains it may be
unstable. Is there any way to avoid this?
Adrian
Adrian Parker wrote: "Gemini" <sp**@nospam.org> wrote in message
news:e2**************************@dcanet.allthenew sgroups.com...
Adrian Parker wrote:
"Gemini" <sp**@nospam.org> wrote in message
news:e6**************************@dcanet.allthe newsgroups.com...
Adrian Parker wrote:
Also, when you create a package on Windows 2000, then install on XP, it
replaces system files. Then XP complains that your system might be
unstable.
You could package those couple of files into a self-extracting archive.
Like WinZip, or something similar.
Also, the Vis Stud Inst creates a single .msi file (much like an .exe
file, but requires the Windows Installer to be on the system) Most
Win2k+ computers have it built in.
When I make a package on Windows 2000, then use the installer on XP, it
replaces required Windows librairies. The system then complains it may be
unstable. Is there any way to avoid this?
Adrian
Don't know too much about the imstaller and WinXP
g
z This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: T.Venkatesh |
last post by:
Hi friends,
I just got stuck up in JDBC,JSP.
My problem is iam unable to display the output of Standard deviation ,
variance sum, of a column in a JSP page. But it complies- but no
display of...
|
by: Marina Anufreichik |
last post by:
Hi,
After deploymnet web application on web server I can access page on local
machine and login fine but when I'm trying to access web site from remote
machine I can see login page, but when I'm...
|
by: Matt Larkin |
last post by:
I am pulling my hair out trying to solve this one (presumably because
I am not particularly trained or skilled at access!)
I have a query which summarises the variances that each of my sales...
|
by: Javier Martinez |
last post by:
Hi
I have asp application in a machine with a virtual directory referring a
shared directory in another machine
When I try to load any aspx page of my portal I get the following error:
...
|
by: chickenyd |
last post by:
Hi
i am trying to create a program using WML, WMLSCRIPT, AND JSP. The task is to create a website to be displayed in the WAP Browser. In the website for a company called 'BargainBook' that sells...
|
by: TARUN |
last post by:
Hello All
I need to ask about the configuration file in .NET,
There are Two config File
1. Web Config
2. Machine config
I understand the the usage of Web config , but not able to understand...
|
by: aboxylica |
last post by:
do v have a function to calculate variance, average and standard deviation in python??
|
by: eliasam |
last post by:
Hi can anyone help me with this?
I've got a field in a query to calculate the weight charge:
CalcWeightCharge: *
Then in another field i would like to calculate the variance from the given...
|
by: raylopez99 |
last post by:
What are these terms in my header anyway?
But more importantly for me, look at this code:
Lack of variance:
why a List<Bananaisn’t a List<Fruit>
Many people initially expect the following...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
