Ms Access for multiple-users

[shameemaj2]

HI

I have developped a system with msAccess. However, i now have to put it on an company's WAN and allow multi-user access.
I have experienced that the db is not allowing multi-user environment.

I am not versed in this area. Could u inform me better concerning ms access on a network and if it will be inevitable to move to SQL server?
I have read that the s/w requires changes and subsequent modifications?

Thanks a lot

[matthewp]

Hi
You are correct Access is not strictly multi user but can be used as such. There are plenty of links here: http://www.google.co.uk/search?hl=en&q=ms+access+multiuser&meta=.There are certain things to consider. Quite a useful article can be found here: http://articles.techrepublic.com.com/5100-10878_11-1060201.html.
Although, ideally, for a multi user database I would always use a true multi user system such as SQL server/Oracle etc. but this may be overkill for your requirements.
Converting an application from using Access to SQL Server should be fairly trivial but this depends on how many Access specific features you have used. If you are lucky then you may be able to get away with just changing the connection string.

Matt

[shameemaj2]

matthewp
thanks for the links. I read and unsderstood that msaccess could still be used for a multi-user env. (but limited)

it is said that connection strings and recordsets should be adapted.
However, since i used bounded controls on my forms, where will I be able to access and change my connection string?

thanks for your precious help

[dglienna]

You should get away from bound controls. It only takes a little more work to load the data yourself, using SQL code. Once you've done that, you only need to change the connection string to use other db engines. You might be able to adapt a bound control to SQL Server, but I guarantee that using SQL would give you 1000% more control.

[cjard]

making your access db a multi-user access db? That's sure going from the frying pan into the fire..

[dsrahul]

Cjard ,
But the features which are incorporated in the tables & in the Build connection Box says"
Read/Deny=None
Allow=all/none/one
Why these are there?
Rahul