Back End on Virtual Machine

[Relwal]

I have an Access database (accdb) that uses unbound forms (everything done with vba) for the team to input information. Our only shared workspace is a virtual machine, so my idea is to split the database, give everyone a copy of the front end and put the back end on the virtual machine.



How though do I connect the two?

[Bulzie]

If everyone can get to that shared workspace(network drive), then put the BE(tables) there and link the FE(forms, etc.) to the BE. Give everyone the FE on their PC.

[Relwal]

Hi,
Thanks for your reply, I realise now I didn't give enough information, so apologies.
We have to connect to the virtual machine with RDC, it is not a network drive on our machines. Can I make it a networked drive? Is there a way to connect front end with back when I have to connect with RDC?

thanks

[Bulzie]

I'm not a network guy but I think if it is in your domain, you should still be able to link the tables to it. Try it out and see. Move BE and then create an ODBC connection to that server and program. Then try to link them to a FE on your PC.