Hi All,

Can anyone let me know the limitations that MSAccess has or any links that read about its limitations. I have recently got to work on ASP with MSAccess. Though not new to MSAccess, I would like to cleary study the limitations before start working on this. Else I would suggest the client to go for MSSQL Server, if MSAccess isn't that suitable.

Any help would be appreciated.

Cheers!


-Vijay G

__________________
- Vijay G

The documentation of ACCESS 2000 gives the following information


code:--------------------------------------------------------------------------------
Microsoft Access database general specifications
This information from another site

Hope it starts you off!

Microsoft Access database (.mdb) file size 2 gigabytes.
However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 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 concurrent users 255

That really helps. Thanks for the timely reply.

My project deals with storing multilingual content. The whole website content got to be pulled from the database.

1) Is that possible storing multilingual content?
2) Do I have to keep in mind something for storing languages other than English? Eg: as in SQL it got to be NVARCHAR and N prefixed the values when insert/update. Is something similar to this be followed here?
3) How long the data can be(Max Length of the text/memo datatypes)?
4) Does it support stored procedures unlike access97?

If any relative links, please forward me.

Thanks again in advance.
Cheers!

-Vijay G

Here are a few links

http://support.microsoft.com/default...en-us%3B302524

http://www.mvps.org/access/general/gen0011.htm

Wow, That was too much. My brain started bulging out little. That was very much usefull. Thanks much.

Cheers!

-Vijay G

Well, Access does not support stored procedures. An Access project does run SQL Server stored procedures, but the stored procedure resides and runs on the server.



Sal