Question Sharing a database

[alp]

I want to share my costing database with about 6 other user in my office who do not have Access licenses - is this possible? They do not need access to tables or to change/enter any data, they just need to be able to run reports and set their own parameters. Everyone has some version of MS Office Suite, but some people are working with 2003 and others with 2007.

I am wondering if Sharepoint is an option, and while it might be obvious to others, I cannot figure out if they would require licenses to run and view reports originally created in Access.

MS Help suggests I split the database, store it in a network folder or store it on a database server, but I believe all of these options would require individual Access licenses.

I hope my question is clear and not too ridiculous. Thanks!

 

[boblarson]

You can use the Access 2007 Runtime which is free from Microsoft.

 

[boblarson]

Oh, and yes, you do want to split the database and have the backend (tables only) on the server and a COPY of the frontend on EACH USER's machine.

 

[alp]

You can use the Access 2007 Runtime which is free from Microsoft.

Thank you very much for the help. This looks like it will be the perfect solution for my problem! Now I just wish that I came here sooner! Thanks again

 

[alp]

You can use the Access 2007 Runtime which is free from Microsoft.

I have downloaded Access 2007 Runtime on a colleagues computer, split the database and sent them the front end, but the file cannot be opened. Am I required to develop a package with the "Package Solutions Wizard" to make this all work? Or should I (like I was, possibly naively, hoping) be able to run the front end as is?

Any help/ideas are much appreciated!

 

[alp]

I have downloaded Access 2007 Runtime on a colleagues computer, split the database and sent them the front end, but the file cannot be opened. Am I required to develop a package with the "Package Solutions Wizard" to make this all work? Or should I (like I was, possibly naively, hoping) be able to run the front end as is?

Any help/ideas are much appreciated!

Nevermind! I think I've figured it out myself

 

[Bikers]

I have set up a database on a shared drive for everyone to access the database. This is a peer-to-peer network setup. The database is set to open as shared by default(tools, options, advanced, shared). When any of the computers open the database, none of the other computers can open the database except for the server.

So, if the server or any remote computer opens the database first, the other remote cannot open. I put this same database on another network that is supposed to be set up the same (same company, two stores, same company set up the network) and it works fine. Help!

 

[ghudson]

Everybody opening the database needs full file permissions [open, add, edit, delete] to all the files in the folder where the database is located. Everybody needs to be able to create, edit and delete the record locking file .ldb or .laccdb access creates when the database is opened.