Access limitations and a few questions, help pls.....

  • Thread starter Thread starter SAH
  • Start date Start date
S

SAH

I am new to Access.

I need to create a new database with approx 15 text and numeric fields.

How big can an Access database be, i.e...how many customers can I have in 1
database.

If I had say 3 databases, can I do a query that will search all 3 databases
at once.

Lastly,....how hard would it be to setup an HTML formmail so that I could
import its emailed result directly into Access,...... if that's possible.

Any and all help would be greatly appreciated, I'm hoping Access can do what
I have described above.

Sean.
 
I am new to Access.

I need to create a new database with approx 15 text and numeric fields.

How big can an Access database be, i.e...how many customers can I have in 1
database.
Click to expand...

You are limited to two billion bytes of data in the entire database.
If you have more than five million or so customers, you may want to
look at another DBMS (though I know of Access databases with
20,000,000 rows in the largest table).
If I had say 3 databases, can I do a query that will search all 3 databases
at once.
Click to expand...

Jargon alert: a "Database" is a .mdb file, a container for multiple
forms, reports, tables, etcetera. I think you're talking about a
Table. You can create searches that span multiple tables, but with a
properly "normalized" structure (and if that word is new to you, you
have some study to do!) it would very rarely be necessary.
Lastly,....how hard would it be to setup an HTML formmail so that I could
import its emailed result directly into Access,...... if that's possible.
Click to expand...

That will be fairly tricky and will require some expert VBA (Visual
Basic for Applications) code, unless somebody else has some knowledge
that I don't.
 
What would be the best and simplest way to have info input to a form online
to be imported directly into an Access database ?

By the way, thanks John.
 
What would be the best and simplest way to have info input to a form online
to be imported directly into an Access database ?
Click to expand...

I'd suggest using Access2002 (which has the most advanced Web
interface capabilities) and set up a Project (a Data Access Page).
 
-----Original Message-----
I am new to Access.

I need to create a new database with approx 15 text and numeric fields.

How big can an Access database be, i.e...how many customers can I have in 1
database.
Click to expand...

Two hundred MegaBytes. The computer must have plenty of
RAM.
If I had say 3 databases, can I do a query that will search all 3 databases
at once.
Click to expand...

Yes, but why set it up that way?
Lastly,....how hard would it be to setup an HTML formmail so that I could
import its emailed result directly into Access,...... if that's possible.
Click to expand...
Access will import any Comma delimited file structure.

Any and all help would be greatly appreciated, I'm hoping Access can do what
I have described above.

Sean.




.
Good luck
Click to expand...
Cardo Davi
 
Back
Top