Linking Databases / Tables

Results 1 to 2 of 2

Thread: Linking Databases / Tables

  1. #1
    Join Date
    Dec 1969

    Default Linking Databases / Tables

    Hi,<BR><BR>I have two major components for my site, the users information (table1) and their classified ads information (table2). I have decided to split them into 2 .mdb files as I am concerned about the files getting too big. But since I split the tables into two files it makes it much harder to link information. Should I simply combine the two databases together?<BR><BR>How big is too big for database file sizes? I do not want to put too much strain on the server.<BR><BR>Thanks for your help.<BR>-Bruno

  2. #2
    Join Date
    Dec 1969

    Default RE: Linking Databases / Tables

    Don&#039;t split.<BR><BR>There will be more strain on the server if you use two .mdb files. <BR><BR>How big do you think the table will be? If it&#039;s largen than e few dozen mb&#039;s you should consider SQL Server anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts