467,077 Members | 1,016 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

CDaoDatabase Field Limit?

Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.

Jul 22 '05 #1
  • viewed: 1781
Share:
17 Replies
Gareth Tuckwell wrote:
Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one table and I wonder if I have exceeded something?
How the hell could code not _compile_ if you exceeded a _runtime_ limit? Do
you think DAO architects told the compiler maintainers "when you are
compiling DAO, check nobody declares more than X number of fields in a
table"?
If Yes, then does anyone know any workarounds?


Start with http://groups.google.com . This newsgroup is only qualified to
discuss platform-neutral C++ topics.

--
Phlip
http://industrialxp.org/community/bi...UserInterfaces
Jul 22 '05 #2
Thanks for that - is your middle name sarcasm perhaps??

My mistake - I meant the but won't run (it compiles OK) - it fails to append
the table to the database.

"Phlip" <ph*******@yahoo.com> wrote in message
news:g_****************@newssvr16.news.prodigy.com ...
Gareth Tuckwell wrote:
Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one table
and I wonder if I have exceeded something?


How the hell could code not _compile_ if you exceeded a _runtime_ limit?

Do you think DAO architects told the compiler maintainers "when you are
compiling DAO, check nobody declares more than X number of fields in a
table"?
If Yes, then does anyone know any workarounds?


Start with http://groups.google.com . This newsgroup is only qualified to
discuss platform-neutral C++ topics.

--
Phlip
http://industrialxp.org/community/bi...UserInterfaces

Jul 22 '05 #3
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one table and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.

Jul 22 '05 #4
Gav
think this is what your after.
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited by available memory 255
columns per table 1024 255
table size limited by available storage 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
SQL statement size 65,536 * Network packet size
(4 KB, by default) approximately 64,000
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:K9***************@newsfe2-win.ntli.net...
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one

table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.


Jul 22 '05 #5
Gav
Take a look here. 2k not 97 but will give you some idea.

Gav

"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:K9***************@newsfe2-win.ntli.net...
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
Does anyone if there is a limit on the number of fields or the number of
tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one

table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.


Jul 22 '05 #6
Gav
Tell you what. Here's the link too. :o)

http://www.databasejournal.com/featu...le.php/2204341

"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@hercules.btinternet.com...
Take a look here. 2k not 97 but will give you some idea.

Gav

"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:K9***************@newsfe2-win.ntli.net...
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
Does anyone if there is a limit on the number of fields or the number of tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one

table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.



Jul 22 '05 #7
Thanks, that is exactly the information I need, only I am linking to
Access97 and these figures are for Access2000. Is there an Access 97 version
of this info?

Thanks.

GT
"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@sparta.btinternet.com...
think this is what your after.
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited by available memory 255
columns per table 1024 255
table size limited by available storage 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
SQL statement size 65,536 * Network packet size
(4 KB, by default) approximately 64,000
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:K9***************@newsfe2-win.ntli.net...
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
Does anyone if there is a limit on the number of fields or the number of tables in an Access97 database?

My code suddenly won't compile after I have added a few fields in one

table
and I wonder if I have exceeded something?

If Yes, then does anyone know any workarounds?

GT.



Jul 22 '05 #8
Gav
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:Qn***************@newsfe2-win.ntli.net...
Thanks, that is exactly the information I need, only I am linking to
Access97 and these figures are for Access2000. Is there an Access 97 version of this info?

Thanks.

GT
There is a specification document for Access 97 database on Microsoft
website somewhere but I could not find it. Have a look through the documents
online, its in there somewhere, I thought I had a copy of it but I don't.
Would think the specs are very similar to 2k.

Gav


"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@sparta.btinternet.com...
think this is what your after.
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited by available memory 255
columns per table 1024 255
table size limited by available storage 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
SQL statement size 65,536 * Network packet size
(4 KB, by default) approximately 64,000
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:K9***************@newsfe2-win.ntli.net...
I meant to say, the code no longer RUNS (it compiles just fine)!
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:ro***************@newsfe6-win.ntli.net...
> Does anyone if there is a limit on the number of fields or the number
of
> tables in an Access97 database?
>
> My code suddenly won't compile after I have added a few fields in

one table
> and I wonder if I have exceeded something?
>
> If Yes, then does anyone know any workarounds?
>
> GT.
>
>
>



Jul 22 '05 #9

"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@hercules.btinternet.com...
Tell you what. Here's the link too. :o)


Gareth and Gav:

*Please* cease discussion of this topic on this newsgroup.

