Maximun size of a database

[Fadoyo]

Hi all, I do have a database where I store Images, now I can't because I
think I have reached the maximun size, is it possible? Which is the maximun
size in MB a database can grow?

Which is the maximun number of rows a table can reach?


Thanks
Fadoyo

 

[Kevin3NF]

max db size for Access 2000 and newer is 2GB.

No explicit number of max rows.

Do not store images in the DB. Access hates that. Store them in a folder
and the path in the db...


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Fadoyo]

And If I am using the an aplication that can connect through a net?

Thanks
Fadoyo

 

[Kevin3NF]

I don't understand your question...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Fadoyo]

I do have a database in a computer and I do write at it the address of a
photo, then I launch the application I use at other computer that connects
with that database throught an ODBC conection, so as the photo is not
located locally at that path I can't see it at the form.

I need to solve this problem, please I would appreciatte a lot any help,
please let me know if you continue without understanding me.

Thanks
Fadoyo

 

[Kevin3NF]

If the photos are stored in the database, you need to move them out into the
file system on the same machine.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Larry Linson]

If you have the pictures stored in an Access (Jet) database and you are
connecting via ODBC, then the front end/user interface is by definition not
Access. Access does not support connecting to an Access/Jet database via
ODBC.

Please clarify... are you connecting from an Access client to some other
database via ODBC, or are you connecting from some other kind of client to
an Access/Jet database. It makes some difference, really it does, that we
have enough information to be able to help.

Larry Linson
Microsoft Access MVP