Copy Database

[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

 

[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

 

[Joseph Meehan]

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

You are wise to develop on a copy of the original.

I agree with Douglas and I will add one thing. Generally the back end
(the part on the server) should only contain data, and only that data that
changes and is shared by various users. Forms, queries, static data tables,
reports etc should all be on the front end on the user's machines.

Now is the time to plan ahead. Making changes to the function sometimes
requires changing all the front end databases. Now is the time to put in a
system to assure you can keep everyone in sync. Douglas referenced you a
good resource.

 

[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?

 

[Joseph Meehan]

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?

Tell me what you have downloaded? What is the file name(s) and sizes?

 

[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

 

[Joseph Meehan]

start mdb, drive examples etc. if i click on mdb i get the diagram he
shows on his page

Tell me a little more. You click on the mdb and you get a diagram?????
Could you be a little more specific?

I am guessing that the database is trying to execute some command when
it opens, but let's try to make sure. Exactly what happens, step by step
when you open it.

 

[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

 

[Joseph Meehan]

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

Well, I'm going to tell you the truth. I can't even guess what is going
on. Where did this application come from? It might also be interesting to
see what you get if you right click on the icon and select properties.

Where did you get this application? What is it suppose to do?