Solved

Ms access 2k10 #delete# in field issue

Posted on 2016-08-11
6
28 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 34

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 34

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

914 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now