Have Geek Brain

Missing data in the first record in MS Access (front end) and using SQL Server (back end)

I have a database where I just converted the end of SQL Server using SSMA. I left the interface in MS Access. I only converted tables, not queries. It already had some data and it moved just fine.

Everything was going well until recently. When opening the database and loading the main Event Interest form, it had problems with the first record of the subform called Names. The first field in the first record has data sometimes and not others. This is a text box. When the data is in the field, it is placed in random numbers. I believe they are related to SQL in some way. When no data / missing you can select the field and hit the back button and the data will appear minus one character you just messed up. I have no idea what's going on.

Any help you can provide I greatly appreciate. Thank you in advance.

I am new to SQL Server and I have been using older versions of MS Access for several years.

0


a source to share


1 answer


I'm not sure what the problem might be, but these are some considerations that come to mind:

  • try dropping and re-creating the linked tables. Perhaps updating the table structure (or the view if you are linked to a view) invalidated some of the metadata stored in the link on the page in your interface.

  • Does your table have a primary key? If not, you really need one. In a relational database that is PK-less, there really is no such thing as a properly designed data table.

  • Does your table have a timestamp? If not, add one, as it helps Access keep track of whether data has changed on the server.



However, let me add that none of these problems show up exactly with the symptoms you described, so they may not help.

+1


a source






More articles:


All Articles