I get this "The LinkMasterField s Property setting has produced this error: 'A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control' " error message when I try to add/edit line item to the subform and when I click OK, I am able to make changes, but the changes are not saved to the database.
This happens only when I try to use Access Database remotely. things work fine when I go to the server and add/edit line items in subform.
I have taken a copy of production database and pasted it in some other folder on production server itself. I added few fields to the table, modified Query and modified form containing subform. Then, I try to add line items. things work fine on server, but when I access the database from local machine, n try to add line items in subform, I get the above mentioned error. but the production database works fine remotely as well.
Please help!!!
17  6100 
Has this database been split into a front end/back end configuration, or are you trying to access a non-split database on a shared server?
Welcome to Bytes!
Linq ;0)>
I am trying to access a non-split database on the server, the folder containing the database has been shared with few users who will make changes when required. I think issue occur when I make change to the form containing subform
NeoPa 32,585
Recognized Expert Moderator MVP
You should never work on design changes of a database that's in use.
This is why splitting the FE & BE and releasing a new version of the (amended) FE is such a popular setup. I suggest you organise things the same way if you want to avoid such issues in future.
what is FE & BE? can you suggest me some useful link to implement FE & BE?
Thanks a Ton!!!
Sorry for not using the Common Sense... Front End & Back End you mean.. got it now.
I am working on it, hope it solves my problem.
Hi Neopa,
I think this will solve my problem. However, I need a suggestion from you.
I have made changes in tables, forms and reports. How should I apply these changes to production databases.
Steps I have in mind for production implementation:
1) modify the production database tables in design mode
2) make a copy of the database (say db1.mdb) and modify forms, queries and report in that db. Doing so, because I have 12 databases to be modified.
3) create a front end database, link it to the production database tables. Then, import the forms, queries and reports from the db1.mdb database
Please suggest if it is OK or not. All the 12 databases are similar.
NeoPa 32,585
Recognized Expert Moderator MVP
Sorry to use undeclared abbreviations. You got it though. That's exactly what I was talking about.
The usual method is to have a BE in place on the network. The FE is maintained on your development machine, and no-one else has access to it. Copies of the FE are on each user's machine. When a new release (tested on your machine) is ready the FE db that you've been working on is copied to each of the machines of the people who are to use it.
Does that sound like it makes sense?
NeoPa 32,585
Recognized Expert Moderator MVP
I should add, when you have a situation that requires changes to the BE (Generally much rarer), then you simply do your testing work with a copy and release it to the network when ready. If, as is usually the case, the new BE only works with a new version of the FE, then you will need to release the FE to all the clients (as in previous post) at the same time as releasing the new BE.
Yes. It does make sense. Unfortunately, This solution also didn't work for me.
I got the same error after deploying the FE to user's machine. No clue what's wrong... user can add line items to production db directly without FE, but after modifications, I get error message mentioned above.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Paul Allan |
last post by:
I am building an ActiveX control using Visual Basic 6.
I have a "property" that uses a "property page." To set this up I opened
the Tools\Procedure Attributes dialog, then selected my property and set the
"use this page in property browser" to the name of my property page.
So far so good, when I select the property in the property browser, an
ellipses is displayed, which opens the property page after I click it!
In the property page...
|
by: Kevin Sage |
last post by:
For anyone who is having this problem and want to know the
solution.
Add this line of code before your connect method call. It
loads up some config file that the code behind the scenes
needs that causes the delay when the config file is loaded
behind the scenes.
int temp = ServicePointManager.DefaultConnectionLimit;
|
by: Jimbo |
last post by:
I am trying to install Sql Server on a Win 2000 Server...It keeps
failing and I dont know why...I turned off my anti-virus for
installation and am logged in as an admin..heres the output of the
log...
21:40:32 Begin Setup
21:40:32 8.00.194
21:40:32 Mode = Normal
21:40:32 ModeType = NORMAL
|
by: Krishna Nadh Manepalli |
last post by:
Hi All,
We need to develop an activeX control using C# and this
control should have property page support so that users
can change the attributes of the control in
design time. (i.e., in front page editor, one can right
click on this activeX control and
change its attributes). We were successfully able to
create activeX cotrol but were not so lucky with
property pages support. Neither MSDN or net has any clues
|
by: Brian |
last post by:
Hi,
I'm trying to make an online FTP utility in C# ASP.NET using MSINET.ocx
(an active X control a.k.a. "Microsoft Internet Transfer Control")
I've added the reference into my project and have been able to compile it.
However, when I go to a webpage, and try to FTP something, I get this error:
System.Web.HttpUnhandledException was thrown.(Class is not licensed for use)
| | |
by: Jeffery Franzen |
last post by:
Anyone know where the documentation is regarding Activex controls in asp web forms?
I'm using VS.NET 2002 enterprise and am trying to use Activex controls in vb.net web form app.
I do the add control to pallete and then add a reference. I get the interop dll added to bin folder.
I did this with the MediaPlayer activex control as a simple case to to try and get it working.
I set the control to autostart via the html parameter tag for...
|
by: jaLe |
last post by:
This problem was discussed before but it doesn't solve my situation
I have master table Generalije with PK: ID1
I added subdatasheet table Nalaz with field FK GeneralijeID
When I add new record to Nalaz directly in Table View then GeneralijeID
is regulary added as FK (same as ID in Nalaz) EVERYTHING IS OK HERE
When I try to add new record in subform I get error
|
by: mikez |
last post by:
Hi,
We recently built a very basic file management system for a client in
Access 2003 (to use with incoming tif scans). In it we used
Microsoft's Document Imaging activex viewer (from Office 2003). The
viewer seems to be a bit 'buggy', in that sometimes if you preview a
tif image using the activex on a form, then goto another form, and then
come back to preview the same image again on the first form, the
preview no longer shows up...
|
by: jgoodnight |
last post by:
Hello,
I've read through many forum posts on this issue today but can't seem to find a solution that fits my particular case.
I have three main tables:
- tblIssues (PK: IssueID)
- tblRecommendations (PK: RecommendationID)
- tblActions (PK: ActionID)
There is a many-to-many relationship between issues and recommendations and between recommendations and actions. I have implemented join tables between them to account for this...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
