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

[amorosik]

I've linked to a post that provides a solution
That link also contains an example (source code) of a program that uses the UcanAccess library
So if you write "..yet you refused to elaborate.." you should know you're writing something untrue
Why?

 

[Pat Hartman]

Sorry, I missed the link. "this" wasn't highlighted so it looked like there was no link.

 

[Pat Hartman]

OK. I looked at the link. How will the calling app locate the phone to make the connection assuming this is what @prabha_friend wants to do? Why anyone would store a live, shared BE on a phone is beyond me though. And because this tool does not support file sharing, what are other clients supposed to do while someone else has the BE opened exclusive?

 

[Edgar_]

I'd create a web API that both projects can access and be done with it.

If an .accdb file is what I must use, then I'd put the file in a Windows server. That way, if either of the projects sends an HTTP request, the server simply connects to the .accdb file, does its business and returns what you asked for.

If a sqlite database is to be used, same thing, but the server could be whatever, not necessarily Windows.

 

[amorosik]

... is beyond me though....

You're not the one who has to think about how the system should be set up
The colleague asked some questions; if you know the answer, you can help him
Otherwise, save the ink

 

[amorosik]

Sorry, I missed the link....

Yes, okay, you're excused