Limits with access 97 & 2000? 1

[merlin72]

Could someone tell me what the limit size of the data bases are. I think 97 is 1 gig. Is 2000 the same. Also is there a way around this.
Would have used the keyword search but it's still down.
Also, for a big data base should i use a different prog.
Regards
Jim.

 

[GDGarth]

For what it's worth, we're running several large Access databases on our network. Each has about 15 concurrent users and up to 500,000 records in a single table.

The performance is OK.

 

[jemmylad]

I need help !!! Sortta first time user with Access, no training... GOD! Now, I'm setting up a front end so that you have 4 boxes where you can enter a criteria from teh database , you click a button and it will bring back the details that match the criteria you entered.
For Example
Name -> Date -> Age -> (click a button) and it gives you all correspong details.
Here's hoping
James
"Sometimes the more you think there is no answer" - Winnie the Pooh

 

[bigfoot]

Just got off the phone with Microsoft. I spoke to a tech in the customer service department. Took me an hour to talk to this person. She told me not to use MS Access for anything more then a few people. SQL Server was designed to be in a large multi user environment. Access is ok to use, but the amount of programming envolved to open/close files was huge.

She said I have to lock the record by hand each time, and SQL just does it better.

 

[bigfoot]

Found another post...
thread181-108337

thread181-108337

 

[punky]

I have to develop a database to be used on a laptop. The database would be used by only one or two people at one time. Eight(8) records totaling 818 positions (length), with an estimated 1/2 million records total. Looking at Access and SQL server. Any recommendations, suggestions
on whether or not to use Access?

 

[mac318]

The trick to using Access for large tables is to dynamically create archive tables to hold data which isn't needed for current operations. One of my programs archives all data which is a day old because it isn't needed for current operations, for example, sales data. Then it moves the data to another archive table as it ages, and finally the data is moved to a final archive table when it expires. When needed, I link the active table with the appropriate archive table(s) to retrieve aged records. With a little planning, you can use Access to manage very large databases with good access times.

mac

 

[DaOtH]

Topic is still access 97/2000 limits so i quess this is the right place to post this.

I already came up to the 1GB limit of a '97 db but what i was wondering, is there a limit on the total rows you can get into one table. I had a table once with 3 million lines so it should be more than that. Just curious, but has anybody got any idea of the limit ?

(Obviously, as already posted in this thread, i shouldn't be using access at all with a db this size but i am the only one using it and the company isn't planning to get me something else. It's all SAP orderline downloads but i can't do with SAP what i can in Access...)

DaOtH

--
"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[schutt]

Can anyone help with "How to print the Memo field" without cut and paste? I'm not in the same class of knowledge as I see most of you are. Help

 

[tlbroadbent]

shutt,

Please start a new thread for your question. It is off the topic of this thread. If you want to create a report with a memo field I suggest forum703, "Microsoft: Access 4 Reports." See thread181-231806 for descriptions of all the Access forums. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.