Access97 and SQL Server 2000

A

Ann

Can you use Access 97 to link tables from a SQL SERVER
2000 database. Can you import tables using the same
scenario.

Thanks,

Ann
 
J

Joe Fallon

Sure.
There are some minor restrictions since SQL Server 2000 didn't exist when
A97 was designed.
Certain rare datatypes may be a problem.

But for 99% of the data you should be fine.
 

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

SQL Server 6
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Conneting to SQL server, Need advice 4
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Write Conflict 4
Move Access Table to SQL Server 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Can I save a sql statement generated by a search form? 1

Top