Single user to multiuser

[bells]

How can i change a a single user progrm to be used on the
network?
it uses an Access database and works fine on a single computer the data connection is as follows

Set myConnection = New ADODB.Connection
Set myRecordset = New ADODB.Recordset
'open the connection
myConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\myDatabase.mdb;" & _
"User Id=admin;" & _
"Password="

Thanks in advance.

 

[pweegar]

You'll want to split your database. Put the tables on the server so that all users have access to them. On each client pc, you'll want to have a db that contains forms, reports, etc. You might want to invest in a good book that describes N-tier stratagies and how to deploy multi-user Access apps.

 

[zemp]

If your front end is VB then you just need to move the Access back end to the server. You can have the user browse to create the connection string (Db path) and save it in the registry (via Getsetting and savesetting) for the next time the program is run.

Watch your cursor types and record locking. This becomes much more important in a multi-user environment. See faq222-3670.

How many users? With Access if you exceed 5 concurrent users you can run into some preformance problems (slows right down) so you may need to consider upsizing to MSDE or an enterprise DB (like SQL Server).

Don't forget about security. Users and passwords if necessary.

zemp

 

[bells]

Thank u guys
well can i also do this
install the setup file in each w/station
where the DB is somewhere in a server
and change ONLY the connection string as follows

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;& _
"Data Source=\\myServer\Thepath\myDataBase.mdb"

by the way total users will not be more than 5

thank u very much in advance