while a single access database file has a size limitation of 2 gigabyte, I have been given two options in my previous post and those are:
a. upsize to sql server or
b. you can always create multiple backends.
And so since I am not yet familiar with nor have backgrounds nor have learned about sql server yet, I opted to take option b.
however, in my recent post here in the forum, I was advised not to create multiple backends because it will cause me trouble in the future.
this is my situation:
Backend Databases:
1. customer database
2. supplier database
3. user database
4. company database
5. products(items) databases
6. transactions databases
7. tax database (holds tax types and related items)
8. etc
Frontend Databse:
All the backends databases (TABLES) are linked into this front end.
Purpose:
The purpose of multiple backends are:
1. for synchronization purposes to the main office/company backend databases
2. for anticipation that some databases will reach its 2 gigabyte limit in the years to come.
So I dont understand now why they given me option to create multiple backends and now advice me not to do so. I cant seem to understand why. Any feedbacks ?
a. upsize to sql server or
b. you can always create multiple backends.
And so since I am not yet familiar with nor have backgrounds nor have learned about sql server yet, I opted to take option b.
however, in my recent post here in the forum, I was advised not to create multiple backends because it will cause me trouble in the future.
this is my situation:
Backend Databases:
1. customer database
2. supplier database
3. user database
4. company database
5. products(items) databases
6. transactions databases
7. tax database (holds tax types and related items)
8. etc
Frontend Databse:
All the backends databases (TABLES) are linked into this front end.
Purpose:
The purpose of multiple backends are:
1. for synchronization purposes to the main office/company backend databases
2. for anticipation that some databases will reach its 2 gigabyte limit in the years to come.
So I dont understand now why they given me option to create multiple backends and now advice me not to do so. I cant seem to understand why. Any feedbacks ?