Microsoft Access 2000 maximum database size

[Helmut]

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

[David]

Re: Microsoft Access 2000 maximum database size

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
dhodgkins@jstar software.com

https://www.jstarsoftware.com

[Helmut]

Re: Microsoft Access 2000 maximum database size

"David" <dhodgkins@jsta rsoftware.com> wrote in message news:<111136973 2.131288.293340 @f14g2000cwb.go oglegroups.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

[Albert Marshall]

Re: Microsoft Access 2000 maximum database size

Helmut wrote[color=blue]
> 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.[/color]

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

[Helmut]

Re: Microsoft Access 2000 maximum database size

helmutsteinecke r@12move.de (Helmut) wrote in message news:<a9f1c72b. 0503210038.6a43 8afe@posting.go ogle.com>...[color=blue]
> "David" <dhodgkins@jsta rsoftware.com> wrote in message news:<111136973 2.131288.293340 @f14g2000cwb.go oglegroups.com> ...[/color]
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

[Helmut]

Re: Microsoft Access 2000 maximum database size

Albert Marshall <albert.marshal l@stowdata.co.u k> wrote in message news:<XrTDJsCOO xPCFwao@stowdat a.demon.co.uk>. ..[color=blue]
>...have any code that generates a date then it needs to be in the[/color]
correct[color=blue]
> 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.[/color]

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.

[Tony Toews]

Re: Microsoft Access 2000 maximum database size

helmutsteinecke r@12move.de (Helmut) wrote:
[color=blue]
>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.[/color]

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