Table properties from SQL table not propagated to Access table

P

Peter

We have upsized a legacy Access application (2 Access databases, a front end
and a back end) to SQL Server (MSDE version). We have upgraded the back end
to SQL, but are maintaining the Access front-end, re-linking the tables to
the new SQL Server tables via ODBC.

When the tables were created in SQL Server using the upsize wizard, some
Access column properties were copied across to the SQL Server column Extended
Properties, such as default value and description (to MS_Description).
However when these SQL Server tables are linked back into the Access
front-end, these properties are lost. Some application errors are occurring
where forms are not getting populated with the defaults, causing problems
when the Null values are getting read.

Is there any way to get the default values back into the ODBC linked tables?

Thanks Guys & Girls!!
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Adding data to MS Access from csv file 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Access 2003 and SQL 4
Migration to SQL Server 3
Linked Tables - indexes 4
linking to SQL Server db table 6
Linking Tables from SQL Server 1

Top