Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Post SS2005 installation Access trouble

Author  Topic 

betesh
Starting Member

34 Posts

Posted - 2008-06-18 : 06:54:07
We removed SQL Server Express from our server and instead installed SQL Server Enterprise Trial. We were able to connect via Management Studio and MS Access. However the MS Access forms are not allowing inserts or deletes. If we go directly to the tables in MS Access we can add or remove rows but not from the forms. What could have caused this? Any ideas?

Thanks!

betesh
Starting Member

34 Posts

Posted - 2008-06-18 : 07:32:13
I forgot to add that at the time of installation I set the instance name to sqlexpress so that the users wouldn't have to change their connection information.
Go to Top of Page

betesh
Starting Member

34 Posts

Posted - 2008-06-18 : 08:10:18
I don't know if its possible to delete this thread but we realized the problem was on the Access end, not as a result of the SQL Server Installation. Thanks anyways.
Go to Top of Page
   

- Advertisement -