Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upsize Wizard Issue

Status
Not open for further replies.
OrWolf

OrWolf

MIS
Mar 19, 2001
291
I'm having a problem upsizing to SQL using the Access wizard. I've tried upsizing on two different machine, one with Access 2000 and the other with Access XP. I have existing linked tables using the DSN I'm specifying and have confirmed the name of the SQLServer.

Error on Access 2000:
[DBNMPNTW]Specified SQL Server not found

Error on Access XP:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

I've also tried upsizing from a brand new database and receive the same error. The SQL Server is SQL Server 2000 SP3 - Standard Edition. Any suggestions?
 
Status
Not open for further replies.

Similar threads

iamchemist
  • Locked
  • Question
Windows 10 Security/Access Issue
Replies
5
Views
606
dhookom
dhookom
Blorf
  • Locked
  • Question
Report: CanGrow Issue - Works on Some machines and not others 1
Replies
2
Views
269
Blorf
Blorf
weightinwildcat
  • Locked
  • Question
Invalid procedure call - Error number 5 - Issue in QB_Connector 
Replies
3
Views
327
combo
combo
tlallen
  • Locked
  • Question
Access 2013 - Word Merge issue and temporary query pop-up
Replies
0
Views
189
tlallen
tlallen
Lisa_Sunshine
  • Locked
  • Question
Drag & Drop Outlook Mail to Access memo field issues
Replies
0
Views
317
Lisa_Sunshine
Lisa_Sunshine

Part and Inventory Search

Sponsor

Back
Top