I have a DB that is keeping track of refills of patient's drugs. In one table I have the number of refills and an ID (ID,refills - other fields omitted) that corresponds to another table with the drug information (ID,name,dosage,price). Ex. (2,8) -> (2,drugA,dosageA,priceA) where 2 is the ID...
I have a form that has 2 tabs where on the first tab is the primary key of the information - pSSN. I have another form that is an abbreviated list of information from the first one with primary key pSSN as well. I have a button on the second form that when clicked opens the first form and goes...
Awesome - thanks for the details. One last thing though (I think!):
"Worry more about data corruption/backups and how you're going to do updates on the live database (hint: you can't)."
What do you mean by this? Can you give me an example or a quick explanation? Again, thank you very much...
Thanks for the reply. Good to know that it is possible. Again, I'm not familiar with this aspect of Access and am still a bit unsure.
Do I need to do something before I let the users access the DB or will it automatically handle multiple users?
How does Access handle two users accessing the...
I've developed a DB (forms, reports, etc) using MSAccess2003 for a company where the users only have access to shared applications and a shared network drive (very locked down environment). I'll be placing the DB on the shared network drive (only possibility). How do I go about handling...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.