Solved

Ms access 2k10 #delete# in field issue

Posted on 2016-08-11
6
25 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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 different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

705 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

20 Experts available now in Live!

Get 1:1 Help Now