?
Solved

Ms access 2k10 #delete# in field issue

Posted on 2016-08-11
6
Medium Priority
?
51 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 40

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 40

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 40

Accepted Solution

by:
PatHartman earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

621 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