Access to SQL

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have an Access database that I have recenlty upgraded
the tables to SQL. Unfortunately the front end is still
in Access (I am more of a VB guy). My problem is that the
Access forms have subforms that allow users to enter and
modify data. However now that the tables are in SQL users
cannot add new records, the small "new record" button is
greyed out on the navigator and there are no empty fields
for them to add to.

Any help would be appreciated.

Thanks

Rick
 
Rick,
Check to make sure all the tables have indexes, you may
need to drop and then re-add them. Alos, Access will let
you use a query and update multiple tables, SQL doesnt
like that. I had to break my update queries so only 1
table was updated at a time. good luck
 
Back
Top