Access 2003 / SQL Express 8 Can't Add Rows to Table
Thu, 4 Sep 2008 10:53:04 -0700
I created an ADP in Access 2003 to connect to SQL Server Express 8 and
succesfully made the connection.
I also succesfully imported a new table, but when I tried to add records to
the new table, I can not do it. I tried opening the table but the add new
record is disabled.
Then I tried to create an update ...
|
ADP reports using SQL views unavailable to users
Wed, 3 Sep 2008 15:28:52 -0700 (PDT)
I have ADP front end to SQL 2005 data. This front end is a conversion
from an older MDB. The old MDB links to views on the SQL server. These
views are used as datasources for a number of reports.
The ADP links to the same views, same SQL side permissions. When run
these reports all error out that the views are ...
|
Write Conflict with Subform
Wed, 3 Sep 2008 14:42:01 -0700
I have a subform that the user accesses to input data. The user then selects
a record from the subform, clicks a control button, and a reference to the
selected record is recorded in a table on the main form. All of this actually
works, but when leaving the subform, the user the user is prompted with the
'Wr ...
|
SQL Windows Authenication
Wed, 3 Sep 2008 13:49:01 -0700
I have an application that uses Windows Authenication for the SQL access.
However, we have a number of workstations that are shared by users and have
a generic login to the workstation. I would like to be able to prompt the
user for their network userID & password and then authenicate.....not use the
ge ...
|
Unable to open Access 2003 database
Tue, 2 Sep 2008 09:17:00 -0700
When trying to open up an Access 2003 database, I get the following message:
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."
How can I reopen the database? ...
|
Combining 2 fields one may be null
Tue, 2 Sep 2008 09:48:56 -0600
I created a seemingly simple query to combine 2 fields. It works as long as
there is information in both fields however if there is a null in either the
field is blank. Fields are of type NVARCHAR
This is what I would like to have happen.
Proj_No Alias_Number Proj_Alias_Number Currently ...
|
COPYING SQL SERVER 2005 DATABASE
Thu, 28 Aug 2008 21:41:52 +0200
Hi
I'm making a program in Access ADP with a SQL server 2005 database.
I Have to write a code wich copy my active database DB1 into a new history
database DB2 on the same Server in DB1 ( .MDF an LDF) folder.
I'have found the following code and i used SQL DMO for that
Public Function CopyDB(ByVal strServer, ...
|
|
|
Access 2007 ADP (Runtime) and SQL Express 2005
Thu, 28 Aug 2008 11:32:01 -0700
Hi Everyone,
I have a problems which I'm struggling to resolve. Basically I have coverted
my Access 2000 database implemented for a client to Access 2007 (ADP) and SQL
2005 Express, also got hold of Access 2007 runtime and developer extensions.
I created a runtime setup of my access 2007 application with a ...
|
Re: Resync problem
Thu, 28 Aug 2008 13:33:02 -0400
I just looked at some of the changes I made while resolving similar issues
and saw that in addition to my suggestion to include Set NoCount On in any
stored procedures being used, I went back and added that same setting to all
triggers. Since that was the last thing I changed, maybe that was the key?
"Paul ...
|
Resync problem
Wed, 27 Aug 2008 04:09:01 -0700
After upgrading from Access 2003/SQL Server 2000 to Access 2007/SQL Server
2005 the following problem occurred:
In some forms with subforms the data source of the main form is a view and
the data source of the subform is a table with a field containing the ID of
the record in the main form. When I insert a ...
|
