I got a requirement for making a Excel tool for managing books on a library.
They want back end as Access database.
They want to capture all the transaction of all books.
They also want to track the transactions of any book at any point in time.
They gave me the excel which they are maintaining right now.
I got a doubt that sometimes the 2gb which an access database can been used up in two or three months itself.
My current plan is to create separate DB's for each users.
Could you any one let me know if this is fine/ If you have any better Idea?
Please Help.
Thanks in advance
They want back end as Access database.
They want to capture all the transaction of all books.
They also want to track the transactions of any book at any point in time.
They gave me the excel which they are maintaining right now.
I got a doubt that sometimes the 2gb which an access database can been used up in two or three months itself.
My current plan is to create separate DB's for each users.
Could you any one let me know if this is fine/ If you have any better Idea?
Please Help.
Thanks in advance
