Solved

I just move a Access 2003 Database to a new server by copies the files over the network

Posted on 2011-02-10
26
593 Views
Last Modified: 2012-05-11
I just move a Access 2003 Database to a new server by copies the files over the network. When I try to run the application I get a run-time 3043 or a 2467.
0
Comment
Question by:Ron-mds
  • 15
  • 11
26 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
3043 is:

A2007
"Your network access was interrupted. To continue, close the database, and then open it again."

or
A2003
"Disk or network error."

Do you have a front end linked to tables in a backend ?  If so, you will need to re link those tables.

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Then what does this mean:

"I just move a Access 2003 Database to a new server"
                                                              ^^^^^^^^^^^^^^
?
0
 

Author Comment

by:Ron-mds
Comment Utility
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
What do you mean 'new server' ?

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
I different server. Just another server here in the office windows 2003 r2 server
0
 

Author Comment

by:Ron-mds
Comment Utility
A new windows 2003 stand r2 server
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
"Not sure about the frontend or how to relinkl"
Is there one mdb or two mdb's ?

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
There is only one
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Can you confirm you have a good network connection, because that error pretty much means there is a problem with the network ...

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
Yes the network is fine and everything is on the same server
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Can you upload the db?

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
Sorry what do you mean by upload
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Upload your db so I can look at it ...

mx
0
 

Author Comment

by:Ron-mds
Comment Utility
Yes I could. This is strange from the orginal server I can run access and open the database on the new server just fine, but from the new server i cannot run access and open the database. seems like it must be some setting within the new access installation
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Could be a problem with installation.  Have you rebooted that computer lately?


How to upload:
http://www.experts-exchange.com/Community_Support/General/A_2790-How-do-I-attach-a-file-at-Experts-Exchange.html
0
 

Author Comment

by:Ron-mds
Comment Utility
Yes I have rebooted I did a debug and this is the statement giving the error

Private Sub lblPractices_Click()
   Me.lblPractices.SpecialEffect = 2
   TimeDelay
   DoCmd.OpenForm "frmPractices"  ---------This line____________
   Me.lblPractices.SpecialEffect = 1
End Sub
0
 

Author Comment

by:Ron-mds
Comment Utility
Here is the Database
MDS.mdb
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
As I suspected, there are two mdbs.  See pix below.  All tables with a black arrow (eg Employees) are linked tables ... to another mdb.
The current path is shown in the 2nd image.
You need to located the MDS_be.mdb, and relink the Front End to the tables in the Back End (be).

mx
Capture1.gif
Capture2.gif
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
Comment Utility
the pix below show how to use the Linked Table Manager to relink your tables.

When the Windows File Browse dialog appears, browse to the location of the MDS_be.mdb

mx
Capture1.gif
Capture2.gif
Capture3.gif
0
 

Author Comment

by:Ron-mds
Comment Utility
Found it sorry for my ignorance but how do i link them
0
 

Author Comment

by:Ron-mds
Comment Utility
Did not award points need to cancel please
0
 

Author Comment

by:Ron-mds
Comment Utility
THanks so much hope I get the points correct
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
You are welcome ...

mx
0
 

Accepted Solution

by:
Ron-mds earned 0 total points
Comment Utility
Work great
0
 

Author Closing Comment

by:Ron-mds
Comment Utility
Thanks Again
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now