This newsgroup is for discussion of ISO standard C++ issues
only. Gareth, how you decided that MS Access is topical here
is beyond me.

Purpose of comp.lang.c++:
http://www.slack.net/~shiva/welcome.txt

If you want to find a forum where MS Access is topical, visit
www.groups.google.com and/or www.msdn.microsoft.com

Thank you.
-Mike
Jul 22 '05 #10
Gav

"Mike Wahler" <mk******@mkwahler.net> wrote in message
news:yS*****************@newsread2.news.pas.earthl ink.net...

"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@hercules.btinternet.com...
Tell you what. Here's the link too. :o)


Gareth and Gav:

*Please* cease discussion of this topic on this newsgroup.

This newsgroup is for discussion of ISO standard C++ issues
only. Gareth, how you decided that MS Access is topical here
is beyond me.

Purpose of comp.lang.c++:
http://www.slack.net/~shiva/welcome.txt

If you want to find a forum where MS Access is topical, visit
www.groups.google.com and/or www.msdn.microsoft.com

Thank you.
-Mike


Sorry 'bout that. Just thought it better to give an answer, rather that let
it drag on for ages.
Jul 22 '05 #11
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them. I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question. To answer your (sarcastic) point -
I decided that my question was 'topical' because I am a C++ developer with a
problem in C++ and this seems to be listed as a C++ newsgroup. I had
exhausted my usual sources of information, therefore I presumed that a C++
question in a C++ newsgroup would be 'topical' - forgive my mistake!!! Sorry
to have bothered you - here's a thought - why don't you just read the
postings that are of interest to you and ignore the ones you don't have
anything useful to contribute to. I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on them
instead??

Thanks for the info Gav, you have been most helpful.

I'll go back into my shell and disconnect myself from newsgroups world now.

GT
"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@sparta.btinternet.com...

"Mike Wahler" <mk******@mkwahler.net> wrote in message
news:yS*****************@newsread2.news.pas.earthl ink.net...

"Gav" <ga************@nospam.btinternet.com> wrote in message
news:cc**********@hercules.btinternet.com...
Tell you what. Here's the link too. :o)
Gareth and Gav:

*Please* cease discussion of this topic on this newsgroup.

This newsgroup is for discussion of ISO standard C++ issues
only. Gareth, how you decided that MS Access is topical here
is beyond me.

Purpose of comp.lang.c++:
http://www.slack.net/~shiva/welcome.txt

If you want to find a forum where MS Access is topical, visit
www.groups.google.com and/or www.msdn.microsoft.com

Thank you.
-Mike


Sorry 'bout that. Just thought it better to give an answer, rather that

let it drag on for ages.

Jul 22 '05 #12
Gareth Tuckwell wrote:
I'll go back into my shell and disconnect myself from newsgroups world now.

Oh, no you don't. You stay here and try to answer some questions. (Try a DAO
newsgroup, too.)

You see how cheerful you remain after the billionth off-topic question!
Gav wrote:

Sorry 'bout that. Just thought it better to give an answer, rather that
let it drag on for ages.


When you answer off-topic, advise the newbie that other newsgroups are "more
qualified". That means their best interests are served by going there.

--
Phlip
http://industrialxp.org/community/bi...UserInterfaces
Jul 22 '05 #13

"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:fs***************@newsfe2-win.ntli.net...
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question.
Your question was not about C++ at all, but about MS Access.
To answer your (sarcastic) point -
My point was not sarcastic at all, simply accurate.
I decided that my question was 'topical' because I am a C++ developer with a problem in C++ and this seems to be listed as a C++ newsgroup.
I don't understand how one couldbelieve that MS Access and C++ are
the same thing.

One is a platform-independent programming language, the other is a
proprietary programmable database product.
I had
exhausted my usual sources of information,
Everything one could want to know about MS Access is available from
it's author, Microsoft Corporation, at www.msdn.microsoft.com. Included
at that site are links to newsgroups which discuss various Microsoft
products and technologies.
therefore I presumed that a C++
question in a C++ newsgroup would be 'topical'
There were no C++ questions asked, only MS Access ones.
- forgive my mistake!!!
I suppose I can do that. But now you've been informed that C++
and MS Access are not nearly the same thing at all. The former
is topical here, the latter is not.
Sorry
to have bothered you
No bother at all.
- here's a thought - why don't you just read the
postings that are of interest to you
I do.
and ignore the ones you don't have
anything useful to contribute to.
I contributed to the group as a whole by trying to educate you
about its topic, hopefully with the result that you'd refrain
in the future from posting off topic material here, thus reducing
the noise/signal ratio.

