Q: Regarding back-ends, is it better to have one or several linked dbs?

[John]

Anyone have any comments on the advantages and/or disadvantages to
having either a single, large db for a backend....or using several,
smaller linked dbs for the backend. Also, how relevant of an issue is
this for later SQL db conversion?

Thanks,
John

[Tony Toews]

so*********@hotmail.com (John) wrote:

Anyone have any comments on the advantages and/or disadvantages to
having either a single, large db for a backend....or using several,
smaller linked dbs for the backend.
I'd use a single, large MDB as you can then have referential integrity between the
tables. Unless you're close the 1 or 2 GB limit.
Also, how relevant of an issue is
this for later SQL db conversion?

Not at all because you can then put them in one db in SQL Server and link to them
seperately.

Note that if you're thinking of going to SQL Server there are things you should avoid
now. Such as using functions in queries.

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

[Mike MacSween]

"John" <so*********@hotmail.com> wrote in message
news:90**************************@posting.google.c om...

Anyone have any comments on the advantages and/or disadvantages to
having either a single, large db for a backend....or using several,
smaller linked dbs for the backend. Also, how relevant of an issue is
this for later SQL db conversion?

One thing I've just run into setting up multi user access. Some users will
have read-only access. That's done through Access security, front end and
back end. But I should obviously set NT permissions too. However there's an
error logging table in the back end, which may get written to even for read
only users. So now I've realized that needs to be in a seperate mdb. Because
even the read only users will need write rights to that.

Just a thought.

Yours, Mike MacSween