 |
|
|
 |
Junior Member
|
|
Jul 22, 2008, 01:21 PM
|
|
What is the maximum no of record in acces?
I just want to know how many records can access stored in records. What is the limit no. Thanks in advance.
|
|
 |
Computer Expert and Renaissance Man
|
|
Jul 22, 2008, 04:23 PM
|
|
There is none. Access doesn't limit according to record numbers, table size etc. because there can be many different factors. The limit is solely on the size of the mdb file. For Access 97 it was 1G, for 2000 and later its 2G. But this limit can be gotten around by using linked tables.
Did you solve the other problem?
|
|
 |
Junior Member
|
|
Aug 6, 2008, 12:13 PM
|
|
Which is the best to do? I will create different MDB file for every category then I link to each other or should I make all my programs in one MDB files.
|
|
 |
Computer Expert and Renaissance Man
|
|
Aug 6, 2008, 12:21 PM
|
|
Depends on your needs. At the least your database should be split into a back end (with all the tables) and a front end (with everything else). If you find that back end is getting too big, you can move some of your tables into another MDB file and link that to your front end.
You should not have separate tables for each category. You should have one table with a field to identify the category.
|
|
 |
Junior Member
|
|
Aug 6, 2008, 12:29 PM
|
|
The category I mean is for instance, I will create one MDB for the Employee Profile and second one is for Materials and so on. I have more program to do not only one cycle. So, if I will create this in one MDB file I'll be confuse because my form will increase the no. my quirries, and my report. For me, if there is possible to avoid more complicated forms,quirries and report I guess much better for me.
|
|
 |
Computer Expert and Renaissance Man
|
|
Aug 6, 2008, 12:42 PM
|
|
You will be surprised at how long it takes to fill up two Gig. I would keep all your tables in one back end MBD until you see whether your data mdb is getting too big.
If you have to move tables into other backs ends, this will not affect your front end at all. The tables will still have the same names, even if they are linked to a different file.
|
|
 |
Junior Member
|
|
Aug 6, 2008, 01:09 PM
|
|
Thanks. :)
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Acces to my child
[ 4 Answers ]
Hi I'm in the uk and I am wondering where I stand on access to my child as his mother is wanting to change his name and not let me be involved in his life at all I am not a bad father and have not done anything wrong to my ex I would just like to know where I stand on this matter
Reg acces
[ 3 Answers ]
When I open the start menu and write in run "regedit" the message told me can not access
Ask your administrator ,no one use my PC what is wrong please help
No acces to harddisk
[ 5 Answers ]
Hi,
I recently bought an extra 80GB harddisk. The problem is: I can't acces it.:confused:
If I take a look in the BIOS, it's there, so my computer recognises it.
I thought I had to update my BIOS, but I already have the latest version.
I REALLY hope you can help me, because I need the...
Cannot Acces My Other Hd - Help!
[ 13 Answers ]
I just had to do a complete, destructive reinstall of WinXP on my HD. Just before I did that, I put my older HD with Win98se in the puter as a slave, to copy all my files, drivers, downloads, and photos onto. It worked, even though I couldn't boot to my c: drive.
I set my BIOS to only open...
Secureing acces to my computer
[ 1 Answers ]
I want to know how can I secure my computer from being accesed by another user who has domain user rights..
My computer is connected to the domain. And I use windows fire wall also
How I can protect ir from being accesed from the above..
Please help
View more questions
Search
|