|
The database wasn't corrupt, it was a brand new, newly populated, single table database. It happens every time, regardless of the data. Adding a single field should not inflate the size of the database up to 2GB - if it that happened MSAccess would have died a death a long time ago. I want to know why it is happening and if anybody else has had these issues.
Rugby League: The Greatest Game Of All.
|
|
|
|
|
After searching around the 'Net, it seems everyone is having this problem and it's not version specific. There are work arounds to compat the database back down, but nothing will prevent the bloat from happening. It appears to be the nature of the beast. I've never run into the problem to your extent simply because I do 99% of my work on SQL Server, even the small databases...
RageInTheMachine9532
|
|
|
|
|
I think you should compact and repair it before you do anything. The long integer type is not too long for DB.
|
|
|
|
|
Hi
I'm using a TextBox (or could use a RichTextBox) to display a file. I want it to default to showing the last few lines of the file, rather than the first. I've had a look at MSDN but I can't seem to find anything relevant. Can you help?
SH
|
|
|
|
|
Try this
<br />
rtb.SelectionStart = rtb.TextLength<br />
rtb.ScrollToCaret()<br />
Hope this helps.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
You star! Thanks very much.
|
|
|
|
|
No problem. Glad I could help.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
hi
i want to acccess the data field of a tcp packet( in a wireless network lan), so that when the packet leaves my computer it will encrypted with my algorithm and when it reached to the destination it will be decrypted.can anyone help me in that( i dont want to send my own tcp packet instead i want to use the packets which arrive and leave from the network traffic )
1-how can i access the data field of TCP packet?
2-how i use winpcap? if winpcap is used tp capture the packet.
3.should i have to place the field in the buffer or can i encrypt the field without any buffering?
i will be thankful if you people help me in that, i cant find anything around on the internet like that.
Thanks.
i am in real need these days.
Babur
|
|
|
|
|
If your asking these types of questions, you are definately not prepared for a project such as this. You'll need to know ALOT about the TCP/IP stack, how it works and why, about Windows device drivers, how to write them, debug them in kernel mode, and how to encrypt/decrypt data. There is no way this can be explained to you on the boards here.
Your complications will include re-writing the packet data, updating any packet checksums, field sizes, etc... But, you have to rewrite the packet only if it belongs to the application you want to encrypt data for. This alone will be a MAJOR problem for you to overcome since packet drivers don't care what applications are using them and no API functionality is in place to enable this.
You better bet to accomplish encryption is for your application to do the data encryption before it is serialized to the network...
RageInTheMachine9532
|
|
|
|
|
Friends, i want to ask that is there a way to auto fix columns in a data grid, I mean if i have to display just two columns in data grid and datagrid size is larger than two columns width.. they just r displayed on left and rest of the grid remain empty.. how can i FILL data grid with only two coloumns.. ? Should i have to chage the columns width manually.. but what if there are three columns sometimes to display?
looking to here from u soon
|
|
|
|
|
I dp not know open, read , write in vb.net., and the other thing is that, how create a data in vb.net, this is the line of code which i tried, but does not work at all. textbox1.databindings.add("text", data1, "Name")
tell me the steps how to do this things please who ever can tell me.
|
|
|
|
|
|
HI,
I have a problem with VB.net’s DataGrid. I wish to have two header rows with the bottom header nested in the top header eg The top header is Monday with Lunch and Dinner as headers underneath
____________________________
| __ Monday__ | __ Tuesday__ |
|----------------------------- |
|Lunch | Dinner |Lunch | Dinner |
|----------------------------- |
| ****| *****| ****| ***** |
|----------------------------- |
| ****| *****| ****| ***** |
|----------------------------- |
Cheers Shane
|
|
|
|
|
im a beginner using VB.net and im trying to display an autonumber in a vb.net form
ive got a person table (in access) with the fields person_ID, person_firstname, person_surname. The person_ID field is an autonumber.
Ive connected the database to a vb form (not web form). On the form ive added an Add button.
(So what im trying to achieve is when u click on the add button, the next availalbe autonumber should appear)
but i dont know how to do it. Every site ive looked at says to set autoincrement to 1. I have no idea how to do this, so could someone give me a step by step guide on how to do this, or send me an actual example of how it works
my email is cheetahshot@hotmail.com
thx
|
|
|
|
|
The autonumber won't be assigned until the record is updated. What you could do is when your Add button is clicked, add the new record to the database with blank fields. This will give you your autonumber. Then, bind your fields to the new record using the autonumber you got back as the key to make sure your only modifying that record. But, of course, this depends on the restriction imposed by the database, such as fields being tags as not being able to hold NULL values, or fields requiring values within a certain range, ...
RageInTheMachine9532
|
|
|
|
|
how could i add a blank line, then attach the records to that line? Would you be able to explain that a bit more?
|
|
|
|
|
Is this a Windows Forms app or a Web App? Are you displaying the records in the database with a DataGrid? What does your Add button do?
There is no one reference that will teach you how to do this. There are many different method to accomplish what your trying to do. Search the web for articles specific to the objects and statements your trying to use and Amazon for ADO.NET/VB.NET books. There are dozens of books on the subject and they can explain everything in much better detail that any article can.
But for here, post the code you're using so we can take a look at what your doing and make some recommendations. Normally, your app shouldn't care about the Autonumber until AFTER the new data is posted to the database, not before. This is because of data validation reasons and consistancy of the ID field.
RageInTheMachine9532
|
|
|
|
|
I'm having a problem accessing my database from a network drive. I'm using the Jet 4 connection to try and access the database. It tests fine, but when I debug, it can't find the database. I can put the database on my desktop's hard drive and set up the connection and it works fine, but not when it's on the network drive. If anyone could help me, I'd appreciate it. Thanks.
|
|
|
|
|
Does that account your using have access to the share on the other machine?
I should ask, does the account have the proper rights to the share? You can't use just read-only. The account must have read and write access...
RageInTheMachine9532
|
|
|
|
|
I am trying to get 5 random numbers between the numbers of 1 to 50 using vb.net. This is what I came up with so far:
Dim Array(4) As Integer
Dim Counter As Integer
For Counter = 0 To 4
Array(Counter) = CInt(Int((49 * Rnd()) + 1))
Next
Array.Sort(Array)
lbl1.Text = Array(0)
lbl2.Text = Array(1)
lbl3.Text = Array(2)
lbl4.Text = Array(3)
lbl5.Text = Array(4)
This code actually works but the thing is that it can pick the same number twice. I need all 5 numbers to be different. How can I achieve this?
Please help and thanks in advance.
Beginner in VB.NET
|
|
|
|
|
I've not put this in a compiler to check the syntax, so appologies in advance if I'm mistyped something. Here is a solution.
On each iteration the previous values are checked with the current random value and if they match a new random number is generated, this checking continues until there are no matches, at which point the value is put in the array and it moves on to the next element, like in your original code.
Dim Array(4) As Integer
Dim Counter As Integer
Dim CheckCounter As Integer
Dim Current As Integer
Dim IsOkay As Boolean
For Counter = 0 To 4
IsOkay = True
Do
Current = CInt(Int((49 * Rnd()) + 1))
For CheckCounter = 0 to Counter-1
If Current = Array(CheckCounter)
IsOkay = False
End If
Next
Loop While IsOkay = False
Array(Counter) = Current
Next
Array.Sort(Array)
lbl1.Text = Array(0)
lbl2.Text = Array(1)
lbl3.Text = Array(2)
lbl4.Text = Array(3)
lbl5.Text = Array(4)
Does this help?
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
Coming soon: The Second EuroCPian Event
|
|
|
|
|
Yes  with a few added lines which are in bold:
Dim Array(4) As Integer<br />
Dim Counter As Integer<br />
Dim CheckCounter As Integer<br />
Dim Current As Integer<br />
Dim isOkay As Boolean<br />
For Counter = 0 To 4<br />
isOkay = True<br />
Do<br />
Current = CInt(Int(49 * Rnd()) + 1)<br />
For CheckCounter = 0 To Counter - 1<br />
If Current = Array(CheckCounter) Then<br />
isOkay = False<br />
Exit For<br />
Else<br />
isOkay = True<br />
End If<br />
Next<br />
Loop While isOkay = False<br />
Array(Counter) = Current<br />
Next<br />
Array.Sort(Array)<br />
lbl1.Text = Array(0)<br />
lbl2.Text = Array(1)<br />
lbl3.Text = Array(2)<br />
lbl4.Text = Array(3)<br />
lbl5.Text = Array(4)
I had to add the else isOkay = true because with your origional code, once isOkay was set to false it was stuck in the loop. Which has solved my problem.
Thanks again
Beginner in VB.NET
|
|
|
|
|
Britnt7 wrote:
had to add the else isOkay = true because with your origional code, once isOkay was set to false it was stuck in the loop
 Sorry, about that. I just typed it in the text box on the web site and it looked okay. Just goes to show that testing is really important.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
