Access Project Runtime + SQL License

[roytheboy]

Can someone pelase confirm that:

1. Access Projects run in Runtime (I can run them yet somewhere on the web a website stated that they do not).

2. If Runtime is OK, No Microsoft License needed on the App End as it is Runtime.

3. To 'legally' connect to SQL Server all you need is one of the 'Client Access Licenses' for SQL server.

So conclusion is:

If Runtime works for ADP's

All you need to legally run the software on site is a pukka copy of sql server and enough Access Licenses for all of your concurrent connections.

I am a developer that supports many access 2000 runtime Apps. Moving to SQL server but i need to confirm the licensing issue and this strangething i have read about access projects.

Thanks in Advance everyone.

Roy

 

[cjowsey]

I run ADPs with the Access XP runtime without any problems. I read recently that somebody could not get compiled ADPs (ADEs?) to work with the runtime. I haven't tried that as I don't need to at the moment.

The only problem I have encountered is that the runtime seems to be tighter in terms of coding requirements. I had a function call where I was not gettting the return value. It made me clean up my sloppy code. The line I had was

SelectDB (strSQL, rs)

The runtime rightly complained about a bad DLL call until I changed it to

blnResult = SelectDB(strSQL, rs)

Access VBA should have complained about my bad code in the first place, so it isn't really an issue.

HTH
Clive

 

[markphsd]

I have run it in run time working. It works just liks mdb's. You should just write a module that sets the connection. Whoever says you can't is wrong.

I have a question about the SQL Licensing, you have msde that can use up to five connections. Connections, not users. How does that change when you have SQL Server and licensing. If i have 10 people on msde which allows 5 connections, can i have 5 licenses for 10 users?

Mark P.

Bleh

 

[roytheboy]

SQL Server licensing is on concurrent connections.

so yes 10 users...

only 5 concurrent connections to that instance of sql server

Roy