Hi,
I've in mind to build an acces-database in wich a tabel attendance/date would be the central part. It would contain records containing just 2 fields: the ID of a person and a date. There would be up to two hundred persons and the table would be running over some years. The number of records could therefore rapidly become very high. I wonder if there is a max to the number of records in a table?
zaankanter
Last Activity: Dec 7 '08, 07:24 PM
Joined: Feb 25 '08
Location:
-
max to number of records?
-
Actualy servers DO discriminate between .htm and .html.
You can try this by uploading two diffent pages with the same name, but different extensions.
For your index (the titelpage of your site) you will be alright, using either index.htm or index.html, just do not use both! You won't have control over wich page will be shown. -
Hi
Doing ftp-transfer in the way described above I stumbled upon another minor problem. I don't know if it should be posted here or if it should be a different posting. Anyhow this is the problem:
Al goes well when the transferred file is relatively small, but when I send a file of 5/6 Mb this happens: The file does transfer (and of course takes some time doing so) but instead of giving a message back that the transfer succeeded...Leave a comment:
-
It works like a charm !!!
This is exactly what I had in mind when I first posted my question.
Besides solving my question, I feel I've learned a lot about cmd and ftp.
Thank you very much!!!
One remaining question:
- It seems to me that the (shell ?) routine runs seperatly from the acces-application. Is there nevertheless a way in wich I can inform the user (e.g. a message-box) when the transfer has been...Leave a comment:
-
Hi,
I suppose there is just too much wich I just don't grasp. That makes it difficult for me to understand what it is exactly that you ask me. I agree that its probably best if we try to solve the problem as a one-file-one-adress problem.
To make things more realistic, I have made an ftp-account for Amsterdam that actualy works (for as long as we need it for the purpose of solving my problem):
ftp.cisteem.nl...Leave a comment:
-
Actualy I would be very pleased if we could come up with a simple hardcoded answer, because for each user the same values would apply over and over again, and would be willing to repeat hardcoding those values(with changes) in every copy of the application.
But of course a more subtle approach, with would save me that trouble would be even better.
I've done some digging and it seems to me that the Call Shell command does not give...Leave a comment:
-
Yes, the file (preferably the .mdb file in wich the routine is called) should go to a prefixed place.
This is the situation:
My Acces-application is used by several users, each having their own stand-alone-version at dislocated places. To help/service them, they each have their own subdomain on my website, to wich they can upload their version of the application. In this way I can evaluate what their problem is and do updates. This...Leave a comment:
-
Appending the above:
I just managed to acces my ftp server, directly typing into the ftp box.
The list of commands at ftp-subcommands proved to be the key.
Nevertheless: This brings me to a better understanding of FTPcommand, but not yet to the target I set: automating ftp-transfer from Acces.
Hope to hear soon from you
ChrisLeave a comment:
-
Hi Neopa,
First of all your link to "FTP commandline" proved very insightfull, since I never worked with windows ftp.exe before, buth rather with other programs suchs as ws-ftp.
Using the folowing lines I got the FTP function in Windows to open from Acces (I see a black box containing the ftp> prompt). I tried to use the commands in the mentioned manual typing directly into the ftp box, and also have made use of...Leave a comment:
-
Its 23.30 local time, so I will struggle on tomorrow.
Thanks for your answer so far, sorry for the link I shouldn't have posted.
Guess it's probably for the best. People googling my name/trademark could very well stumble upon this thread, wich of course doesn't reflect my proffesional qualities in a very good light :)Leave a comment:
-
Hi
This is realy difficult for me. But one step at a time.
Please tell me what the -n , -s and -w in this bit stand for
By the way, there are no collegues or bosses to boast at. I'm just a one-guy operation, doing a hobby beside my regular non-IT job.Code:ECHO ON CD /D "^R" "%SystemRoot%\System32\FTP.Exe" -n -s:^N.Ftp -w:16384 ^S
Check me out: ** Link...Leave a comment:
-
Thanx NeoPa for your answer. I'm a novice, so I don't fully grasp it yet, but before asking more dumb questions I'm going to dig in your answer some more.
I'm sure I'll be back with further questions.
Thanks for now.
ChrisLeave a comment:
-
ftp transfer by vba ?
Does anyone know if its possible to make a ftp-file transfer by vba?
What I have in mind is a routine in vba or a macro wich will e.g. transfer my database or parts of it to a back-up site -
I've read the recommended article.
It seems to me that what the normalisation actualy does, is to hold the "stacked" tables (as in my first posting) by a process of repeating, in just one table, like this:
dayID, peopleID, thing-to-store, wich would give something like:
1, 1, yes
1, 2, yes
1, 3, no
1, 4, yes
2, 1, yes
2, 2, no
2, 3, no
2, 4, yes
...Leave a comment:
-
I surely will, thank you so far !Leave a comment:
-
three dimensions in a table
Generaly a table wil order data in a two dimensional way, as rows of data in a predefined number of columns. Re-thinking an already tackled problem (but not so very-well-tackled: thus the re-thinking) it struck me that the real problem to overcome were the three dimensions of my problem. Let me elaborate:
Simplified the task would be: populate a database with data concerning people at all the various dates in a year. Do this for a... -
HI,
I've stripped the programlines one by one by to find out what they do (and after stripping: don't).
This is what I finaly got. And it works!
Much, much, simpler than I imagened:
...Code:Private Sub Form_Load() If IsNull(DLookup("[res3]", "programmavariabelen")) Then Randomize Me![res3] = Int(Rnd() * 10000000) MsgBox (Me![res3]) End IfLeave a comment:
-
The form in question is the first one to open on opening the acces-project. Does that make any difference?Leave a comment:
-
This gives me an error in line 2: (translated from dutch its something like this:) "A datatype defined by user is not defined"...Leave a comment:
-
how to store my value
Hi,
This is an updated version of my earlier post, hoping to attract new readers/answers.
I want on opening my form, to check wether a field [res3] in the one-record table "programmavaria belen" is empty, and if it is, to fill it (that is of course, being the table designed to be one-record, in the first and only record) with a random integer.
This is where Zwoker has lead me to so far:
...Code:Private Sub Form_Load()
No activity results to display
Leave a comment: