MSACCESS FILE OVER NETWORK

Ryan Pigeon

Member
Hi All! I hope everybody's doing ok.

Can someone point me in the right direction. I have a mdb file on my PC and I want to access it. Um, that's it!
 

Intelemarketing

Active Member
Licensed User
Longtime User
Thank you, Erel. Do you know if there are samples for B4A? I did a quick search and only found for B4J. (Newbie, remember! :)
Try searching for "B4A jRDC2" - Shows quite a few examples - Some SQL Server with B4A Connections - I would think that the SQL Server connection Code will be similar to MDB Connection Code
 

Peter Simpson

Expert
Licensed User
Longtime User
Can someone point me in the right direction. I have a mdb file on my PC and I want to access it. Um, that's it!
This should start to point you in the right direction.
 

Ryan Pigeon

Member
This should start to point you in the right direction.
Thanks a mil, Peter!
Try searching for "B4A jRDC2" - Shows quite a few examples - Some SQL Server with B4A Connections - I would think that the SQL Server connection Code will be similar to MDB Connection Code
 

Ryan Pigeon

Member
Try searching for "B4A jRDC2" - Shows quite a few examples - Some SQL Server with B4A Connections - I would think that the SQL Server connection Code will be similar to MDB Connection Code
Thank you! I am really enjoying this journey so far. Should have done it ages ago and got the t-shirt.
 

Ryan Pigeon

Member
This should start to point you in the right direction.
Peter! I managed to access a password protected mdb file via UNCPath!!!!! Damn I'm happy! THANKS A MIL! My first couple of meters on my bicycle with side wheels!!!
 

Ryan Pigeon

Member
You cannot access it directly. You can run jRDC2 on your PC and then access the jRDC2 server.
Hi Erel I got it working with B4J to be able to access mdb file over unc path using UcanAccess. How do I go about connecting B4A app to the B4J server?
 

Erel

B4X founder
Staff member
Licensed User
Longtime User

Sandman

Expert
Licensed User
Longtime User
This is the chit chat forum. This is not the place for B4X questions.
I'll just add one thing, as Ryan Pigeon is new in the forum. Apart from the obvious aspect of keeping the forum in order and have discussions in the right place, there is one very concrete reason for why Erel said that: The search engine (top right on the webpage) doesn't search in Chit Chat. This means that this thread, which might be very valuable for some other person later on, won't be in the search results - obviously a bad thing for that person.

I'll also just drop these links, which are good for newer members:
 

Ryan Pigeon

Member
I'll just add one thing, as Ryan Pigeon is new in the forum. Apart from the obvious aspect of keeping the forum in order and have discussions in the right place, there is one very concrete reason for why Erel said that: The search engine (top right on the webpage) doesn't search in Chit Chat. This means that this thread, which might be very valuable for some other person later on, won't be in the search results - obviously a bad thing for that person.

I'll also just drop these links, which are good for newer members:
Many thanks , Sandman. Yes I was under the impression that Chit Chat meant you could speak/ask anything. Now I know why! Thank you!
 
Top