|
Vipul Mehta wrote: Where do I need to make necessary permissions settings to the local users of the machine in order to encounter this issue?
Ask your system administrator, he should know what to do, if not, fire him, and find someone that knows a little.
|
|
|
|
|
Hi all - maybe somebody here can help me with this.
My Goal : To import some very large spreadsheets directly into access without using a dataset and writting line by line. The main problem is that I have a few hundred users and they will constantly be uploading LARGE files in different formats which I need to place into various access databases. If I use the INSERT INTO method it takes FOREVER but if I run the command directly from access, a file with 30000 records takes less than 4 seconds.
Option 1
(This runs a module that was previously set up (which Im trying to avoid using) but physically opens the database)
Dim oAccess As New Access.ApplicationClass
Dim test As Boolean
oAccess.Visible = False
oAccess.OpenCurrentDatabase(ConfigurationManager.AppSettings("physicalpathtomembersdirectory") & memid & "\addressbook.mdb", False)
test = oAccess.Run("ImportSpreadsheet", FileName, HasRows)
oAccess.CloseCurrentDatabase()
Option 2
(The idea of using this was that I could create a macro 'on the fly' and then run it - It doesn't work this way either)
Dim bAns As Boolean
Dim strsql As String
Dim cat As New ADOX.Catalog()
Try
Dim sCreateString As String
sCreateString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBFileName
Dim a As Object
a = "DoCmd.TransferSpreadsheet(Access.AcDataTransferType.acImport, Access.AcSpreadSheetType.acSpreadsheetTypeExcel9, 'group', " & ImportFileName & "," & HasRows & ")"
cat.Procedures.Append("import", a)
bAns = True
Catch Excep As System.Runtime.InteropServices.COMException
bAns = False
'do whatever else you need to do here, log,
'msgbox etc.
Finally
cat = Nothing
End Try
Return bAns
Option 3
(This one doesn't work because a oledb command object will only run a valid sql statement)
Dim Connectionstring As String
Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBFileName & ";Persist Security Info=False;"
Dim mycon As New OleDb.OleDbConnection(Connectionstring)
Dim str As String = "DoCmd.TransferSpreadsheet(Access.AcDataTransferType.acImport, Access.AcSpreadSheetType.acSpreadsheetTypeExcel9, 'group', " & ImportFileName & "," & HasRows & ")"
Dim mycmd As New OleDb.OleDbCommand
mycmd.CommandText = str
mycmd.Connection = mycon
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()
Return True
Any suggestions?
Thanks
Steve
|
|
|
|
|
What is the code, if any, that has run in 4 seconds?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i need your help for my project..
i'm going to create a generic and customizable voting using vb .NET but i am facing problems when it comes to customizing it..
an example is that if i am the committee of the organization conducting the election and if i am going to create a voting page i have to make my own list of officers to elect and also the candidates for each position..if i will add candidates or positions for election i will just add textbox for me to add the candidates for election..and then just type the needed information then it will be dsplayed on the screen that he/she is a candidate for a particular position..
i can't do it b'coz i am not familiar on how should i do it to come up with my desired project..
please help me..i really need it..please
thank you..
modified on Sunday, July 20, 2008 10:46 AM
|
|
|
|
|
emmegor wrote: i'm going to create a generic and customizable voting using vb .NET
Wrong forum, but so far so good,
emmegor wrote: i am facing problems when it comes to customizing it..
Oh dear.
If you have managed to create the generic voting then post your code and maybe someone will be able to suggest what you need to do.
If, as I suspect, you have no code and want someone to do your college project, then try rentacoder.com
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I use HttpWebRequest to connect ThumbCached server(a open source distributed caching and storing system, see www.domstorage.com), in single thread mode, it work perfect, but in multi-thread application, sometimes HttpWebRequest will not send request actually and throw TIMEOUT exception, It's known that the server is no problem (test by MS Web Application Stress Tool). Any suggeust?
|
|
|
|
|
Are we supposed to guess? 
Do you have some sample code that shows what you're doing?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
First post in this forum, so please be gentle.
We have a product, written in C#, using .NET 2, running on a server. It is a normal process, not a service. Occasionally we are seeing a .NET 2.0.x 'Fatal Execution Engine Error', and I wanted some tips on the best way to debug this sort of problem. I know next to nothing about .NET (yet), so please bear with me!
If this was a C++ app, I would install a debug version and the next time it crashed, I would grab the user.dmp log file and use this via Visual Studio to see where the crash occurred. In the old days I would of used a combination of the apps MAP file and a Dr Watson log (gulp). Either way, finding out where the crash occurred would be fairly straight-forward. I could even install some of the MS WINDBG tools to get a debugger on the machine.
So, how would I go about doing the same thing in .NET (short of installing Visual Studio and having the source code on the machine).
|
|
|
|
|
|
How can you disable selection/focus of a checkedlistbox? Setting selectedindex = -1 works but now you can't check any items. FindForm().ActiveControl = null also doesn't work. Any ideas?
|
|
|
|
|
Settings selectedindex = -1 works when you set CheckOnClick to true.
|
|
|
|
|
I want to write a windows service (myService) by using C++/CLI (Visual Studio 2005). This myService can use MFC function for OLE Automation.
Just for a first try, I did the following project configuration and coding:
• Creating a Windows Service under C++/CRL
• Adding ServiceInstaller with start type automatic and sereviceprocessInstaller with Account Local System
• Setting MFC in a Shared DLL
• Setting Common Language Runtime Support (/clr)
• Setting Multithreaded-Debug-DLL (/MDd)
• Adding #include <afxdisp.h> in stdafx.h
Compile is always successful. But when I use myServie.exe –Install to install my windows service in Visual Studio 2005 Command Prompt, I always get the following exceptions
When debugging:
Unhandled exception at 0x78374588 (mfc80ud.dll) in myService.exe: 0xC0000005: Access Violation reading location 0x00000000.
In Visual Studio 2005 Command Prompt:
Unhandled exception: System.AccessViolationException
Attempted to read or write protected memory.
This is often an indication that other memory is corrupt.
at _wWinMainCRTStartup()
Does anyone know the reason? Where am I wrong?
Many thanks for any help!
|
|
|
|
|
See here[^]
... and please don't cross-post!
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Thank you! I won't do that again.
|
|
|
|
|
Hi-
I want to create a callout/workflow so that when account "do not allow fax" is changed -
apply same change to sub-accounts and contacts attached to that account.
I am not sure how to do this using callout and how to access all subaccounts and contacts from an account using callout.
Any help would be greatly appreciated.
Thanks! 
|
|
|
|
|
The original is in the ASP.NET forum.
|
|
|
|
|
Good to know. Although I doubt anyone will answer since the post reads like it was typed by a epileptic ferret.
led mike
|
|
|
|
|
Cool - I've managed to imprint Ferrets in peoples psyche.
|
|
|
|
|
ROTFLMAO April's been busy voting
led mike
|
|
|
|
|
led mike wrote: epileptic ferret
Oh geeze, are we going to start the ferret thing again? 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi
Here i have one ASPxComboBox control (i.e. Dev Express Control).
I am populating this combo box by using javascript. this javascript i am calling in the page onload.
like :
<script type="text/javascript" src="DevComboItems.js" language="javascript"></script>
<script type="text/javascript" language="javascript">
function startfunction()
{
FillItemTypeCombo(document.form1.cmbItems,'Reason for visit');
//FillDevComboItems('Grade');
}
window.onload=startfunction;
</script>
But this is giving error like: 'Dev express' is undefined. Any one can help me please.
This is my java function.
function FillItemTypeCombo(cboItem, sDefaultItem)
{
var sDefaultItem
//cboItem.options.length=0
for(i=0;i<sItemTypeString.split("|").length;i++)
{
if(sDefaultItem == sItemTypeString.split("|"))
{
for(j=0;j<sItemTypeArray.split("|").length;j++)
{
//cboItem.options[j]=new Option(sItemTypeArray.split("|")[j]);
//cboItem.options[0] = new Option(0,new DevExpress.Web.ASPxEditors.ListEditItem ('sItem',0));
cboItem.options[j] = new Option([j],new DevExpress.Web.ASPxEditors.ListEditItem(sItemTypeArray.split("|")[j],[j]));
}
}
}
}
This is my page.
<body>
<form id="form1" runat="server">
<div>
<dxe:ASPxComboBox ID="cmbItems" runat="server"></dxe:ASPxComboBox>
<%-- <asp:DropDownList ID="cmbItems" runat="server"></asp:DropDownList>--%>
</div>
</form>
</body>
Subbu
|
|
|
|
|
Next time put your code in the "code block" when posting. It helps to make it easier to read. Since you lacked any indentation whatsoever, I will just move along 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi
Here i have one ASPxComboBox control (i.e. Dev Express Control).
I am populating this combo box by using javascript. this javascript i am calling in the page onload.
like :
<script type="text/javascript" src="DevComboItems.js" language="javascript"></script>
<script type="text/javascript" language="javascript">
function startfunction()
{
FillItemTypeCombo(document.form1.cmbItems,'Reason for visit');
//FillDevComboItems('Grade');
}
window.onload=startfunction;
</script>
But this is giving error like: 'Dev express' is undefined. Any one can help me please.
This is my java function.
function FillItemTypeCombo(cboItem, sDefaultItem)
{
var sDefaultItem
//cboItem.options.length=0
for(i=0;i<sItemTypeString.split("|").length;i++)
{
if(sDefaultItem == sItemTypeString.split("|"))
{
for(j=0;j<sItemTypeArray.split("|").length;j++)
{
//cboItem.options[j]=new Option(sItemTypeArray.split("|")[j]);
//cboItem.options[0] = new Option(0,new DevExpress.Web.ASPxEditors.ListEditItem ('sItem',0));
cboItem.options[j] = new Option([j],new DevExpress.Web.ASPxEditors.ListEditItem(sItemTypeArray.split("|")[j],[j]));
}
}
}
}
This is my page.
<body>
<form id="form1" runat="server">
<div>
<dxe:ASPxComboBox ID="cmbItems" runat="server"></dxe:ASPxComboBox>
<%-- <asp:DropDownList ID="cmbItems" runat="server"></asp:DropDownList>--%>
</div>
</form>
</body>
Subbu
|
|
|
|
|
Don't double post a half an hour apart, does not get you help any faster 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I just discovered that the managed cryptographic algorithms in .net are not FIPS compliant (more here:[^]) but the CSP's are.
I'm curious if anyone knows why not?
"It's so simple to be wise. Just think of something stupid to say and then don't say it."
-Sam Levenson
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
