access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have access 2000 on my laptop. I have access 2003 at my office. I want to
input patient info at home on laptop, then save to a jump drive & load into
office computer. Is this possible? My jump drive at the office is currently
not working, so I haven't been able to try it yet. & obviously don't want to
load numerous amounts of info if it wont convert.
 
You would need to either set up Access replication (quite cumbersome), or
learn how to import data from the laptop db into the main app.

The import method will experience issues if you manage to get the same
primary key used on both copies, so you will have to account for that...

Does that help?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Well that at least gives me hope......but the rest of what you said was
basically greek to me. when you say "experience issues," I assume you mean
negative ones. so are you saying to not get the same primary keys??? Thank
you for your help.
-Christine
 
Pretty much....

Think of it this way:
if your database has records 1, 2 and 3 in it, then you copy it and take it
home and add 4, 5 and 6. While you are driving home, someone at the office
adds a record 4.

When you try to do the import, your record number 4 will fail sine there
already is one.

This is for a straight import, and there are a number of other
considerations. Make a test database and play with it...that's the best way
to sort out the issues.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 
Back
Top