The other contribution (to you and possibly others) is the
actual information I gave, that MS Access is not topical here,
and what the actual topic is. How you will use this information
remains to be seen.
I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on them
instead??
1. Keeping this group on topic is a group effort. Typically the
regulars will take turns with this task.

2. The messages appearing on on news server won't necessarily be
the same as for others (including yours).
Thanks for the info Gav, you have been most helpful.
But not to the group, he simply helped to continue an
off topic thread.
I'll go back into my shell and disconnect myself from newsgroups world

now.

No need to do that. All you need to do is educate yourself.

No hard feelings, really.

-Mike
Jul 22 '05 #14
Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.

If you are only interested in 'pure' C++ then you had better dissuade all
those people who need help linking to DLLs, coding for networks (TCP-IP is
not C++), programming in C++ for windows etc. In fact you will probably
alienate most people who use C++.

If you read your own answer regarding VB6 on the 6/6/04, you will notice
that you talk about Fortran - now how you can possibly think that either
Fortran or VB is 'topical' in a C++ forum is beyond me. If you check with
someone who knows about matters other than pure C++ (unlike yourself), you
will find that Fortran and VB are both other programming languages and I
don't think you should be talking about them here. Perhaps you should go
away and 'educate yourself'. You have let the group down and therefore let
yourself down.

You recommend that I should educate myself - I did say this was the first
time I have used newsgroups and there is a reason for that - in 9 years of
C++ programming, I have never needed to come to a newsgroup for help as I or
my colleagues have either been able to solve any problems we have
encountered, or found a solution in books or computer based reference
materials.

For your education, I repeat that am not programming in MS Access, but I am
using the CDAO library classes as bundled with Visual C++. The error
messages being generated at run-time are from this library of CDao classes.
These classes provide the programmer with access to the Microsoft Database
Access Objects. Whilst it is the same underlying functionality as sits
behind the MS Access tool, MS Access is not even required on the same PC to
write the code I am working with. Perhaps you should get your facts straight
before you start comparing C++ to MS Access - something you have clearly
shown that you are ignorant about. This technique is called reuse - a
technique whereby a number of programmes share the same DLLs or libraries,
reducing testing time, development time, disk and code space etc, but of
course you wouldn't know about that because you only know purely about the
C++ language - perhaps you should broaden your horizons and join the real
world rather than wasting everyone's time berating newcomers in the world of
newsgroups.

I think you are rude and abrupt and I do not want to have anything more to
do with this newsgroup. Quite how you managed to be placed in charge, I
don't know, but I think it was a mistake as your knowledge is obviously
extremely limited. I will be disconnecting from it once I have posted this
reply, so as not to give you the satisfaction of knowing that I am reading
another of your snotty replies.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I think you should go away and read the part about being courteous!

I hope you enjoy fielding off other future experts.
GT BSc Hons PGDip MSc MCSE SSE BCS
"Mike Wahler" <mk******@mkwahler.net> wrote in message
news:SZ*****************@newsread2.news.pas.earthl ink.net...
"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:fs***************@newsfe2-win.ntli.net...
Mike,

I didn't know there were rules about newsgroups - this is the first time I have used them.
A good education about what Usenet is, how it works, and
how to use it courteously and effectively is available at:
www.usenet.org
I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title. I
selected this one and posted my question.


Your question was not about C++ at all, but about MS Access.
To answer your (sarcastic) point -


My point was not sarcastic at all, simply accurate.
I decided that my question was 'topical' because I am a C++ developer with a
problem in C++ and this seems to be listed as a C++ newsgroup.


I don't understand how one couldbelieve that MS Access and C++ are
the same thing.

One is a platform-independent programming language, the other is a
proprietary programmable database product.
I had
exhausted my usual sources of information,


Everything one could want to know about MS Access is available from
it's author, Microsoft Corporation, at www.msdn.microsoft.com. Included
at that site are links to newsgroups which discuss various Microsoft
products and technologies.
therefore I presumed that a C++
question in a C++ newsgroup would be 'topical'


There were no C++ questions asked, only MS Access ones.
- forgive my mistake!!!


I suppose I can do that. But now you've been informed that C++
and MS Access are not nearly the same thing at all. The former
is topical here, the latter is not.
Sorry
to have bothered you


No bother at all.
- here's a thought - why don't you just read the
postings that are of interest to you


I do.
and ignore the ones you don't have
anything useful to contribute to.


