Can users without access installed update?

[danmack]

Hi,

We have an access database stored in a shared location. One of the tables in the database is used to record transactions made in an excel spreadsheet-this is done programatically using VBA and SQL.

So here is my silly question; If users don't have access installed locally will the code be able to write to the shared access database?

If not is there a workaround that anyone knows of?

Thanks

Dan

 

[David R]

What you are doing now (sharing a single database for data entry) WILL CORRUPT YOUR DATA. Sooner rather than later, probably. You should split your database into a front end (with the forms, reports, queries, and LINKED tables), and a shared server backend that stores the actual data for everyone.

If you do not have the user licenses for Access on each desktop, look into the Access Runtime. It's a free downloadable version for endusers.

 

[pbaldy]

And if you're asking if the users can still update the Access table from the Excel spreadsheet, probably yes.

 

[Pat Hartman]

"Access" is the RAD tool we use to develop forms/reports/macros/modules/queries. Jet and ACE are the database engines that "Access" uses to hold its own objects. Jet for A2003 and earlier and ACE for A2007 and newer. The database engine is separate from Access and can be installed separately. So, queries in Excel can get data from an "Access" database because they use Jet or ACE and not Access.

 

[danmack]

Thanks for the info guys, i'll look into access runtime and split the database as per you advice, makes a lot of sense.