Solved

Ms access 2k10 #delete# in field issue

Posted on 2016-08-11
6
31 Views
Last Modified: 2016-08-11
Ms access 2k10 #delete# in field issue

I have access db1 (db1) that creates  accessdb2 (db2). Db2 contains a table with a single record which contains various text, memo and date fields with information pertaining to the job and then puts the completed db2 in a field tech’s dropbox.

The fields in db2 are filled from various form fields (some of which may be null) before the db is
Copied to the dropbox.

From time-to-time (but not every time) the record in db2 ends up with #delete# fields and is therefore unusable. Not sure what causes this. Some googling seems to indicate it may have something to do with an autonumber id field in db2.

Any thoughts/Suggestions/questions?
0
Comment
Question by:jsgould
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:PatHartman
ID: 41752428
Copied to the dropbox.
That is most likely your problem.  Databases CANNOT be shared this way.  It is not just DrobBox.   The way the cloud file sharing works is completely different from the way Windows shares files on a LAN and Access databases can easily become corrupted if more than one person opens the file at a time.

Either use Citrix or RDP.  Both allow sharing over a WAN.
0
 

Author Comment

by:jsgould
ID: 41752552
PatHartman:
I probably didn't explain enough. Dropbox is the medium used to  get the db from central to the field techs' laptop. the db is not shared, and the field tech has no internet connectivity during the course of the job. after completion central imports various data components from the db for analysis. all of this works fine. HTH
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 41752735
You could start by deleting the autonumber.  Autonumber doesn't help in this type of application.  When the main app creates this travelling database and populates the record, it should include whatever keys are necessary to match up to the correct source records when the travelling database is synced up.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:jsgould
ID: 41752770
PatHartman:
Thank you!
Actually the autonumber id field is not used for anything in the app and there is always only 1 record in this table with the Job Spec info, which doesn't get changed. All of the job data is recorded in other tables in the db and includes job sync info.

Do u see any issues if I just delete the field altogether?

it's important to note that this is a "single use" db. When the job is completed and the data imported, it is never used again.
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41752778
I understand the purpose of the app.  You only have to make sure that the record in the stand-alone database has the necessary keys to link it back to the record it is supposed to update when the database is synced.
0
 

Author Closing Comment

by:jsgould
ID: 41752808
Thanks for ur fast response and excellent help!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question