473,385 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Microsoft Access 2000 maximum database size

Hello, I am Helmut,

my database has a Frontend of 15.4 MB which cause Acc2K to corruption:
Limit is 12.5 MB. Service Pack 3. On three different PCs with 256, 512
and 1.000 MB RAM. All on W2K, german system. Database is secured and
was corrupted. I gave rights to the aministrator and users to import
all objects, which I did in portions of 25. But how can I avoid SQL
server? I did decompile. Live System runs on english version. There
17 MB do not show any problem. But I have still to develop on a german
system. the number of queries, size of files an so on is not at all at
the limit.

How comes, that a database which has an announced size of 2 GB(!)
becomes corrupted with only less than 13 MB? Since three weeks I try
to compact and repair my secured database. I try to earn my money by
programming databases.

Help is highly appreciated.

Best regards, Helmut
Nov 13 '05 #1
6 4162
Hi Helmut,
I would gues that the corruption is coming from the data you are
trying to put into the fields and not the size of the database. The
database may be expecting data to be formated in English but when you
try to put in a German value it becomes corrupt. Do you have any Date
or Currency fields in any of the tables? These would be prime examples
where something could cause corruption when you run it on a German
computer but it run fine on an English one. It may be a case of writing
code to convert the data from German to the English equivilent.

Hope this helps.
David Hodgkins, MCSD, MCDBA, MCSE
dh*******@jstarsoftware.com
www.jstarsoftware.com

Nov 13 '05 #2
"David" <dh*******@jstarsoftware.com> wrote in message news:<11**********************@f14g2000cwb.googleg roups.com>...
Hi, David,

thats great. I really have to examine my database to get out all
language based formattings. Since there are users from different
countries, I swept out, I think, all currency formatted fields. But I
will check again the forms. Data resides mostly in the backend, which
has no problem with comoressing and repairing. I will check it anyway,
because the frontend queries get their formatting this way.

thank you (1,000.00 times)

(:-))))
Helmut
Nov 13 '05 #3
Helmut wrote
Live System runs on english version. There
17 MB do not show any problem. But I have still to develop on a german
system. the number of queries, size of files an so on is not at all at
the limit.


If it is really a problem caused by having different language versions
the first place I would look is at the way date fields are used. If you
have any code that generates a date then it needs to be in the correct
format for the locale settings in the computer that's running the DB.

The most common problem is between US (month, day, year) and most of
Europe (day, month, year). If I remember correctly, any dates used in
SQL need to be in American format.
--
Albert Marshall
Marshall Le Botmel Ltd
01242 222017
Nov 13 '05 #4
he**************@12move.de (Helmut) wrote in message news:<a9**************************@posting.google. com>...
"David" <dh*******@jstarsoftware.com> wrote in message news:<11**********************@f14g2000cwb.googleg roups.com>...

Hello, theis is Helmut again,

I removed some currency formattings in the frontend database. Exported
and deleted Queries and routines who are not needed at the moment. I
did compact and repair, as well as decompile, but no change. The
database is still corrupted.

When I throw out some objects and import them again, I can proceed up
to a certain point. But after the next corruption, I have to delete
even more objects and the corruption bgins sooner.

Has anybody on this planet any idea?

Helmut
Nov 13 '05 #5
Albert Marshall <al*************@stowdata.co.uk> wrote in message news:<Xr**************@stowdata.demon.co.uk>...
...have any code that generates a date then it needs to be in the correct format for the locale settings in the computer that's running the DB.

The most common problem is between US (month, day, year) and most of
Europe (day, month, year). If I remember correctly, any dates used in
SQL need to be in American format.


Hello, Albert,

many thanks for your impulse. I looked over Frontend and backend.
Eliminated (once more) even the oveseen currency formats in the query
columns. The only date that I used was to extract a month, which
caused problems in former times if libraries are missing, the moment,
I put the english version back to german.

Now there are certainly no generated date formats. And still there is
that tiny problem of damaged database... Looking foreward.
Nov 13 '05 #6
he**************@12move.de (Helmut) wrote:
my database has a Frontend of 15.4 MB which cause Acc2K to corruption:
Limit is 12.5 MB. Service Pack 3. On three different PCs with 256, 512
and 1.000 MB RAM. All on W2K, german system. Database is secured and
was corrupted.


Is this the FE or BE which gets corrupted? If the FE are you giving each user thier
own copy of the FE?

I specifically created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next time someone
went to run the app that it would pull in the latest version. For more info on the
errors or the Auto FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
to date.

In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
a directory named after the user on a server. Given a choice put the FE on the
Citrix server to reduce network traffic and to avoid having to load objects over the
network which can be somewhat sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
9
by: Mike | last post by:
How do I prevent SQL Server 2000 from posting successful backup completion messages to the Windows 2000 Application Event Log? I have scheduled jobs which backup my transaction logs on 50+...
14
by: Sean C. | last post by:
Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...
5
by: sql-db2-dba | last post by:
We have DB2 UDB v8.1 fixpak3 on AIX 5. Production and Development configuarations (at least for DB2) are identical albeit production is a 2-way server while development has only one processor....
1
by: Andrew Arace | last post by:
I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...
35
by: deko | last post by:
Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 =...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
5
by: Doomster | last post by:
I have Office 2000. I am creating a database that will record stats from football, basketball, and hockey games. One table will contain info about a game. The game could be a football,...
11
by: Jamie | last post by:
Greeting! I hope someone can shine a light on a problem I am having. I have 13 users on Access 2000 running FE from various PC and the BE on a new HP Server with Windows 2003, plenty of power...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.