This is correct. The OP will have to put the database in a shared location.
Henry Wong wrote:If memory serves, Access is a file based database. If you want network sharing, the file will need to be placed on a shared folder.
Of course, this was a while ago. Haven't played with Access in a while.
Philipe Breiding wrote:Hello everyone,
I am trying to access a databaste that is stored on a remote computer within my LAN network. So far I have assembled the following code:
If I try entering the IP address of the remote computer in conjunction with the database file path after "DBQ=", I get an error.
Can anyone help? Thanks in advance!
Philipe Breiding wrote:
I did a bit of research and often come across "DSN connections" in order to access the database via LAN. Does anyone know how to do this? I also attempted to write client/server socket-based classes which establish a connection on a specific port. I can connect the two computers, I'm just not too sure where to put the database commands. This is a school project, so no major code is required.
I also attempted to write client/server socket-based classes which establish a connection on a specific port. I can connect the two computers, I'm just not too sure where to put the database commands.
Philipe Breiding wrote:Unfortunately, we HAVE to use MS access, so my only option would be to place it into a shared folder and enter the IP address of the remote computer where it says DBQ= right?
Philipe Breiding wrote:I would really prefer to use the previously mentioned client/server classes as that would result in more marks for originality do you think it would be possible to do this?