Upsize MDB to SQL Server

When I use access to upsize my existing mdb database to a new SQL Database, (created by Access during the process) once the upsize has been done I cannot add or delete any records from the tables on SQL Server.

You simply need to make sure that the "linked tables" in Access have primary keys. Of course, this means that your underlying tables in SQL Server must also have VALID primary keys. You cannot update a record in Access unless you have a primary key on it.

Brett

0

Featured Post

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…

This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.