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!

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

ACCESS upsized (or imported) to SQL

Status
Not open for further replies.

theguru97321

IS-IT--Management
Feb 3, 2003
216
US
I have used both the Import with MsSQL and Upsize from with in Access 2002/XP.

I have a VB application that uses ODBC, it works perfectly with our Access 97 or 2002 databases. But after I convert them into SQL, I get a Record Set is Read Only error.

I've gone through all the tables, and database properties, and nothing says read only off the top. Is there somewhere else I should be checking.

BTW I do not get any errors during the conversion. I did the first few times, but that was due to Date Fields haveing improper dates (ie. 11/02/003)

Please help, this is very pressing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top