Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-16-2018, 12:26 PM   #16
sumdumgai
Newly Registered User
 
Join Date: Jul 2007
Posts: 324
Thanks: 75
Thanked 0 Times in 0 Posts
sumdumgai is on a distinguished road
Re: This recordset is not updatable?

Thanks again to everyone. I'll recommend that the back-end be distributed to desktops. Only problem is, I see another app down the road where distributing b-e is not feasible.

sumdumgai is offline   Reply With Quote
Old 12-16-2018, 02:57 PM   #17
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,472
Thanks: 40
Thanked 3,384 Times in 3,279 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: This recordset is not updatable?

Quote:
Only problem is, I see another app down the road where distributing b-e is not feasible.
for multi user applications where users are not on the same network - if you want to use access investigate using a terminal server.

Slightly less flexible consider using a sql azure backend with access front end. Less flexible because for security reasons you have to specify the IP addresses of the users who require access - fine if known, but if they are sitting in a café or hotel somewhere or on the train, it is not going to work.

You might also consider using sql server express as a back end, but suspect it can not be installed on your cloud server.

If you are going to use access within its design parameters you should not have a problem, but if your requirement is outside those parameters, you need to use something else.

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
sumdumgai (Yesterday)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The recordset is not updatable MilaK Forms 10 10-10-2016 09:58 AM
Recordset not updatable patpetro Forms 2 05-14-2009 05:25 PM
recordset not updatable prodigy SQL Server 4 08-30-2006 03:16 PM
The recordset is not updatable. paul young Queries 1 05-26-2004 06:30 AM
recordset not updatable SaraMegan Queries 2 10-08-2002 04:07 AM




All times are GMT -8. The time now is 06:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World