Limitations of MS Access

REFERENCE: http://www.codeguru.com/forum/archive/index.php/t-235929.html
There is an article Microsoft Access 2000: Choosing between MSDE and Jet (http://www.microsoft.com/sql/techinfo/deployment/70/msdejet.asp) which lists all the limitations of Access database in the Word file (http://www.microsoft.com/sql/techinfo/deployment/70/Access2000MSDE.doc).
Here is extract:
"Appendix B: Access/Jet (.mdb) Specifications

File size (.mdb filetype) 2 GB
No. of objects in a database 32,768
Modules 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048.
Table size 1 gigabyte
Number of characters in a Text field 255
No. of characters in a Memo field (data entered via UI) 65,535
No.of char. in a Memo field (data entered programmatically) 1 gigabyte
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record 2,000
Number of characters in a field property setting 255"

MS Access Programming JOB Links

1. http://www.craigslist.org/nby/cpg/94461117.html
2. http://www.tech-centric.net/search/anonymous/jobdetails.aspx?job=153839
3. http://www.tech-centric.net/search/anonymous/jobdetails.aspx?job=149688
4. Dice.Com
5. http://www.tech-centric.net/search/anonymous/jobdetails.aspx?job=137667
6. http://www.google.ca/search?hl=en&q=MS+Access+Programmer+%2B+jobs&meta=
7. http://www.net-temps.com/job/suda/965/ms_access_programmer.html
8. http://www.tech-centric.net/search/anonymous/jobdetails.aspx?job=147624
9. http://denver.craigslist.org/art/97270542.html
10. MS Access programmer on Baltimore
11. Fun JObs Review
12. Cambria Palo Alto MS Access Programming job
http://www.cambria.com/services_access.asp

RITA'S REFERENCE:
13. http://www.job4you.com/vb.htm
14. Careerbuilder.com
15. Microagility
16.ALR Asociates Inc.
17. KForce.Com
18. HR System Support Analyst - Adecco Technical
19. Indeed.Com Search Result

RESUME RABBIT: http://wvw.jobseekerweekly.com/cgi-bin/submitwriter.pl?ID=144

New Links:
1. http://www.programmingfromhome.com/
2. http://www.prgjobs.com/Job.cfm/217090
3.

Customizing Autonumbers

http://forums.aspfree.com/archive/t-24837/Possible-to-customize-autonumber-in-R
http://www.pcreview.co.uk/forums/showthread.php?p=6617335#post6617335
Fixing autonumbers that act weird: http://support.microsoft.com/?kbid=287756

Number of users Access can Accomodate

http://www.dbforums.com/archive/index.php/t-1079077.html
I agree Access is a very easy to start with database, but here are the
limitations to what Access can do:

1. The theoretical maximum number of concurrent users in an Access database
is 255. However, this figure is just the maximum
number possible, and you are more likely to find that the maximum number of
users is about 50-100, although depending on your
design, this might be less. This should certainly be borne in mind when
starting to design a database, as it is almost guaranteed that
although the initial brief called for only 15 users, after a year of
operation there will probably be twice that using the database.
Therefore over-engineering is required.

2. Also, Access isn't configured to run as a client/server database, so it
isn't optimized for running over a network. A true client/server
application will only call the data from the server to the client that are
needed. Therefore, you will probably see some network
performance degradation.

3. Access is also limited to how much data it can store. In Access 97, this
is 1 Gigabyte per database, and in Access
2000 it is 2Gb, although you can have multiple databases used to store
information in.

I believe this info is relevant for you to decide. I strongly recommmend
that if you haven't yet started with your app design,
switch to SQL as backend, and frontend with something as VB, that gives you
more flexibility and a far better UI.