|
Printing off field list
hi
I note that Tools/Analyse isn't available for Adps. How do I print off a
list of all fields in a table?
Its a SQL Server table, so if its better to just print from there, let me
know how please.
Thanks
Diarmuid
...
|
1 |
04.07.2006 14:13:18 |
|
|
New to ADP
Hi
I've been programming Access for years, but always Mdb. I've just started a
new job, and my first assignment is an Adp.
Looks very similiar - so far!
Is there anything I should be aware of, things I could do in a Mdb that I
can't do in an Adp?
Or, better still, extra features in an Adp that I should know of?
Thanks
Diarmuid
...
|
4 |
04.07.2006 13:56:14 |
|
|
Write Conflict on same form
I am getting the following error: Write Conflict--"This record has been
changed by another user since you started editing it...."
I think I know why, but I am sot sure what to do about it.
I have a main form with a sub form, each is based on a stored procedure
with only one table in it (not the same table) and only one parameter.
When I make a change to anythign in the subform I update t...
|
6 |
04.07.2006 01:56:02 |
|
|
SQL Server Error 18456
I'm running an Access 2000 Database on Windows 2000. The Access Database
links to SQL Server 2000 tables. The error occurs when the users login with
their windows login (my sql server is mixed authentication) and open the
database to open the tables or forms. The connection will fail with the
following:
Connection failed:
SQLState '28000'
SQL Server Error 18456
...
|
2 |
03.07.2006 21:15:13 |
|
|
too much short - ResyncCommand
\I must set up a very long string in the ResyncCommand property.
Unfortunately there is a limit of in this property. How much is the limit?
How can be exceeded the limit?
Someone has suggestions for me? Thanks in advance for who solve this problem.
Michela
...
|
2 |
03.07.2006 15:48:24 |
|
|
connect yo database access with password
hi !
how i can connect to my database in ASP only with password
i connect to my database like this:
dim conn,SQLstr,rs
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("/ts_egged/db1.mdb")
...
|
2 |
02.07.2006 10:59:26 |
|
|
ADE or MDE: Does this sound logical?
Hi
Sorry, this is all a bit "after the fact", but I'm interested in oppinions
please as I may adopt this approach again:
I recently developed an application for a client which has to run on a very
slow and unreliable network. Replication is not on the menu for various
reasons, MSDE backend and the front-end needed to be MS Access (XP) as they
are already familiar with VBA etc.
I d...
|
3 |
30.06.2006 22:16:41 |
|
|
Access Front End broke. Due to concurrent users?
I searched this forum but didn't find anything like this that looked like it
was particular to .ADP files. Maybe that's because it doesn't matter what
kind of file you're using. If so, I apologize for being bone-headed.
We (not me, I didn't do it) have a .ADP front end housed on a network drive.
It is the only copy of the front end in use for several concurrent users and
it broke--fortuna...
|
3 |
30.06.2006 18:12:56 |
|
|
asunto
...
|
1 |
30.06.2006 11:51:16 |
|
|
asunto
...
|
1 |
30.06.2006 11:51:16 |
|
|
transferspreadsheet is very slow
The customer uses windows 2000 and office 2000. I have made an access 2000
project (.adp file) as client connected via network to sql server 2000
server.
The problem is that import of excel worksheet via the client has become so
slow. It takes 10 minutes to import 4000 lines / 14 columns from excel. Some
weeks ago the same operation was done in a few seconds.
In the Access client i ...
|
4 |
30.06.2006 10:35:48 |
|
|
Modifying Sql server data through Access
We are planning to move our database from Access to Sql server.But the front
end application to remain in Access.We will be creating ODBC links to the sql
server database to use its functionality. The problem is if while creating
the links in Access if I do not supply the field for indexing, Sql server
does not allow me to modify the tables through Access. I do not prefer to
supply index key...
|
9 |
29.06.2006 22:41:01 |
|
|
ÕâÀïÔõôÊÇÕâÑùµÄ..........
ÇëÎÊ..ÓÐûÓÐרÃÅÖйúÈ˵ĵط½
...
|
3 |
29.06.2006 12:38:31 |
|
|
Query limitation
Being new to access, I used the Query builder to identify the field list in
Report Generator. I'm creating a report in Report Generator that pulls across
multiple tables. As many as 8. When I get to the sixth table, it causes the
links to come up with an error. 5 tables is fine and everything links
correctly, when I add the sixth, all the links on the report #error
Here is the SQL state...
|
3 |
29.06.2006 01:02:02 |
|
|
Get logged in username
Would like to update a field with current logged in username (Active
Directory) whenever inserts and/or edits occur in a form. Using Windows
Authentication on SQL 2000. Dont know where to begin. Thanks
...
|
4 |
28.06.2006 21:13:02 |
|
|
Mail Merge with Access query linked to SQL tables
Hi,
I just can't figure this out! I have a mail merge that works with an Access
2000 parameter query (with linked Access tables). Been working for months.
I've changed the parameter query to use linked SQL Server tables and it
works fine from Access. When I try to connect the new query to my Word
document, I'm unable to see the new query in the list. I've seen other
suggestions tha...
|
2 |
28.06.2006 20:07:16 |
|
|
DBCC TRACEON
Goof morning,
I still have in the event log next messages :
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 28.6.2006
Time: 8:21:44
User: N/A
Computer: XY
Description:
17550 :
DBCC TRACEON 1204, server process ID (SPID) 56.
Maybe it is possible colision in our SQL application, or anybody write me
some next informations.
Very th...
|
2 |
28.06.2006 14:44:31 |
|
|
ÒªMSN MESSENGER£¡
±¾ÈËÏëÒªÒ»¸öMSN MESSENGER 7.0£¬Íû´ó¼Ò°ïÎÒÕÒÕÒ¿´£¡È»ºó°Ñ°²×°³ÌÐò·Åµ½¸½¼þÖз¢
¹ýÀ´¡£
...
|
1 |
28.06.2006 10:35:47 |
|
|
ÇóÖúÐÂÎÅ×é Ó÷¨£¡£¡£¡
...
|
5 |
28.06.2006 10:28:30 |
|
|
ADP & ODBC
Okay, I'm just about at my wits end trying to get this to work. Here is our
setup:
Windows Server 2003 w/ Microsoft SQL server version 8.0. We have a database
setup on the SQL Server along with an ADP project. The ADP project works as
expected. I copied the project and pasted it onto another computer w/n the
same network. I'm still a newbie with ADP and my instincts told me that in
or...
|
5 |
27.06.2006 16:48:10 |
|
|
identifying the form that has lauched a form
Hi,
I would like to be able to identify the form that loaded a particular form
so I can do refreshes and updates to the correct form, is there an easy way
of doing this?
I was going to pass a paramater on launch to identify the calling form and
store this in a variable but no quite sure how to do it. The code to launch
the form is below.
DoCmd.OpenForm ("formname")...
|
12 |
27.06.2006 02:57:55 |
|
|
dfdf
...
|
1 |
27.06.2006 01:31:54 |
|
|
Change data type
I have a table named Addressbook with fields:
ID int
Name nvarchar
I want to change the type of ID to:
int IDENTITY 1,1
Is there any way to do it from SQL Query Analyzer?
Thanks
Dimitris
...
|
2 |
26.06.2006 20:06:26 |
|
|
Running T_SQL scripts form Access
If I have a TSQL script to create a table (for example), is there some way I
can can I run it against a SQL Server database from Access?
I assumed I could just paste it into a Query window, but I can't get it to
work that way....
|
13 |
22.06.2006 06:59:46 |
|
|
Form with Combo Boxes
Hello!
Im trying to make a form in Ms Access ADP XP, and using a Back end SQL
Server 2000.
Everything is great, and works fine, But I will use this app by Internet.
Any advise in how to improve speed. Maybe using lees combo boxes? I use
them so I can select info from records from other tables.
Any advise, help, or link will be great!
thanks!!
...
|
3 |
22.06.2006 00:43:09 |