Solved

Ms access 2k10 #delete# in field issue

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

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 36

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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 36

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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 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