You are right, but with web2py you have the option of giving each user a
copy web2py (which does not need installing - just unzip), run the
webserver on localhost only and point everyone at the same database on a
shared drive. This is why I need Access to allow concurrent users. I know
it's not perfect, but when you are working in a local IT department
reacting to local business requirements with one hand tied behind your
back, pepper spray in your eyes and pair of electrodes on your testicles
because of Corporate IT restrictions, you have to try and think outside of
the box.
Simon
On Thursday, 15 November 2012 18:04:23 UTC, Willoughby wrote:
>
> True - but most companies also block web servers internally - so you
> wouldn't get far either way.
> Unless you're doing a bundled stand alone...?
> If so, have you looked at SQL Server Express?
> It has a 'localdb' option if you want something you can run 'from the
> desktop'.
>
>
> On Thursday, November 15, 2012 11:46:23 AM UTC-5, Simon Carr wrote:
>>
>> Bat Man strikes again, That seems to work perfectly to make the actual
>> connection, unfortunately :-( there is an immediate error in the SQL as it
>> tries to create the auth tables. Looks like it would require a specific
>> connection object writing. It's a shame because most companies will not
>> allow database servers setting up like MySQL Server out side the confines
>> of the IT Department. SQLite is often not scaleable enough but MS Access
>> fits just nicely in the middle ground and is readily available on users
>> machines.
>>
>> What are the chances of a MS Access adapter being written?
>>
>> I had a look at gluon.py but without help to get me started I don't think
>> I could do it.
>>
>> Simon
>>
>>
>> On Thursday, 15 November 2012 16:17:12 UTC, Niphlod wrote:
>>>
>>> i'd give it a try with the entire connection string (choosing also the
>>> right driver installed on your machine)
>>>
>>> db = DAL("mssql://Driver={Microsoft Access Driver (*.mdb)};Dbq=
>>> C:\mydatabase.mdb;Uid=Admin;Pwd=;")
>>>
>>> On Thursday, November 15, 2012 4:47:20 PM UTC+1, Willoughby wrote:
>>>>
>>>> Yea, sorry - we're still running an ancient version because of issues
>>>> trying to upgrade.
>>>> We're now looking at converting to Lightswitch instead.
>>>>
>>>> I believe it should be db=DAL for current versions and the connection
>>>> string is normally mssql://user:pwd@server/database
>>>>
>>>>
>>>> On Thursday, November 15, 2012 10:32:08 AM UTC-5, Simon Carr wrote:
>>>>>
>>>>> Should the connection string not start db=DAL(.....)
>>>>>
>>>>> If not how does this method of connection allow you to leverage the
>>>>> features of the Web2Py DAL
>>>>>
>>>>> Thanks
>>>>> Simon
>>>>>
>>>>> On Thursday, 15 November 2012 15:11:02 UTC, Willoughby wrote:
>>>>>>
>>>>>> I use SQLServer but have never tried Access (except as a linked
>>>>>> server within SQL Server).
>>>>>> I'd imagine the connection string would look something like this:
>>>>>> db=SQLDB <http://examples/global/vars/SQLDB>(
>>>>>> 'mssql://user:user@<server>/<directory>/access.mdb')
>>>>>> Have no idea how the whole user id/password part would work
>>>>>> though...could try it without it and see if it flies...
>>>>>>
>>>>>
--
