how do I share a database?

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

Guest

I bought access for my home computer- I want to create a balance ledger for
a local charity group I support. I was told that I can create a database and
export the DB to a different computer w/o Access- is this correct, if so, how
do you do that?
 
Scott said:
I was told that I can create a database and
export the DB to a different computer w/o Access
Click to expand...

Yes, they can read the data in the tables with any ODBC-compliant application
like Excel. They just connect to the MDB file through their application. If
you want them to see your forms and reports, or run queries or code, they
need Access.
 
Granny said:
Yes, they can read the data in the tables with any ODBC-compliant
application like Excel. They just connect to the MDB file through
their application. If you want them to see your forms and reports,
or run queries or code, they need Access.
Click to expand...

Or you need the developer's version and the runtime program that can be
loaded for free on the other user's machine.
 
Hi Scott,

As others have indicated, you need to either have the capability of
distributing the runtime version of Access, if you want the other users to be
able to use any forms or reports, or you need to use ODBC to connect to the
data stored in the JET database from another application, such as Excel.

To distribute the runtime version, you need to have the correct software on
your PC. Here is a web page that discusses the details:

Microsoft Access (Office) Developer Edition Versions
http://www.granite.ab.ca/access/developereditionversions.htm

If/when you decide that you want to provide the capability of more than one
user accessing your Access application simultaneously, here is an article
that I wrote that you may find helpful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top