Access

system · July 8, 2008, 2:08pm

Mitch,
with 2003 and earlier, you could distribute the mde free of charge, but end user needed Access installed to see it.
I am talking about end user not having any version of Access installed at all.
VSOT is basically a license for you to develop your mdb, and distribute a run-time Access .exe, free of royalty.

But as Mr. Rose points out, seems you can distribute 2007 databases free of royalty without the VSOT.

However, Access 2007 is so horrible that I have given up using it. It completely moves away from being a database development tool and tries to hook in Excel users or some other type of user that has nothing to do with the core group of people who traditionally used Access to develop RAD database frontends.

----- Original Message ----
From: Mitch Appleby <mitch@...>
To: vantage@yahoogroups.com
Sent: Tuesday, July 8, 2008 11:12:36 AM
Subject: [Vantage] Re: Access

I'm puzzled ... You say Access won't let you distribute applications
free. We do this all the time using a compiled file ( mde or
accdb)with the free Access run time program on each user's PC. How is
Visual Studio different? Does this give you an exe file? Where could
I get some info on this method?

Mitch Appleby
IS Admin
Dubuque Stamping

--- In vantage@yahoogroups .com, Tony Hughes <thughes281@ ...> wrote:
>
> You can purchase Visual Studio Tools for Office, which lets you
create runtime Access applications that you can distribute for free.
> Access itself won't let you do it, you'd need the VSOT
> Personally I think it is a superior means of distributing reporting
tools to users.
> Crystal doesn't hold a candle to a nicely written Access reporting app.
>
>
>
> ----- Original Message ----
> From: RICH WAGNER <rwagner@... >
> To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
> Sent: Tuesday, July 8, 2008 8:01:07 AM
> Subject: [Vantage] Access
>
>
> When you use Access instead of Crystal for your reports, do you have
to have Access on all your computers that you want to run the report?
>
> Can you compile the form in Access and distribute it?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image001. jpg@ 01C8E0D9. 28B6E8E0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>
>
> www.bawplastics. com<http://www.bawplast ics.com/>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

system · February 27, 2004, 12:35pm

If I wanted to link a table from Access to Vantage and run an update query, what setting should my Default Isolation Level be set at for the ODBC driver so it can accept the change on the table?

Read Committed
Read Uncommitted
Repeatable Read
Serializable

Thanks,

Jasper

[Non-text portions of this message have been removed]

system · February 27, 2004, 12:37pm

Read Commited

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, February 27, 2004 12:35 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Access

If I wanted to link a table from Access to Vantage and run an update query, what setting should my Default Isolation Level be set at for the ODBC driver so it can accept the change on the table?

Read Committed
Read Uncommitted
Repeatable Read
Serializable

Thanks,

Jasper

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

system · July 8, 2008, 9:03am

When you use Access instead of Crystal for your reports, do you have to have Access on all your computers that you want to run the report?

Can you compile the form in Access and distribute it?

Thanks,

Rich Wagner

[cid:image001.jpg@01C8E0D9.28B6E8E0]

412-384-3100

rwagner@...<mailto:rwagner@...>

www.bawplastics.com<http://www.bawplastics.com/>

[Non-text portions of this message have been removed]

system · July 8, 2008, 9:13am

No you need access run time if the other pcs do not have a full copy of
access on them

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Tuesday, July 08, 2008 8:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Access

When you use Access instead of Crystal for your reports, do you have to
have Access on all your computers that you want to run the report?

Can you compile the form in Access and distribute it?

Thanks,

Rich Wagner

[cid:image001.jpg@01C8E0D9.28B6E8E0
<mailto:image001.jpg%4001C8E0D9.28B6E8E0> ]

412-384-3100

rwagner@... <mailto:rwagner%40bawplastics.com>
<mailto:rwagner@... <mailto:rwagner%40bawplastics.com> >

www.bawplastics.com<http://www.bawplastics.com/>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · July 8, 2008, 11:58am

You can purchase Visual Studio Tools for Office, which lets you create runtime Access applications that you can distribute for free.
Access itself won't let you do it, you'd need the VSOT
Personally I think it is a superior means of distributing reporting tools to users.
Crystal doesn't hold a candle to a nicely written Access reporting app.

----- Original Message ----
From: RICH WAGNER <rwagner@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, July 8, 2008 8:01:07 AM
Subject: [Vantage] Access

When you use Access instead of Crystal for your reports, do you have to have Access on all your computers that you want to run the report?

Can you compile the form in Access and distribute it?

Thanks,

Rich Wagner

[cid:image001.jpg@ 01C8E0D9. 28B6E8E0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplast ics.com/>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · July 8, 2008, 12:09pm

For Access 2003 and earlier versions, you are entirely correct. However, in Access 2007, you do not need to purchase anything to distribute runtime applications (though, obviously, the person developing the app needs to have a full copy of Access). You need to install the free Access runtime application on your client's PC's. Then, make a copy of your Access application and change the extension from accdb to accdr. Your clients can run the accdr file. You should only do this in an environment where you trust your users. An evil user with a full copy of Access can change the accdr extension back to accdb and then change anything in the database. The security in an accdr is no better than in an accdb. There may be ways to better secure the app, but I have not been in an environment yet where I needed to worry about that.

Thom Rose
Controller
Electric Mirror, LLC
T 425 776-4946 ext. 1024
A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tony Hughes
Sent: Tuesday, July 08, 2008 8:59 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} Re: [Vantage] Access

You can purchase Visual Studio Tools for Office, which lets you create runtime Access applications that you can distribute for free.
Access itself won't let you do it, you'd need the VSOT
Personally I think it is a superior means of distributing reporting tools to users.
Crystal doesn't hold a candle to a nicely written Access reporting app.

----- Original Message ----
From: RICH WAGNER <rwagner@...<mailto:rwagner%40bawplastics.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tuesday, July 8, 2008 8:01:07 AM
Subject: [Vantage] Access

When you use Access instead of Crystal for your reports, do you have to have Access on all your computers that you want to run the report?

Can you compile the form in Access and distribute it?

Thanks,

Rich Wagner

[cid:image001.jpg@ 01C8E0D9. 28B6E8E0]

412-384-3100

rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>

www.bawplastics. com<http://www.bawplast ics.com/>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · July 8, 2008, 12:12pm

I'm puzzled ... You say Access won't let you distribute applications
free. We do this all the time using a compiled file ( mde or
accdb)with the free Access run time program on each user's PC. How is
Visual Studio different? Does this give you an exe file? Where could
I get some info on this method?

Mitch Appleby
IS Admin
Dubuque Stamping

--- In vantage@yahoogroups.com, Tony Hughes <thughes281@...> wrote:
>
> You can purchase Visual Studio Tools for Office, which lets you
create runtime Access applications that you can distribute for free.
> Access itself won't let you do it, you'd need the VSOT
> Personally I think it is a superior means of distributing reporting
tools to users.
> Crystal doesn't hold a candle to a nicely written Access reporting app.
>
>
>
> ----- Original Message ----
> From: RICH WAGNER <rwagner@...>
> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> Sent: Tuesday, July 8, 2008 8:01:07 AM
> Subject: [Vantage] Access
>
>
> When you use Access instead of Crystal for your reports, do you have
to have Access on all your computers that you want to run the report?
>
> Can you compile the form in Access and distribute it?
>
> Thanks,
>
> Rich Wagner
>
> [cid:image001.jpg@ 01C8E0D9. 28B6E8E0]
>
> 412-384-3100
>
> rwagner@bawplastics .com<mailto:rwagner@bawplastics .com>
>
> www.bawplastics. com<http://www.bawplast ics.com/>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>