Link to home
Start Free TrialLog in
Avatar of Ron-mds
Ron-mdsFlag for United States of America

asked on

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.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

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
Avatar of Ron-mds

ASKER

Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
Then what does this mean:

"I just move a Access 2003 Database to a new server"
                                                              ^^^^^^^^^^^^^^
?
Avatar of Ron-mds

ASKER

Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
Avatar of Ron-mds

ASKER

I different server. Just another server here in the office windows 2003 r2 server
Avatar of Ron-mds

ASKER

A new windows 2003 stand r2 server
"Not sure about the frontend or how to relinkl"
Is there one mdb or two mdb's ?

mx
Avatar of Ron-mds

ASKER

There is only one
Can you confirm you have a good network connection, because that error pretty much means there is a problem with the network ...

mx
Avatar of Ron-mds

ASKER

Yes the network is fine and everything is on the same server
Avatar of Ron-mds

ASKER

Sorry what do you mean by upload
Upload your db so I can look at it ...

mx
Avatar of Ron-mds

ASKER

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
Avatar of Ron-mds

ASKER

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
Avatar of Ron-mds

ASKER

Here is the Database
MDS.mdb
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
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ron-mds

ASKER

Found it sorry for my ignorance but how do i link them
Avatar of Ron-mds

ASKER

Did not award points need to cancel please
Avatar of Ron-mds

ASKER

THanks so much hope I get the points correct
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ron-mds

ASKER

Thanks Again