ny advantage by linking two mdb together?

[markask]

Hi,

I found the tables in my database file are not enough but I don't want to add more tables into the database: too many users, sometimes it causes error.
Do you think is there any advantage by adding some tables in a new database file and linking two database file together?

 

[nicklieb]

not really the best Idea having 2 different database files for the same database.

My advice would be to use a proper database package like MS SQL server, if you cannot afford that then try this

http://www.mysql.com

-- it's free! and

dl this for administration

http://www.mysql.com/products/administrator/

I also use this for quickly creating tables and users

http://www.mysql.com/products/mysqlcc/

much better.

So my advice is this.

Use mysql for live applications and use access for dev work - using the views you can quickly take the code place it into the script for complicated joins and unions