Can I have 2 Access Databases?

[cusimar9]

I want to store all the referring websites people access our site from, and I'm considering putting it all in a seperate database.

Is there any advantage? Are simultaneous DB Accesses literally 'per database' or are they limited by the JET Drivers?

[cosmoquest]

Yes, u can use any number of databases.. use diferent connections for different database and use it as required.

I dnt understant ur question, what u meant by this "Are simultaneous DB Accesses literally 'per database' or are they limited by the JET Drivers?"

[cusimar9]

I'm trying to write this so (if possible) its not an additional overhead on the database.

I know MS Access databases are limited in real life to around 10 simultaneous accesses... I was wondering if I had 2 databases if my theoretical maximum simultaneous accesses would be 20 (say)...

[zingmatter]

TBH you will get more than 10 connections to you Access DB (though the quality of your host's server and/or bandwidth can make a difference). That said, we use 2 databases on one of sites - one for handling content delivery, one for membership control. It would spread you db accesses and make life easier for the databases.

[cusimar9]

Yeah It would have been very sensible for me to spread members data and property data across 2 dbs if I'd have thought about it...

If I get problems I may have to reconsider

[Bullschmidt]

I really like to try to keep everything in one database so that I can easily create recordsets (for use in form and report pages) from multiple tables.

Otherwise it MAY still be able to be done but is more complicated.