Gentlemen,
We are planing to shift our MS Access backend of MYSQL server to get the benefit of multi-user environment.
I well remember once I use SQL server as back-end for my MS Access db but it was PC based SQL server I had place my all tbls and managed to get all the tbles linked from SQL server tbls using dbo_ method to MS Access FE.
Sometime it was working any sometime there was write conflict. Definitely there might have somewhere gone wrong but this happened with me in the past. Since then I kept Access back-end in simple file server and connected few users. But when it was on SQL Server personal version, sometime it produce write conflict and some of the fields or sometime whole row in table shows #deleted.....#deleted.
So this time I dont want this issue to appear if I move to MYSQL ( I hope so) because company asked me to make it multiuser.
I will be in need of Experts step-by-step guidelines from this forum so that no more write-conflict. Probably within few days I will start working on tbls to shift one-by-one and then will come for the rest topics....
We are planing to shift our MS Access backend of MYSQL server to get the benefit of multi-user environment.
I well remember once I use SQL server as back-end for my MS Access db but it was PC based SQL server I had place my all tbls and managed to get all the tbles linked from SQL server tbls using dbo_ method to MS Access FE.
Sometime it was working any sometime there was write conflict. Definitely there might have somewhere gone wrong but this happened with me in the past. Since then I kept Access back-end in simple file server and connected few users. But when it was on SQL Server personal version, sometime it produce write conflict and some of the fields or sometime whole row in table shows #deleted.....#deleted.
So this time I dont want this issue to appear if I move to MYSQL ( I hope so) because company asked me to make it multiuser.
I will be in need of Experts step-by-step guidelines from this forum so that no more write-conflict. Probably within few days I will start working on tbls to shift one-by-one and then will come for the rest topics....