By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

Opening a database to be used by all

P: 56
Once I have finished making a database, how can I make it available for all users to use? There are only 2 Access licences in my office, mine being one of them. I was hoping to compile it having its own front end, for users to use. Is this possible?
May 9 '07 #1
Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,638
Once I have finished making a database, how can I make it available for all users to use? There are only 2 Access licences in my office, mine being one of them. I was hoping to compile it having its own front end, for users to use. Is this possible?
I'm not sure about the licensing part, but by default your Database will allow Multiuser Access. Just make sure the following option is set to the proper setting: Tools ==> Options ==> Advanced ==> Default open mode = Shared.
May 9 '07 #2

P: 56
Hm, seems to be shared by default.

The user in question doesn't have Access installed on his PC due to the licencing issue. Was looking for something like a database viewer that can view and use forms etc without needing Access installed.
May 9 '07 #3

ADezii
Expert 5K+
P: 8,638
Hm, seems to be shared by default.

The user in question doesn't have Access installed on his PC due to the licencing issue. Was looking for something like a database viewer that can view and use forms etc without needing Access installed.
If you build an Access database (.mdb) as the front-end application, you can deploy the database to users who do not have Access on their workstations by distributing it together with the run-time version of Access. The Access Runtime is a version of Access for which certain features have been disabled, including the ability to create and modify databases. I'm not sure,but I think you will need to purchase the Microsoft Office Developer software in order to obtain this functionality which probably puts you right back at square 1.
May 9 '07 #4

P: 56
That sounds handy, I will investigate with out IT dept for this!

Thanks!
May 9 '07 #5

P: 56
I think you will need to purchase the Microsoft Office Developer software in order to obtain this functionality which probably puts you right back at square 1.
...and you are correct! An outlay of 600. It seems the MS machine is very good at ensuring you give them money.
May 9 '07 #6

ADezii
Expert 5K+
P: 8,638
That sounds handy, I will investigate with out IT dept for this!

Thanks!
You're welcome.
May 9 '07 #7

Denburt
Expert 100+
P: 1,356
...and you are correct! An outlay of 600. It seems the MS machine is very good at ensuring you give them money.
HAH, you are so correct there check this out for 2003 though roflmao!

http://office.microsoft.com/en-us/ac...208861033.aspx
Microsoft Office Access 2003 retail product, and the royalty-free Access runtime license is a component of the Access 2003 Developer Extensions. Even though the runtime software is included in the Microsoft Office Access 2003 retail product, the right to distribute the runtime is not included. You must purchase the Access 2003 Developer Extensions to obtain a royalty-free license to package and distribute the runtime.
May 9 '07 #8

ADezii
Expert 5K+
P: 8,638
...and you are correct! An outlay of 600. It seems the MS machine is very good at ensuring you give them money.
I forget what promo it was, but it was something to the effect
You can pay me now, or you can pay me later!
May 9 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.