|
scenario:
I have a Sql Server in Rome and a shared server dir (with the access database)
on a Server in New York.
I have permission on sever dir and databse.
The database table on sql Server have exactlly the same structure of Access
table database. (the table on Sql Server have 200.000 records and 48 columns).
Now i want to recopy all records from Rome(sql server) to NewYork (Access
database).
Wath is the best way in terms of time to recopy all records fom sql server to
access database.
note:
I want to use in my app the ADO drive and vb6 classic.
naturally other way are welcome
|
|
|
|
|
sal21 wrote: Wath is the best way in terms of time to recopy all records fom sql server to
access database.
One option is to Replicate[^] it
I are Troll 
|
|
|
|
|
Hi Eddy.... tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Tks for patience.
Sal.
|
|
|
|
|
sal21 wrote: Hi Eddy....
tks for tip but sure not for me i know only VB6...
Can you post a code to use with vb6 classic?
Replication is done over SQL Server, and it doesn't speak VB6, only SQL. You should be able to talk to your Access-database using VB6 and ADO without any problems.
Alternatively, you could write some code in VB6 to do the import manually; creating an ADODB.Connection to SQL and writing it in your Access database. I'm going to guess that that's the code that you're interested in?
I are Troll
|
|
|
|
|
I have tested this way but the code run very, very slow...
Tell me if thei prob is your and post me a vb6 code
|
|
|
|
|
sal21 wrote: I have tested this way but the code run very, very slow...
sal21 wrote: (the table on Sql Server have 200.000 records and 48 columns).
SQL Server and Microsoft Access don't store their data in "exactly" the same way. Moving 200k records takes time. How long did it take?
Replicating to a linked server is the easy and painless way. Yes, it's possible to do it manually. Yes, you can read the data from SQL Server, and update it in Microsoft Access. That it's possible doesn't make it a good idea though.
Do you only need a read-only copy, or is it required to update the SQL Server-data with the changes in the Access-database? If you're satisfied with a read-only copy, then you could simply copy each table into an empty Access database. Should indeed be faster than replication.
Your best option would then be to execute an select into or something similar, from your SQL Server into your linked server. That would at least be a lot easier than reading data from connection 1 and writing it into connection 2.
sal21 wrote: Tell me if thei prob is your and post me a vb6 code
I can't write any specific VB6-code without seeing the physical server. I'll require a plane-ticket from Maastricht to Rome and lot's of coffee 
I are Troll
|
|
|
|
|
Two questions from a VB.Net beginner:
1. How can I center text in a table cell in a Word document that I have created with VB.Net?
2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
I can't find the methods in visual basic for either action.
Thanks
Bill
|
|
|
|
|
Well, I will answer my own questions.
bhogsett wrote: 1. How can I center text in a table cell in a Word document that I have created with VB.Net?
'center all the text
oTable.Rows.Alignment = Word.WdRowAlignment.wdAlignRowCenter
bhogsett wrote: 2. How can I make the first row of my table repeat at the top of each page on which the table carries over?
oTable.Rows(1).HeadingFormat = True
I needed to place the above after the with that applied a style (Contemporary) to the table.
oTable is obviously the table object.
I found it very difficult to find these answers.
Bill
|
|
|
|
|
Hi,
I wonder if anyone can help me with the error I am getting when I try and run my application in VB 2008.
"Form1.vb cannot be modified at this time"
I have tried Tools/Option/Build and Run/ Don't save any changes.
This does not work and I would want the choice to save changes everytime I run my app.
When I put say a button on the form the first time, it works. If I add another say button then that is when I get the problem. Basically adding anything to a form gets the error.
modified on Thursday, January 14, 2010 4:13 AM
|
|
|
|
|
It seems to me that there is something not releasing the file.
Does this happen the first time you run your app or only after that?
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
|
Thanks for getting back.
It happens when I change something on the form i.e. works first time but if I change anything, I get the error.
|
|
|
|
|
The same thing happened to me.
It seems to be a problem with VS itself and not your app or system.
Try to reinstall VS, and apply any and all updates.
Its a long way but, it fixed my problem.
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
|
I tried re-installing but get the same error.
I do have problems updating the SP1. Maybe if I can get this loaded then it should solve my problem.
|
|
|
|
|
I tried re-installing and I still get the same problem.
This may help, when I save before running, it works. No use as I want to run my app before saving changes.
|
|
|
|
|
Could you post my a copy of your code?
Maybe it's something there.
And also check that your IDE is "Stopped" before you try to change anything.
|
|
|
|
|
Thanks josefvz for getting back.
I have written no code yet. I have just installed VS 2008 onto my PC. I put a button onto a form, pressed F5. It worked. I then put another button onto the same form and tried to run. I got the error. I then saved everything, it worked.
I am also having problems installing SP 1.
|
|
|
|
|
So the IDE DEFINITLY STOPS EXECUTION before you add the 2nd button?
How to solve a Programing error:
1. Spell check
2. Debug
3. http://www.codeproject.com
|
|
|
|
|
Everything seems to have stopped execution but maybe there is something running in the background that I am not aware off. It points to that sort of problem. I can add new button etc so I thought the execution was complete but it must be hanging onto something.
Is there a way of finding out or some setting I can change?
Hope I have answered your question.
Thanks again for your help.
|
|
|
|
|
Yes, you've answered it.
The process that runs is called vbexpress.exe (For VS2008 Express)
The proces that "Hosts" your app is called "SolutionName.vshost.exe"
It stays in the memory even if the IDE is stopped, so i don't think that is your problem.
When VS first runs an app without you saving it, it creates files, maybe those files are set to read-only by defualt?
And then when you save they are overwritten.
Also does this only happen in GUI progeramming?
What about Console Apps, and Library Files?
|
|
|
|
|
Thanks agains.
I have tried this with VS 2005/2003 and do not get this problem. I also have run this in administrator mode even my rights are admin so I should be permitted to do everything.
I have checked the file are their attributes are not read only. At the moment I am only developing GUI.
|
|
|
|
|
Well, i'm sorry i can't seem to figure out your problem.
I tried to google it as well but only came up with: "the designer is currently in read-only mode"
Maybe you should try to contact VS support? It may be a problem only relevent to your computer system.
Sorry that i can't be of any more assistance.
Someone else (prefferable more experianced than me) HELP OVER HERE!!
lol.
|
|
|
|
|
Thanks josefvz for all your help, if I find a solution I will let you know.
|
|
|
|
|
Hi,
I found a workaround. If you run the app from the code viewer then it works. If you run the app from View designer then you get the message.
I am just going to go with running app in code viewer for the present time.
I also managed to install SP 1 but it made no difference.
Thanks again for all your help.
|
|
|
|
|
Great!
It's good that you found an workaround.
Please just Edit your OP's (Original Post) Subject and and [SOLVED][WORKAROUND]
to the begining.
Then when you have the solution just come and Post it here, and remove the [WORKAROUND]
Regards, Josef
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