I contributed to the group as a whole by trying to educate you
about its topic, hopefully with the result that you'd refrain
in the future from posting off topic material here, thus reducing
the noise/signal ratio.

The other contribution (to you and possibly others) is the
actual information I gave, that MS Access is not topical here,
and what the actual topic is. How you will use this information
remains to be seen.
I notice a chain of 9 'test' messages
yesterday in the list of postings - perhaps you could go and pick on

them instead??


1. Keeping this group on topic is a group effort. Typically the
regulars will take turns with this task.

2. The messages appearing on on news server won't necessarily be
the same as for others (including yours).
Thanks for the info Gav, you have been most helpful.


But not to the group, he simply helped to continue an
off topic thread.
I'll go back into my shell and disconnect myself from newsgroups world

now.

No need to do that. All you need to do is educate yourself.

No hard feelings, really.

-Mike

Jul 22 '05 #15
Gareth Tuckwell wrote:

Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.
If this 'expert' doesn't understand what this group is all about and
what rules it has, I would say: let him go.

If you are only interested in 'pure' C++ then you had better dissuade all
those people who need help linking to DLLs, coding for networks (TCP-IP is
not C++), programming in C++ for windows etc. In fact you will probably
alienate most people who use C++.
Not at all. There are groups for all of the above. In this group
none of the above is on topic. There is enough left in the C++ language
to talk about and help people with things that *are* on topic.

If you read your own answer regarding VB6 on the 6/6/04, you will notice
that you talk about Fortran - now how you can possibly think that either
Fortran or VB is 'topical' in a C++ forum is beyond me. If you check with
someone who knows about matters other than pure C++ (unlike yourself), you
will find that Fortran and VB are both other programming languages and I
don't think you should be talking about them here. Perhaps you should go
away and 'educate yourself'. You have let the group down and therefore let
yourself down.
We all make mistakes from time to time.

You recommend that I should educate myself - I did say this was the first
time I have used newsgroups and there is a reason for that - in 9 years of
C++ programming,
Nobody questioned your C++ expertise. You got that in the wrong throught.
You say for yourself that this is the first time you have used a newsgroup.
Newsgroups have rules. Mike suggested to educate yourself about how
things are working in a newsgroup. But with no word did he questionize your
C++ knowledge.
I have never needed to come to a newsgroup for help as I or
my colleagues have either been able to solve any problems we have
encountered, or found a solution in books or computer based reference
materials.
No problem with that. You just picked the wrong newsgroup for your question.
That's all that is to say about it.

For your education, I repeat that am not programming in MS Access, but I am
using the CDAO library classes as bundled with Visual C++. The error
messages being generated at run-time are from this library of CDao classes.
Which is a strong hint, that your problem is not about C++ per se, but about
how to use this library. This library is not part of standard C++, thus
it is off topic in this group.

[snip]
I think you are rude and abrupt and I do not want to have anything more to
do with this newsgroup.


Fine. The only one who is rude now is you.

--
Karl Heinz Buchegger
kb******@gascad.at
Jul 22 '05 #16

"Gareth Tuckwell" <co*******@hotmail.com> wrote in message
news:SR***************@newsfe1-gui.ntli.net...
Congratulations Mike, you have managed to reduce the expert pool in this
group by 1 today.


Gareth, you made a mistake, its no big deal, this is your first time in
newsgroups. Questions about CDAO are not on topic in this group, its as
simple as that. I'm sure there is an appropriate group, why not find out
what it is instead of complaining to this group. You could even ask this
group, that would be perfectly acceptable.

So people have been more abrupt than you would like in pointing out that
mistake. It's par for the course in newsgroups, its not personal.

John
Jul 22 '05 #17
In message <fs***************@newsfe2-win.ntli.net>, Gareth Tuckwell
<co*******@hotmail.com> writes
Mike,

I didn't know there were rules about newsgroups - this is the first time I
have used them. I only just configured Outlook Express to use newsgroups
this afternoon and it produced a list of groups with C++ in the title.


Did the list include news.announce.newusers ? I'd recommend reading its
contents before proceeding any further with your Usenet adventure.

--
Richard Herring
Jul 22 '05 #18

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Neven Klofutar | last post: by
2 posts views Thread by J. Marshall Latham | last post: by
3 posts views Thread by Julien | last post: by
4 posts views Thread by subaruwrx88011@gmail.com | last post: by
reply views Thread by josh.23.french | last post: by
reply views Thread by mokoujan@yahoo.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.