Copy Database

C

Cyndi

I have an access database that uses tables from another database, if I
link there are multiple users and alot of information and it is very
slow so what I have been doing while developing is copying the
database to another location and linking from there, that way I am
the only one using and it is faster now though I am ready to let
others use and it needs to be updateable from the original database
because there are constant changes. Is there a way to do a macro or
something where I could have a command button where when the user
clicks on it it goes to the g drive, copies the database to the c
drive overwriting the old one on g? I know about transferdatabase but
there are multiple tables(about 20) and do I write a macro to delete
each table and then import new one?

Thanks in advance for all help
 
D

Douglas J. Steele

I'm not sure I fully understand your question.

Are you saying that you're making changes to the data in your copy of the
database and that those changes should be available in the "production"
version? That doesn't sound like a good idea!

Or are you saying that you've made changes to the front-end database, and
that you want to ensure each user has his/her own copy of the new front-end?
If that's the case, Tony Toews has a free utility available at
http://www.granite.ab.ca/access/autofe.htm
 
C

Cyndi

I agree that this looks like what I need and I have downloaded it but
I have no idea how to start using it - can you give me some guidance
please?
 
C

Cyndi

start mdb, drive examples etc. if i click on mdb i get the diagram he
shows on his page but i cant do anything - if i click on verify ini or
other buttons it tells me the drives aren't correct which they aren;t
because they are his examples, I see in the notepad the code but how
do I go into that and make it my own, he says it will make a shortcut
but I dont see how etc
 
C

Cyndi

Ok I downloaded, and extracted files to a folder in c:\program files
I go to this folder and i have an icon that says start mdb + some doc
files. If i click on start mdb i get the little dialog box that he
shows on his page, has one ini file locked and the buttons to choose
icon, verify ini etc

The first time I clicked it gave me the message that no one else had
used so it was using my computer name as user, then I clicked on
unlock and it asked me if I was sure I wanted to unlock I said ok and
it unlocked the file but if I click on the any of the 3 ini buttons it
brings up a notebpad with the code or tells me it cant find q etc
which obviously it cant cause I dont have a q drive so or on one it
says it can't find laptop again I am not on a laptop - I thought this
was his code he put in and you have to go change but where do I go to
change to my drive letters etc.

Thanks for your help
 
Top