How to open Access 2002 adp in Access 2000?

G

Guest

I created an Access 2000 format adp in Access 2002. When users with Access
2000 attempt to open it, they get an "Unrecognized database format" error.
The adp consists of one form and one report; these in turn access a table and
a stored procedure on an MS SQL Server
 
L

Lance McGonigal

Are you sure the adp you're distributing is in fact in 2000 format. Sounds
fishy to me.
 
G

Guest

Well, the database objects view states that it's Access 2000 format, and the
only available conversion option is to Access 2002 format. Perhaps the
connection to SQL Server property is different in 2002 than in 2000, and
that's what causes the unrecognized file format error.
 
L

Lance McGonigal

I wouldn't think a conn string would cause the error but then I've seen
stranger things.
 
G

Guest

Yes, it appears that it was the connection string (and DNS errors). After
changing the server name to its IP address, they were almost able to connect,
and our network guy said "Now the ball's back in my court" (probably a router
issue). So when in doubt, change the server name to its IP and try again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
how do I create an adp in access 2010 2
ADP slow because SYSREFERENCES cached on first VIEW or TABLE open 1
Access 2000 ADP and SQL Server 2005 2
Unable to make design changes in .adp connected to SQL server 2008 1
Access 2007 Creating ADP (Access 2002 -2003 format) 10
Access Project Automatically Creates Files: adp1.adp, adp2.adp... 4
Start up Options ignored in ADP? 1

Top