|
ADP - Form Edit
I have a form bound to a SQL Server stored proc. The stored procedure links
2 tables, both of which have a unique index. I have set the unique table
property of the form to be the table to be updated or have rows inserted -
this is the many join relationship of the select query of the stored
procedure.
When add a new record the following Microsoft Access msg is returned:
The data was add...
|
5 |
09.05.2006 14:13:56 |
|
|
Base de dados
Onde poderei encontrar uma base de dados para um concurso musical?
Obrigado.
...
|
1 |
09.05.2006 13:05:55 |
|
|
ADE - file is locked for editing by anothr user...
Hi,
An ADE file that is accessed by multiple users returns the following msg when
accessed by more than one user:
The MS Access project will be opened read-only because one of the following
occurred:
The file is locked for editing by another user, or the file / folder is
marked as read-only
From previous posts i have tried starting up the ADE with the /ro startup
option in a dev envir...
|
9 |
08.05.2006 18:28:48 |
|
|
adp form combo box
Hi
I'm really new to adp,
I created a form with a combo box (1) to a with a list.
Once I selected a value from combox 1, I want to use that value for my
filter for my combox 2
Can I can I do that from the row source?
I can use both view or sp.
Can anyone help?
Thanks
...
|
2 |
08.05.2006 15:42:41 |
|
|
IIS Virtual Directory Management for SQL Server Utility under Windows 2003 SBS Premium - problem !!!
I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error. I did it under
companyweb.
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?
I applied
http://support.microsoft.com/default.aspx?scid=kb;en-us;810784&Product=sql2k...
|
2 |
08.05.2006 07:34:44 |
|
|
database mirroring
hi,
i'm new to this group.
i wonder if i can get answers to my question here, cos i cant find a
newsgroup with database mirroring.
i have two servers :
pSQL - principal
mSQL - mirror
Have successfully create the endpoints at both servers.
Have checked on the port 5021 listening at both servers.
Have successfully ping and see each other in network.
*
but can only set the partner...
|
2 |
05.05.2006 18:46:02 |
|
|
MoveNext Prolbem
I have a SQL Server backend and Access frontend using OpenRecordset and
MoveNext. One of the tables used in the query has Identity. The MoveNext is
not advancing the record pointer. Why? Thanks....
|
1 |
05.05.2006 12:27:02 |
|
|
Windows Synchronization Manger No longer Works
Thank for your assistance in advance.
Windows Synchronisation Manager on one my machines can no longer sychronize
files after I deleted a subscription database. I deleted it using Windows
Sychronization Manager through a Dial-up connection. The deletion was
successful.
Now I want to sychronize the other remaining subscriptons, Windows
Synchronization Manger simply says "Synchronization Com...
|
1 |
05.05.2006 08:24:26 |
|
|
Problem with UDF & decimal
Losing what's left of my hair over this one, cannot get this to work. Access
2003
-----------------------------------------------------------------------------
FUNCTION dbo.mbtest
(@parameter decimal(3,2) )
RETURNS decimal(3,2)
AS
BEGIN
select @parameter = @parameter
RETURN @parameter
END
----------------------------------------------------------------
If I run this from an ...
|
5 |
05.05.2006 06:59:41 |
|
|
write conflict (multi user environment)
Hello,
I simply can't get around the write conflict problem, even
tough I "googled" quite a lot.
We're running a "Free/Budy" database where several users are chaning
records at a time. In general, users are only editing their appointments
but it might be that somebody is chaning it for somebody else.
So I of course get the typical "write conflict" message when the
record has been edit...
|
3 |
05.05.2006 06:49:24 |
|
|
Cursor Simulation SQL Failure
I created some SQL which I incorporated into a query to select a current and
prior record. After a few second delay, after clicking the button to go to
the end of the query results, the following message is displayed: At most
one record can be returned by this subquery. I put distincts in each subquery
but got the same results. Other than that, it works and returns the current
record ...
|
2 |
04.05.2006 19:12:54 |
|
|
Login prompt, blank username
How can I set it so there is a blank user name in the login prompt?
...
|
1 |
04.05.2006 09:55:30 |
|
|
When is a delete completed in an APD bound form?
Hi,
I wonder which event to use in order to requery the content of a subform
after the user has deleted a record in another bound listform. I understand
that the order of events is BeforeDeleteConfirm, AfterDeleteConfirm, Delete.
So I put the code in the Delete event but it doesn't work. Probably the
record is not yet deleted because the Delete event has a Cancel parameter.
Using Access ...
|
2 |
04.05.2006 08:34:16 |
|
|
Disable Saving Connection in ADP
Hi,
I build a connection in my start up code. Access Data Projects save
the last used connection properties. I was wondering if anybody knows
of a way to avoid allowing Access to connect to the database prior to
my code running. This application gets distributed to other
workstations and I don't want it carrying any logon information.
Thanks
...
|
9 |
03.05.2006 23:11:45 |
|
|
update a SQL 2005 Express table with an MS Access 2003 table
I've been using MS Access for the past 5 years, and I've never ventured any
further. I am now working on creating a more robust application using Visual
Web Developer 2005 and SQL Server 2005 Express.
Before I get too far into development, I want to ensure that I can upload my
Access table into my SQL database.
I started by creating a SQL database and a new table with all the columns
...
|
3 |
03.05.2006 16:48:02 |
|
|
¦³¬O»ò¦nª±ªº°Ú ,µo¨Óª±ª±!
ÁÂÁ°Õ!!
...
|
1 |
03.05.2006 14:07:41 |
|
|
(CROSS POSTED) Very strange: Connection under process info not whats in front-end
Firstly... Sorry for crossposting (microsoft.public.sqlserver.security) but
I'm desperate and confused :o(
I'm using SQL 2000 on XP with an ADP front-end.
I just set up a test database so I can start figuring out security etc.
The front-end connection is using Windows authentication and is logged on as
myself (Mark) yet when I look at process info in current activity in
Enterprise Man...
|
9 |
03.05.2006 12:55:35 |
|
|
Assign Child Records from Template Parent Record to Current Parent Record
I have a parent table P with a child table C. I have a justified form for
the parent table with a tabular subform listing all associated child
records. Since I have several known situations where the initial set of
child records would be standard, I would like to create a simple, almost
non-programmatic way to copy all the records in the child table of a
template record to the current...
|
2 |
02.05.2006 18:01:11 |
|
|
Need to compare Fields
I need to compare the fields of my "master" table to severals installation
to make the propers changes.
Exist any function to retrieve info about each fiels?
Any suggestion is welcome.
Thanks,
...
|
2 |
02.05.2006 16:44:26 |
|
|
ADP: Error calling SP with "EXEC sp_helprotect" statement
I am trying to create an SP which
(1) populates a temporary table from sp_helprotect ("INSERT . . .
EXEC sp_helprotect");
(2) cursors through the temp table to update a user table;
(3) displays the newly updated user table in Access ADP.
The routine works perfectly from Query Analyser, but fails with the
message "stored procedure executed correctly but did not return
records" when c...
|
19 |
29.04.2006 21:27:27 |
|
|
ÎÒÊÇÂÀ
...
|
1 |
29.04.2006 03:35:53 |
|
|
ADO newby question
I am migrating my MDB forms and reports to ADP (2003) connected to SQL
Server 2000. My forms are bound to the currentproject connection and single
tables on the server.
Very basic question:
In VBA how do I force an update or insert after a record is edited or added
so that the AfterUpdate or AfterInsert events get fired? These events occur
if I use the the navigation buttons to change re...
|
2 |
28.04.2006 21:51:57 |
|
|
Access2003 and conection to MS SQL
Access2003 and conection to MS SQL
I configured Access 2003 database with linked tables to MS SQL that uses
SQL authorization. I did it via ODBC. I would like that every user have
to enter his login after startimg MS Access database and password and
that user should be used to linking tables.
How to do it?
--
CrossPost......
|
11 |
27.04.2006 18:25:43 |
|
|
Open parameterised stored proc as a resultset in a window
Hi
not very familiar with ADP, so I'm not sure I can do this.
Double-click on a stored proc in the Stored Procs view in Access. It
prompts me for two parameters. As expected. Then it opens the
resultset in a normal Access "table/query view data" window.
How can I do exactly this in VBA, but providing the parameters so that
the user doesn't get prompted for the parameters?
Back in...
|
3 |
27.04.2006 10:06:27 |
|
|
Executing SP from Access form
Hi all. I'm experiencing the following problem: I have an ADP db linked to
SQL Server 2000. Through a form I launch a SP using the method
CurrentProject.Connection.Execute and then open a report with a DoCmd. The SP
initially empty a table using a DELETE and then populate it with INSERT and
UPDATES. Now using my user everything is OK, the SP runs correctly and the
report shows the expect...
|
7 |
27.04.2006 06:50:01 |