Problem with copying from one database to another

R

Ron

Hi All,

I have a database at a client's office, called ahhh... dbMyFE1 as a
front end linked to a back end called dbMyBE. Works as designed. No
probs.

I've brought a copy of both into my computer, made a few small changes
to some of the reports/forms/queries, etc. Let's say changes to 2
forms, 1 change to a report and changes to 2 queries.

Instead of copying the whole FE back to them, I thought I'd just send
the new stuff. So, I created a new database and used Get External
Data/Import to copy those 5 files to it. Hooked into their computer
over the internet, made copies of everything and then deleted their
old 5 files and tried Get External Data/Import the new 5 files.

But, when I try, the system immediately gives me and error: "Error
accessing file. Network connection may have been lost.".

I click on OK to the above error and get another error "Name conflicts
with existing module, project, or object library".

When I click on OK to that error, it looks like the files I tried to
copy (the forms first) did copy over to dbMyFE1 but when I try to
access them, I get these same errors. And closing the program and
restarting it I get the above 2 errors when starting the program and
links to dbMyBE are gone.

Anyone know why this would be happening? And, better yet...how to
resolve this?

Sure, I could just copy the whole dbMyFE over with the changes...but
there are about 25-30 other clients I need to update every so often
with different requirements, etc. I need to be able to Import
changes...and can't now.

Help!!!!

TIA
ron
 
T

Tom Wickerath

Hi Ron,
But, when I try, the system immediately gives me and error: "Error
accessing file. Network connection may have been lost.".

I've only seen the above error with an unpatched copy of Access 2000. Here
is a KB article that discusses this error:

http://support.microsoft.com/kb/304548

Make sure that your client's PC's are fully patched:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528 In particular, follow the
three links:

Verify that the latest operating system service pack is installed
Verify that the latest Microsoft Jet service pack is installed and
Verify that the latest service pack for your version of Office is
installed

Also recommended: Install the latest version of MDAC (Microsoft Data Access
Components)
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
R

Ron

Hi Ron,


I've only seen the above error with an unpatched copy of Access 2000. Here
is a KB article that discusses this error:

     http://support.microsoft.com/kb/304548

Make sure that your client's PC's are fully patched:

    How to keep a Jet 4.0 database in top working condition
   http://support.microsoft.com/?id=303528  In particular, followthe
three links:

    Verify that the latest operating system service pack is installed
    Verify that the latest Microsoft Jet service pack is installed  and
    Verify that the latest service pack for your version of Office is
installed

Also recommended: Install the latest version of MDAC (Microsoft Data Access
Components)http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c79...

Tom Wickerath
Microsoft Access MVPhttp://www.accessmvp.com/TWickerath/http://www.access..qbuilt.com/html/expert_contributors.html
__________________________________________













- Show quoted text -

Thanks Tom, that was the problem. I forgot to update my access
program after replacing a hard drive and installing Access from the
original cd. I updated to sp-3 and all is fine.

I'll be sure to check on all my clients updates as well.

Thanks again, as I was thinking I had some major problem with my
program. Nice to know that at least THAT is still perfect! ::grin::

ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top