Splitting DB question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kent McPherson - 18 Jan 2008 19:41 GMT

I've read thru several threads on splitting an access database and
understand I have to use the built in utility to create the front-end and
back-end pieces. When I give all the users the front-end piece, to they
have to have Access on their PC to use the database or is there a run-time
package that allows them to use the database with having an Access license?

Reply to this Message

Jeff Boyce - 18 Jan 2008 20:15 GMT

Kent

You do NOT have to use the utility. You can do it manually (make two
copies, take the data out of one, take everything else out of the other,
then "link" to the data in the first -- it's split!).

There is an Access runtime that doesn't require a full Access license. I
believe the latest version (Access 2007) has a free runtime. All the
previous versions you'll have to pay for...

Regards

Jeff Boyce
Microsoft Office/Access MVP

> I've read thru several threads on splitting an access database and
> understand I have to use the built in utility to create the front-end and
> back-end pieces. When I give all the users the front-end piece, to they
> have to have Access on their PC to use the database or is there a run-time
> package that allows them to use the database with having an Access
> license?

Reply to this Message

Arvin Meyer [MVP] - 19 Jan 2008 16:56 GMT

> There is an Access runtime that doesn't require a full Access license. I
> believe the latest version (Access 2007) has a free runtime. All the
> previous versions you'll have to pay for...

To make it clear, you don't have to pay for the runtime. You must (or did)
pay for the developer's packaging utility that created the runtime, and
allowed the licenses to distribute it.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Reply to this Message

Kent McPherson - 22 Jan 2008 11:58 GMT

So if I develop an Access database in Access 2003, others without having a
full Access 2003 client on their PC can use the database if they have the
free runtime package. Is that right? If so, where do I get the runtime
package for them? Thanks.

>> There is an Access runtime that doesn't require a full Access license. I
>> believe the latest version (Access 2007) has a free runtime. All the
[quoted text clipped - 3 lines]
> pay for the developer's packaging utility that created the runtime, and
> allowed the licenses to distribute it.

Reply to this Message

Douglas J. Steele - 22 Jan 2008 14:06 GMT

For Access 2003, you need to purchase Visual Studio 2005 Tools for Office.
http://msdn2.microsoft.com/en-us/office/aa905533.aspx

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> So if I develop an Access database in Access 2003, others without having a
> full Access 2003 client on their PC can use the database if they have the
[quoted text clipped - 8 lines]
>> did) pay for the developer's packaging utility that created the runtime,
>> and allowed the licenses to distribute it.

Reply to this Message

Arvin Meyer [MVP] - 18 Jan 2008 20:28 GMT

They need to have Access or a runtime in either case. It has nothing to do
with splitting the database. Yes there is a runtime, packaged differently,
with different versions.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Reply to this Message