Problems accessing backend

[spectrolab]

Hi,

I have split db with the backend residing on a computer in my workgroup in the shared files folder. I have access to the folder and can view the file perfectly fine on the other computers in the workgroup (a wireless 54Mbps network). The problem I am having is that almost every time i access the backend tables from another computer in the workgroup, access freezes up and has to be shut down. Sometimes, after restarting access it works fine, others not at all.

Any suggestions or help would be greatly appreciated.

 

[ghudson]

Do NOT use a wireless network to connect to an Access database. Access freaks out if the connection is not stable or disconnected [even for a nano second] and you will have to kill [Ctrl+Alt+Delete] the db for it will be locked up and any unsaved changes will be lost and you risk corrupting the indexes of the opened table.