|
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
|
|
|
|
|
Have You posted a message about this error on Microsoft yet?
|
|
|
|
|
|
and can you paste me a copy of the hole error message plz
|
|
|
|
|
Here is a copy of the message. All I done to the form was add/move an extra button.
---------------------------
Microsoft Visual Studio
---------------------------
The file C:\Temp\DeleteThis\ABCDEFG\Form1.vb cannot be modified at this time.
---------------------------
OK
---------------------------
|
|
|
|
|
ok i think i have a answer for you
if you create a project and just run it.
vs saves it in this temp folder as a read only file
and if you try to edit it after you ran it then it can]'t be edited anymore
try running the project first time
then stop the program
then save it as a other project name in a other folder
then try editing it again
if it still gives you the same error try
saving it in a folder you choose from the start and then run it
then try editing it again
|
|
|
|