FuzMic
DataBase Tinker
- Local time
- Tomorrow, 05:43
- Joined
- Sep 13, 2006
- Messages
- 719
Hi friends
I keep the main data in a server type back End in a LAN eg SQLExpress. In this multi user environment, to avoid too much traffic to/from the BEnd, i use .mdb to keep my temporary tables within the workstation which are used only by this particular workstation.
In one particular PC, i met occasional failure to access a selected .mdb; this is happening in Access.02 & 03. I have a feeling it is operating system issue. Do you agree or is it the inherent problem of .mdb?
Can you recommend a better alternative database that does not need a server service to work eg FoxPro. Appreciate your expert views.
I keep the main data in a server type back End in a LAN eg SQLExpress. In this multi user environment, to avoid too much traffic to/from the BEnd, i use .mdb to keep my temporary tables within the workstation which are used only by this particular workstation.
In one particular PC, i met occasional failure to access a selected .mdb; this is happening in Access.02 & 03. I have a feeling it is operating system issue. Do you agree or is it the inherent problem of .mdb?
Can you recommend a better alternative database that does not need a server service to work eg FoxPro. Appreciate your expert views.