Can multiple users read and write to a single database via ADO?

I am at the planning stages of a project which will evetually be distributed to many users in my company (over 150). Without getting into too much detail about the project I need to know whether using an ADO connection to an Access 2007 database from Excel 2007 will cause any problems with multiple users trying to read/write to the database at the same time, or am i barking up he wrong tree completely?

Any help greatly appreciated.

Ben_Porter40Asked:
Who is Participating?
 
chilternPCConnect With a Mentor Commented:
there is a limitation on how many simulataneous open connections you can have with access,
but if you design the code to :
   open the connection
      do some stuff
  close connection
then you should be able to have multiple access, but you may have people overwriting each others changes.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
 
  You can use A2007, but do not use JET for the database engine.  Use something like SQL Server for the DB engine.   SQL Sever Express is free.

JimD
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.