Access doesn't limit the open connections, just the users. But if you're
hosting the data on a workstation OS, I think recent OS versions are all
limited to 10 connections. Since it looks like you're planning more than 10
users, you should be sure you can host the data file on a server OS. And to
emphasize what John already said, you DEFINITELY want to split your
application into a front-end db and back-end db. Only the backend (just the
tables and relationships) goes on the server. Each user should be runninga
local copy of the frontend (forms, queries, reports, code) that is storedon
their local hard disk.
Thanks for the message,
Do you know the limits on the number of open connections?
Thanks again,- Hide quoted text -
- Show quoted text -
My applications link to 10 backend databases to generate the reports.
The reports have tons sub reports.
User get Too many connections Can not open more databases error
message when user print the report from preview, but it works direct
print without preview.
I just wonder that MS Access rerun the queries and report when user
print the report from preview to make too many connections and the
error message.
Yes, I should move our databases to SQL server, since the complex of
the databases and reports.
It seems our applicaitons and databases reach limitations of MS
Access.
Thanks millions for helping,