How to access the same database file between two projects in a Visual Studio Solution?

[prabha_friend]

There are people in this world who has done, doing and does so many great things. I know I cannot do the following but just asking:
"If at all I want to build something which make an accdb to be readable and writable in all OS (Windows, Linux, Android and Tizen) where should I start?"
"The people who are crazy enough to think they can change the world are the ones who do." - Sometimes I wanna

 

[AccessBlaster]

Excel doesn't use the SMB protocol and has different file characteristics. Also different file locking characteristics.

True, I might be easily impressed, it was like magic to me 20 years ago.

 

[The_Doc_Man]

There are people in this world who has done, doing and does so many great things. I know I cannot do the following but just asking:
"If at all I want to build something which make an accdb to be readable and writable in all OS (Windows, Linux, Android and Tizen) where should I start?"
"The people who are crazy enough to think they can change the world are the ones who do." - Sometimes I wanna

The problem is "Access", not "database." Because of the database being built using 30-year-old SMB protocols and concepts, you have structural constraints. In a way, it is these constraints that cause network IT guys to sometimes hate Access despite its advantageous features.

I don't know what Xenforo uses but you KNOW it has to be based on a database engine of some kind, and it works with Windows, UNIX, Android, and other clients in other operating systems, and all you need is a web browser. We know that a web-based database DOES work. The problem isn't about databases, it is about Access databases specifically and narrowly considered.

As much as I really enjoy Access databases, I have seen other DBs internally (ShareBase, for example) and the internal layout of those databases is well documented. It is the proprietary DBs that try to capture their audience (literally make them a captive audience) that are the tough nuts to crack.