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
625 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 15
  • 11
26 Comments
 
LVL 75
ID: 34867403
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
ID: 34867510
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
 
LVL 75
ID: 34867525
Then what does this mean:

"I just move a Access 2003 Database to a new server"
                                                              ^^^^^^^^^^^^^^
?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Ron-mds
ID: 34867528
Access 2003 and the MDB database are on the same computer Not sure about the frontend or how to relinkl
0
 
LVL 75
ID: 34867550
What do you mean 'new server' ?

mx
0
 

Author Comment

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

Author Comment

by:Ron-mds
ID: 34868323
A new windows 2003 stand r2 server
0
 
LVL 75
ID: 34868336
"Not sure about the frontend or how to relinkl"
Is there one mdb or two mdb's ?

mx
0
 

Author Comment

by:Ron-mds
ID: 34868340
There is only one
0
 
LVL 75
ID: 34868350
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
ID: 34868354
Yes the network is fine and everything is on the same server
0
 
LVL 75
ID: 34868364
Can you upload the db?

mx
0
 

Author Comment

by:Ron-mds
ID: 34868367
Sorry what do you mean by upload
0
 
LVL 75
ID: 34868376
Upload your db so I can look at it ...

mx
0
 

Author Comment

by:Ron-mds
ID: 34868379
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
ID: 34868386
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
ID: 34868398
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
ID: 34868425
Here is the Database
MDS.mdb
0
 
LVL 75
ID: 34868455
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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34868461
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
ID: 34868467
Found it sorry for my ignorance but how do i link them
0
 

Author Comment

by:Ron-mds
ID: 34868481
Did not award points need to cancel please
0
 

Author Comment

by:Ron-mds
ID: 34868490
THanks so much hope I get the points correct
0
 
LVL 75
ID: 34868495
You are welcome ...

mx
0
 

Accepted Solution

by:
Ron-mds earned 0 total points
ID: 34868500
Work great
0
 

Author Closing Comment

by:Ron-mds
ID: 34895129
Thanks Again
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access 2003, find all instances of database ODBC 3 48
Intermittent OleDbConnection Error 20 52
View SQL Count Records 3 30
Tabbed form question 5 18
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

732 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