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

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.
Ron-mdsAsked:
Who is Participating?
 
Ron-mdsConnect With a Mentor Author Commented:
Work great
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Ron-mdsAuthor Commented:
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Then what does this mean:

"I just move a Access 2003 Database to a new server"
                                                              ^^^^^^^^^^^^^^
?
0
 
Ron-mdsAuthor Commented:
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What do you mean 'new server' ?

mx
0
 
Ron-mdsAuthor Commented:
I different server. Just another server here in the office windows 2003 r2 server
0
 
Ron-mdsAuthor Commented:
A new windows 2003 stand r2 server
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Not sure about the frontend or how to relinkl"
Is there one mdb or two mdb's ?

mx
0
 
Ron-mdsAuthor Commented:
There is only one
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can you confirm you have a good network connection, because that error pretty much means there is a problem with the network ...

mx
0
 
Ron-mdsAuthor Commented:
Yes the network is fine and everything is on the same server
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can you upload the db?

mx
0
 
Ron-mdsAuthor Commented:
Sorry what do you mean by upload
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Upload your db so I can look at it ...

mx
0
 
Ron-mdsAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Ron-mdsAuthor Commented:
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
 
Ron-mdsAuthor Commented:
Here is the Database
MDS.mdb
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
Ron-mdsAuthor Commented:
Found it sorry for my ignorance but how do i link them
0
 
Ron-mdsAuthor Commented:
Did not award points need to cancel please
0
 
Ron-mdsAuthor Commented:
THanks so much hope I get the points correct
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

mx
0
 
Ron-mdsAuthor Commented:
Thanks Again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.