Coming soon: The Second EuroCPian Event
|
|
|
|
|
Is it possible to pull from a list or array (1-50) so when the number is chosen, it is taken out of the list or array? Therefore it cannot be chosen again for the next random number. I didn't want the same number to be chosen twice at all.
That is what I intended to do but your code works as well.  Just curious.
Beginner in VB.NET
|
|
|
|
|
Britnt7 wrote:
Is it possible to pull from a list or array (1-50) so when the number is chosen, it is taken out of the list or array?
Yes, of course. Here is an example (It is a complete console application if you want to test it)
Module Module1
Sub Main()
' Randomize the random number generator so it
' produces different results each time
Randomize()
' Declare variables
Dim Array(4) As Integer
Dim Counter As Integer
Dim PossibleValues As ArrayList
Dim Current As Integer
Dim Index As Integer
' Build a list of possible values
PossibleValues = New ArrayList(50)
For Counter = 0 To 49
PossibleValues.Add(Counter)
Next
' Populate the Array of random values, removing
' each from the list of PossibleValues as they
' get used
For Counter = 0 To 4
Index = Int(PossibleValues.Count * Rnd())
Current = CInt(PossibleValues(Index))
Array(Counter) = Current
PossibleValues.RemoveAt(Counter)
Next
'Print out the Array
Array.Sort(Array)
Console.WriteLine(Array(0))
Console.WriteLine(Array(1))
Console.WriteLine(Array(2))
Console.WriteLine(Array(3))
Console.WriteLine(Array(4))
Console.ReadLine()
End Sub
End Module
How it works is that a list of all possible values is built and as each possible value is randomly selected it is removed from the list of possible values. The Random number that is generated is used as the index into the list of PossibleValues. This technique could be used for any list of PossibleValues (say Months of the year, Days of the Week, Lottery Numbers, etc.) where you don't want to get the same value twice.
Does this help?
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
Coming soon: The Second EuroCPian Event
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
