[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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.

0
Ben_Porter40
Asked:
Ben_Porter40
2 Solutions
 
chilternPCCommented:
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)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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now