Splitting DB question

[Kent McPherson]

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?

 

[Jeff Boyce]

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

 

[Arvin Meyer [MVP]]

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.

 

[Arvin Meyer [MVP]]

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.

 

[Kent McPherson]

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.

 

[Douglas J. Steele]

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)