Is it posible to convert a single user dB into a mulit user dB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to convert a single user Access database to a multi-user
database? If so, how and what can be some of the major issues?
 
Is it possible to convert a single user Access database to a multi-user
database? If so, how and what can be some of the major issues?
Click to expand...

Access is multiuser by default. You have to go to a bit of effort to
make it single-user!

If the multiple users are on the same (fast, stable) local area
network, it's very strongly recommended that you split the database
into a "backend" containing the tables, and a "frontend" with all the
queries, forms, reports, code, etc. Each user will get a copy of the
frontend. See http://www.granite.ab.ca/access/splitapp/ for a thorough
discussion and instructions. You *can* just put the database on a
shared drive, but doing so risks corruption, bad performance, and
bloating.

If the multiple users are at different sites, connecting over the
Internet, it's tougher! Access wasn't designed to be used over WAN
connections.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Problems converting old DB to Access 2007 1
access runtime and multi user DB 3
How can we convert OST to PDF file format? 1
Access 2000 DB for multiple users with access 2007 front end clien 2
Runtime Error 3436 - Can't use anything in DB 11
Is it possible to Auto Close an Access db at a scheduled time? 6
Convert Access 2003 with security to Access 2007 2

Back
Top