[RESOLVED] Read/Write from/to an Access database for users who don't have Access

[MartinLiss]

I'd like to use Access to store data that can be read from and written to by multiple users of Excel at the same time without the users having to have Access installed. How can I do that?

[Spoo]

Marty

At first glance, I'm thinking ,, is that legal?

However, upon reflection, I'm thinking that you have Access, and have an
app that others (who have Excel) can "log into". They only want to see stuff
in their Excel WB's that somehow take advantage of your Access files.

Am I close?

Spoo

[MartinLiss]

Yes, I want to store to a database and track the status of transactions that are generated from an Excel workbook. I at first thought of using a shared workbook as the database to store the transaction statuses and actually developed a first draft but I saw too many people who warned that shared Excel workbooks were prone to crashing so I thought I'd pursue Access.

[Spoo]

Marty

I'm still a little fuzzy about how other users communicate with your
computer, but that can wait a while.

FWIW, I'm familiar with Access 2003 (albeit DAO) and Excel 2003, and
using VB6 to read/write from/to both.

If those are useful/available to you, where would you like to start?

Spoo

[techgnome]

all that's needed is the database and the appropriate drivers (either the older Jet or the newer ACE, depending on the version of the database) ... that's it... nothing more. Access is just a front end to the database.

-tg

[westconn1]

no different to working with any database in vb6, just add a reference to ADO (or later version)
create a connection object and recordset objects as required
access database can work with multiple users (not too heavy usage, or some other database would be a better choice)
no requirement for any user to have Accesss installed