Updating SQL from Access Forms

  • Thread starter Thread starter Jester98x
  • Start date Start date
J

Jester98x

I am upsizing an Access database to SQL server 2000 and have
encountered a problem when attempting to add new data, or edit
exisitng data using an Access Form.

I have upsized, and checked all functionallity on the Access database,
after fixing a couple of index issues, everything works fine, except
for the ability to update or add data via a Form.

I am able to add and update directly to the tables. There is no error
message shown when updating via the Forms, it just hangs. I'm not
Access expert so this has me a little stuck. I ran SQL profiler on
the database and it seems that the update/insert queries arn't getting
to SQL in a way that profiler picks them up, i.e. I dont' see any
entries in profiler for updates.

So far I have:
- checked the database to ensure it isn't set to read only
- checked that unique indexes are configured on the database
- checked that I can perform updates and inserts directly on the
tables (from within Access)

Is this a known issue?

Thanks in advance for any help. I can provide more information if
it's required, unfortunatly I can't provide instances of the
databases.

Steve
 
Apologies, ignore this.

Since rebooting my computer, overnight, and restarting everything, all
is working as expected.

No idea why it wouldn't work correctly previously, but is working fine
now.

Thanks anyway.

Steve
 
Back
Top