|
How to insert data from table1 in database Data1 to table2 in database Data2 and database Data2 is with password. Database is MS Access 2003. I use this
SQuery = "INSERT INTO uchenici (egn, name1, name2, name3, klas) SELECT Students.[ID number], Students.[Name 1], Students.[Name 2], Students.[Name 3], StudentClass.Class FROM Students INNER JOIN StudentClass ON Students.[ID number] = StudentClass.[ID number] WHERE(((StudentClass.Class) >= 100 And (StudentClass.Class) <= 1205)) ORDER BY Students.[Name 1]"
but 2 tables isn't in same datrabase
modified on Tuesday, December 21, 2010 2:37 PM
|
|
|
|
|
Hi,
As far as I know, one single query can only be ran against one single database (I may be wrong, but I never encountered such queries that can access more than one database at the same time).
So you have to process it in two stages :
1- Run the query on the first database to grab the data you need
2- Run another query on the second database, using the previous stage's results (make use of parameters)
(and, please, take the time to format the code when you post  )
|
|
|
|
|
ivo75 wrote: but 2 tables isn't in same datrabase
You can import the tables from Database 1 as linked tables[^], and have them mirrored in Database 2 
I are Troll 
|
|
|
|
|
I think do that Add all data from first table in Datagridview and from data grid add to other table
|
|
|
|
|
That should work too, but keep in mind that all the data get's loaded in the datagridview is temporarily stored in memory. Iow, it's not ideal if you need to copy a lot of records.
I are Troll
|
|
|
|
|
Hello, I have a problem,i have made my application with visual studio 2010 and visual basic .net, i have framework 4,well i make the setup file and can install it in another computer and it works, but when i install it in another pc and execute it there is an error,
example.exe - .NET Framework initialization Error
"unable to find a version of the runtime to run this application"
can anybody help me??
thanks! and sorry for my english.
|
|
|
|
|
Sounds like the PC you are installing to does not have .Net 4 installated.
Check in the windows/microsoft.net/framework directory to see what framework versions are there.
May want to include either the .NET 4 Full or .Net 4 Client package as part of your redist.
|
|
|
|
|
Thank you for answear, I have install all the .net frameworks like the other pc where it runs the application, and it works, but i have read that people who has the same problem, that solved in the same way (installing all the .net frameworks) it works, but sooner or later the problem will be appear again... for the moment for me it works. thank you again
|
|
|
|
|
download and get used to using dependency walker
|
|
|
|
|
Sorry but I dont understand what you will say to me, can you explain me that with more details?
Thank you very much for your help!
|
|
|
|
|
Dependency Walker is a free program that you can download from the internet to identify dll files that are required, but can't be found. This is because they are not on a client machine, not in the path, wrong version, or not registered.
|
|
|
|
|
Thank you for answear, Thank you for explain it to me, really I didn`t know that exists software like this, I will try to used it, again thank you very much.
|
|
|
|
|
Your welcome. Note that you should compare the potentially missing dll's on the developer and client machine. The developer machine may show a handful of unnecessary dll's as missing.
|
|
|
|
|
I have this VB6 program which reads and retrieve information or data from a text file as needed. I need to protect this text file which hold my data, is there any way i can encrypt or compressed so that the program can only retrieve the data from the file in order to protect the data inside.
Would be very grateful if anyone could help me on this.
Thanks.
|
|
|
|
|
You can encrypt/decrypt the text file, but you'd have to hold the contents of the file in memory to use it and modify it, then write it back out encrpyted.
You can find a few examples in this list[^].
I highly recommend abandoning VB6 development and moving to VB.NET. Once you get past the learning curve, you'll find that you've been writing code in the Dark Ages.
|
|
|
|
|
Thanks for the response, but the link mention just open the google page.
Well my problem is like i have developed this software which use a text file to hold the data, this text data i need to protect like we made a protection in ms-access using password. I dont' want the user to make changes or directly access the text file but through the software only and only read the data. Is there any way I can encrypt or compressed the text file and open the file through the program while using it. I would be grateful if you could show me how to do this.
Thanks.
|
|
|
|
|
hang_em wrote: but the link mention just open the google page.
Yeah, this is where you start your own research and start following those links and reading what they bring up. You will also find examples with some of them.
I don't have any examples to give you because I abandoned all VB6 developement, in favor of VB.NET, about 9 years ago.
|
|
|
|
|
SQL server 2008 express and VB 6 application.
I worked on the server side but if I run remotely to other machine using either XP or Vista I had an error message:
Run-time error '-2147467259 (80004005'
Cannot open database 'XXX' requested by the login. The login failed
The connectionstring is:
Database=SQLOLEDB.1;Server=.\SQLEXPRESS;Trusted_Connection=yes;Database=sql0007
Thank you
|
|
|
|
|
It sounds as though you have left something open or there is a disconnected dataset.
this[^] may help.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
Tom Bui wrote: SQL server 2008 express and VB 6 application.
Thats a frightening combination.
Tom Bui wrote: Trusted_Connection=yes
You should never use a trusted connection, that passes your credentials to the sever and tries to use them to log on. Set up a SQL type user (in sql server) and use the userid and password to connect.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
When trusted connection is set to True, the driver will use your Windows credentials to log in to the database. If a different user tries to make the connection, that login will fail if the user does not have access permission to the database.
By setting up a separate user and using those credentials, you can set up a multi-user system without having to muck around with the database itself every time you add or remove a user. As an added layer of protection, keep this user ID and its password secret. Provide your users with individual credentials: use the principle credentials to verify them and then continue to use the principle credentials once the user has been validated. Your users should NEVER have access to the id and password used to access the database, ever.
|
|
|
|
|
Dear,
please follow these things
1. Use sql native client for remote database access.
2. open <c:\programdata\microsoft\windows\start menu\programs\microsoft="" sql="" server="" 2005\configuration="" tools="" configuration="" manager=""> on server and set Protocol for Sqlexpress and client protocol (enable for sharedmemmory, TCP/IP, NamedPipe)
3. change your connection string first from remote machines
Provider=SQLNCLI.1;Password=xxxx;Persist Security Info=True;User ID=xxxxx;Initial Catalog=sql0007;Data Source=<your servername\sqlexpress="">
Thanx
|
|
|
|
|
Hi,
How can I find the true size of 1 column.
I have 3 columns First and last are of fix width and the middle is autosize.
The tlp is dock over the complete form. when I resize the form the middle column resize also. but I can't find a way to determen the size of that column.
I already tryed to compare with point2screen of the controls insite the tlp but no luck
Jan
Dim nWidth As Integer = Me.PointToScreen(pRight.Location).X - Me.PointToScreen(pMid.Location).X
|
|
|
|
|
A dirty way to do it would to be create another row in the TLP, with height 0. Drop a label control in the middle column that's Dock: Fill. Now you've the width of the column at any time simple by looking at the width of the label control.
|
|
|
|
|
Thanx for the awnser.
I'll check this too
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
