|
mettre a jour sql serveur
bonjour impossible ouvrir ou telecharger galerie photo windows ;errur galeri
photos ne s ouvre pos
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft We...
|
1 |
12/9/2008 8:35:02 AM |
|
|
Access 2007 and Sql Server 2008
Is there a trick to getting Access 2007 to create an ADP against Sql Server 2008? Whenever I try it, I get an error message saying
the New Database Wizard is designed to only work against Sql Server v6.5 (SP5) or higher...which I'm pretty sure Sql Server 2008 is.
- Mark...
|
24 |
12/8/2008 7:52:27 AM |
|
|
Passing Parameters between Access Project and SQL
I hope I am posting to the correct area if not please let me know. I am
preparing to upsize my Access DB to SQL server 2000 (Small Business Server
2k3). I have many Queries in Access that use data from forms as parameters.
Question: how do I pass data from my forms (Access project) to
Procedures/functions in SQL? Example I have a form that allows the user to
select a county in the state...
|
7 |
12/8/2008 2:24:26 AM |
|
|
Do I need to set..
I am exploring ADP, please bare with me if my questions appear to be too
simple or off-line.
I have converted my Access03 to an ADP project and another similar copy to
SQL tables only (just to see the different).
Questions:
1) For mdb I need to manually compact or do this automatically on close. I
understand that for SQLexpress, I do not need to do this. Any setting
required.
2) Fo...
|
6 |
12/8/2008 2:01:57 AM |
|
|
list box selection as filter
I need a little help understanding how filters work in ADP. I have a form
that worked in an mdb that allowed users to select multiple items from a list
box and have them applied as filters on a report.
When I try to run this in ADP i get "Error 207 - Invalid column name" and
then the value of the list box selection.
Below is the code (I believe I got it from an Allen Browne post) and I ca...
|
2 |
12/8/2008 1:56:27 AM |
|
|
SQL Server tables in Access 2007 are read-only via ADP !
I imported a number of Access 2003 MDBs and ADPs when we upgraded to Office
2007, and I never stop running into problems with the new version. The latest
one is that I find I can't edit fields in a SQL-Server (2005) table using an
ADP front end. This worked fine before the "upgrade" !
Are there some sneaky settings somewhere that need changing?
Thanks!...
|
5 |
12/3/2008 11:53:03 PM |
|
|
Export more than 65536 records from ADP to excel 2007
The user has moved from office 2003 to office 2007. The access adp solution
is developed in access 2003 and works perfectly in with office 2007 except
for some details.
How can I export more than 65536 records from access adp client to excel 2007?
Here is a part of the current VBA code:
RS is an adodb.recordset containing the records to be exported.
ExcelRange.CopyFromRecordset RS ...
|
13 |
12/3/2008 10:11:01 AM |
|
|
ADO connections question
Is is better to open one ADO Connection to the database and persist it across
all forms or is it better to open the connection, execute the view or stored
procedure, and then close it?
Also, if I do keep the connection open can I open it in the login form and
then with all forms do something like the following?
Set cnnADO = CurrentProject.Connection
The reason I ask is that if I close...
|
5 |
12/2/2008 9:00:02 PM |
|
|
How do Access queries work?
I have a question on how Access queries work. I have a .mdb and all tables
are linked to a SQL backend. When I create a query and add criteria, does
Access bring all the data from that table to the client and then applies the
criteria or is the data filtered on the server and only the data requested
by the query sent to the client?
Thank you
...
|
2 |
12/2/2008 6:42:00 PM |
|
|
Reference to Alias Columns
I have a query in which I have several Alias Columns I must use in other
columns. However, every time I attempt to refer to an Alias the sql errs the
procedure. Any suggestions, I have a very complicated Leave Query that needs
to determine leave updates for each month and refers to Alias columns
continually.
Thansk for any assistance. ...
|
8 |
12/2/2008 6:40:03 AM |
|
|
Reasons that queries has no result
I moved all my tables to SQLexpress to take advantage of some of its features.
Now most of my queries have no result. How can this be, I thought the
queries will not be affected if I move just the tables. I did not convert to
ADP as there will be too much changes required and I am not familiar with
most.
Scenario:
Create a one table query (qry1) , I cannot see the result.
Create a ...
|
5 |
11/24/2008 2:17:37 AM |
|
|
sa password
I'm working on a windows vista laptop. I recently installed MS Office and,
when trying to create a SQL database I'm being requested to login. I don't
know what the sa password is. Is there a default? What can I do?
Thanks a lot in advanced!
--
Mario R. Osorio
"... Begin mith The end in mind ..."
...
|
3 |
11/22/2008 9:36:46 AM |
|
|
client / server packets
SQL 2005 - Access 2007 (project)
are the packets sent between client and server in plain text?
if so what are options to encrypt them.
Thanks
--
Richard...
|
6 |
11/21/2008 5:43:51 AM |
|
|
Split Forms and ADP issues
I have an (exisitng) ADP database. I know that there are things that you can
and cannot do with an ADP, but I don't know what they are. Any suggestions
on where to brush up on that would be appreciated.
I need to create a form where users can update a product promotion category
on several records (product briefs) at a time. They don't want to have to
enter each product brief, add/ch...
|
3 |
11/20/2008 4:53:01 PM |
|
|
nog een
hoi
Wel gek ik moet nieuwsgroepen invullen om een mailtje te verzenden
mailte terug kijken of het werkt.
gr marco...
|
3 |
11/20/2008 1:52:39 PM |
|
|
Access 2003 or 2007 Compatible with SQL Server 2008
We currently are using Access 2003 and SQL Server 2000. We plan to upgrade
our SQL Server to 2008. Our biggest concern is the Compatibility issues with
access. Ideally we would like to stay on Access 2003, but what little
research I have done, it does not look like Access 2003 is compatible with
SQL Server 2008. The next step would be for us to upgrade Access 2003 to
2007 and use it...
|
4 |
11/19/2008 10:20:54 PM |
|
|
Data Type nvarchar or varchar
When we use upgrade wizard to migrate ms access to sql server, the fields
data type text is converted to nvarchar.
My question is, Can I change nvarchar to varchar? These changes does it not
affect nothing?
Thanks
JCP
...
|
14 |
11/16/2008 8:26:35 PM |
|
|
Forms and Recordsource Options
What's the difference if I use a view or an SP for a record source? Any
processing considerations?
E.g., since I'm planning to open multiple instances of my form, I'm going to
set my record source on the fly, contributing my record key from a global
variable* so I could do either:
RecordSource="SELECT * from vw_MyView Where myKeyField=" & global_variable
or
InputParameters = gl...
|
7 |
11/16/2008 8:19:51 PM |
|
|
ADV Conversion to .Net
Hi,
We've now come to the conclusion that ADPs and Access are not the best
platform moving forward for our database front-ends... Has anyone converted
or migrated to VB.NET - and if so, how did you do it?
I'm rather hoping that we can slowly migrate forms within our Access ADP
into VB.Net as we need to - and use a bit of both (ADP and VB.NET) until
eventually we have it complete.
I know...
|
15 |
11/16/2008 3:42:05 PM |
|
|
White Paper on How MSAccess interacts with SQL Server Back End?
Hi All,
I'm having some performance issues with someoe trying to retrieve data from
my SQL 2000 db using ACC2003 as the front end via linked tables.
I'd like to know more at a technical level about how ACC compiles an data
access path, hands it off os SQL2K , how SQL interprets it and then returns
the dataset.
Finally, exactly what is ACC2003 then processing? Is it the entire datase...
|
4 |
11/16/2008 3:36:15 PM |
|
|
Form permission issue
I have developed an adp and now I'm in the process of assigning permissions
to groups but am having some problems. I have a form that has a stored
procedure as a recordsource and I have assigned execute permissions to a
group called manaagers but when they try to update a field the form gives a
message at the bottom that says the recordset is not updatable. I have even
given all permissions t...
|
7 |
11/14/2008 11:57:08 PM |
|
|
who are you people and why are you invading my email
This computer is owend by Me, Michael Siano I recently discoverd that there
are 277 users logging on to my email and using it to send messages to other
third party users . I want to go on the record and demand that you cease and
desisst from thid party practice imediately. I have attaches all of your
address info and IP#s and they've been sent to the Microsoft consumer and
tech support p...
|
3 |
11/14/2008 10:35:13 PM |
|
|
sql server login best practice questions
I have several sql server databases that I have inherited and there are some
differences in how users access the server from how I had always done things
before. I had always had each user have a seperate login account and then
assign them to groups on the sql server. The way things are on my inherited
server is there are no individual logins rather the logins are Windows Active
Directory gr...
|
2 |
11/14/2008 7:20:44 PM |
|
|
Using Access 2007 to connect to SQL
Hi all,
I'm a total newbie w MS SQL Server. We're running SQL 2005 here w a new
system. I need to pull data from SQL into my Access 2007 Policy Issuance
system. Eventually I'll migrate this data to SQL too but for now its being
stored in a backend Access database. We have a contractor working in the
back-end of our new sytem. She's setting it up so that our users will enter
a quote ID...
|
3 |
11/13/2008 6:32:41 PM |
|
|
import data from Access to SQL2005 64bit problem
Dear friends,
I have a table in an access file and want to import it to a MsSql database.
I have SQL2005 64bit version.
to do import, I tried to create a LinkedServer to access file but failed
because have not jetConnect. As I knew I should install MDAC. I tried to
find MDAC for x64 installation, but failed
-Is there any other way to import data from access table to MSSQL?
-Where can I fi...
|
4 |
11/8/2008 8:12:35 PM |