Access and MSDE

MSDE works fine and i'm able to connect from everywhere i want to, but there is still a little problem in my f* configuration. I'm not able to update or insert any data in the database from MS Access. Using osql or Java with JDBC or any other I'm able to do so, but not in Access.
Are you able to help me and solve it ?

thanks dragunOriginally posted by dragun
MSDE works fine and i'm able to connect from everywhere i want to, but there is still a little problem in my f* configuration. I'm not able to update or insert any data in the database from MS Access. Using osql or Java with JDBC or any other I'm able to do so, but not in Access.
Are you able to help me and solve it ?

thanks dragun

In past, I had a situation like this - tables on SQL Server (MSDE) did not have primary keys or unique indexes. It sounds stupid but...|||Ok, it's stupid without any primary key, but i want to know why i can't update any table? I can just read data via access and i need a solution.

bye|||Access needs a Primary key on the linked table (the table in MSDE). Without it, it cannot issue update or insert commands. Put a Primary Key on your SQL table, re-link the tables in Access and that should do it for you.

hmscott

Absolute Beginner Questions

I just downloaded and installed Visual Basic Express Edition and SQL Server Express Edition. All I have in the Start menu is SQL Configuration Tools. My absolutely stupid question is, how do I get started with this?

I know a little bit about SQL from using SQL command line in Oracle, and I've built small databases before using Access. Where does this program fit into all of that? And what do I use and how can I get started with this program?
Hi there,
What you've probably installed is only the database engine and probably the command line utilities. You could connect and work with your databases via the command line but it's easier doing it via a GUI. Couple of options:
A) You can download SQL Server Management Studio Express Edition here:
http://msdn.microsoft.com/vstudio/express/sql/download/
This'll give you a GUI where you can connect to the database server (which you have installed already) and you can work with and create databases in it.
B) It is also possible to create and work with your database using Visual Basic Express Edition. Generally you'll create a project first (e.g. a Windows Application) and then you'd create a database for your project. The steps are:

1) In the Solution Explorer right click on the name of the solution and select Add > New Item from the menu that appears
2) The "Add New Item" window will appear. In this window select the "SQL Database" template. Change the name of the database's .mdf file to whatever you prefer.
Click "Next>" after doing the above
3) Select whatever database objects you want in your dataset (I select everything that's available but it does depend on what you want). Click the "Finish" button
After doing all of this a database local to the project you are working with will be created. If you open up Database Explorer (View Menu > Database Explorer or View Menu > Other Windows > Database Explorer) you should see you database. You can then do things like create tables for your DB and make an application that connects to your database and does, well, stuff (sorry).

As for learning more about it, try reading some stuff at:
http://www.microsoft.com/sql/editions/express/default.mspx
http://msdn.microsoft.com/sql/express/
They should give you some overview of the product. The Developer Center (2nd link) might give you some ideas to get started in coding database apps with VB Express Edition.
There's also a white paper that might help get you going with Management Studio Express at:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/MgSQLExpwSSMSE.doc
Hope that helps a bit, but sorry if it doesn't

about setup

Just appear 'configuration tools' and 'documentation and tutorials' after installed katmai June CTP

OS: WinXP sp2

any idea about this? many thanks

resetup failed,error code is :-2147467259 Message:Unspecified error
Log shown below:
MSI (s) (CC:04) [21:03:16:062]: Note: 1: 1708
MSI (s) (CC:04) [21:03:16:062]: Product: Microsoft SQL Server "Katmai" Tools -- Installation failed.

MSI (s) (CC:04) [21:03:16:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:04) [21:03:16:093]: MainEngineThread is returning 1603
MSI (s) (CC:24) [21:03:16:203]: Destroying RemoteAPI object.
MSI (s) (CC:70) [21:03:16:203]: Custom Action Manager thread ending.
=== Logging stopped: 6/27/2007 21:03:16 ===
MSI (c) (AC:1C) [21:03:16:234]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (AC:1C) [21:03:16:234]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/27/2007 21:03:16 ===

Also, I already uninstalled workstation component of 2005

What's this matter? thanks

|||Well, I think the solution was came from mverun
My VS8 was installed in non-default folder

about SAN

Dear gurus,
We wish a good migration, faster and the less traumatic possible. So that
after five years with the same logical configuration, hardware and so on the
main point is to improve considerably the availability and drop once for all
our bottlenecks.
We’ve got an A-A cluster running with W2000k and Sql2000k. There are
approximately 50 databases and on paper and thinking in the upcoming change
s
we’ve created three logical groups according five variables: criticity,
usage, size, growing, volatility data
A: Critical
B: Medium usage
C: Historical data or database with little load.
Well, currently LDF are living along with NDF in the same volume.
Idea is moving to a SAN (fitted with faster disks) and isolating of course
all those LDF in separated volumes.
Probably there will be one controller with four channels and one though at
the moment is having in one channel the group A and the second channel group
B. Third channel will be reserved for LOG and the last one for the group C.
I don’t know if I my explanations has not been very clear. Let me know if
I
can provide you more relevant information.
How many thing must I take into account in this tricky migration?
Does anyone has ever experienced with former and similar plan?
Thanks in advance for any input or comment.
Regards,Hi Enric,
Seperating log files is a good starting point, also if you have high tempdb
usage consider to separate temp db as well. Also Raid 1 for log files and
Raid 10 (Raid 1 + 0) if possible if not Raid 5 is for Data files are ideal.
If you want to spread IO across your disks to prevent bottlenecks so LUN
configuration is very importnant and it really depends on your SAN
configuration. But we ususally use two methods:
1) Analyze data files usage using fn_virtualfilestats (see BOL for details)
and spread the data files across different LUNs, controllers etc. by moving
them (You have to analyze for all 50 db's you have.)
2) Creating the LUNS across multiple arrays to spread disk IO
As you can see it really depends on your SAN configuration and also your db
usage. You have to analyze well in the beginning becouse it's hard to change
to configuration later. And it really depends on your priorities
(performance, isolation of env., availability etc..)
And i also recomment you to upgrade Windows 2003 OS as well.
Regards.
"Enric" wrote:

> Dear gurus,
> We wish a good migration, faster and the less traumatic possible. So that
> after five years with the same logical configuration, hardware and so on t
he
> main point is to improve considerably the availability and drop once for a
ll
> our bottlenecks.
> We’ve got an A-A cluster running with W2000k and Sql2000k. There are
> approximately 50 databases and on paper and thinking in the upcoming chan
ges
> we’ve created three logical groups according five variables: criticity,
> usage, size, growing, volatility data
> A: Critical
> B: Medium usage
> C: Historical data or database with little load.
> Well, currently LDF are living along with NDF in the same volume.
> Idea is moving to a SAN (fitted with faster disks) and isolating of course
> all those LDF in separated volumes.
> Probably there will be one controller with four channels and one though at
> the moment is having in one channel the group A and the second channel gro
up
> B. Third channel will be reserved for LOG and the last one for the group C
.
> I don’t know if I my explanations has not been very clear. Let me know i
f I
> can provide you more relevant information.
> How many thing must I take into account in this tricky migration?
> Does anyone has ever experienced with former and similar plan?
> Thanks in advance for any input or comment.
> Regards,
>|||http://www.microsoft.com/technet/pr...ver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:A763B6DC-6130-43F0-B153-78CC5301E8CC@.microsoft.com...
> Dear gurus,
> We wish a good migration, faster and the less traumatic possible. So that
> after five years with the same logical configuration, hardware and so on t
he
> main point is to improve considerably the availability and drop once for a
ll
> our bottlenecks.
> We’ve got an A-A cluster running with W2000k and Sql2000k. There are
> approximately 50 databases and on paper and thinking in the upcoming chan
ges
> we’ve created three logical groups according five variables: criticity,
> usage, size, growing, volatility data
> A: Critical
> B: Medium usage
> C: Historical data or database with little load.
> Well, currently LDF are living along with NDF in the same volume.
> Idea is moving to a SAN (fitted with faster disks) and isolating of course
> all those LDF in separated volumes.
> Probably there will be one controller with four channels and one though at
> the moment is having in one channel the group A and the second channel gro
up
> B. Third channel will be reserved for LOG and the last one for the group C
.
> I don’t know if I my explanations has not been very clear. Let me know i
f I
> can provide you more relevant information.
> How many thing must I take into account in this tricky migration?
> Does anyone has ever experienced with former and similar plan?
> Thanks in advance for any input or comment.
> Regards,
>|||Thanks a lot for your comments,
"Umut Nazlica" wrote:
> Hi Enric,
> Seperating log files is a good starting point, also if you have high tempd
b
> usage consider to separate temp db as well. Also Raid 1 for log files and
> Raid 10 (Raid 1 + 0) if possible if not Raid 5 is for Data files are ideal
.
> If you want to spread IO across your disks to prevent bottlenecks so LUN
> configuration is very importnant and it really depends on your SAN
> configuration. But we ususally use two methods:
> 1) Analyze data files usage using fn_virtualfilestats (see BOL for details
)
> and spread the data files across different LUNs, controllers etc. by movin
g
> them (You have to analyze for all 50 db's you have.)
> 2) Creating the LUNS across multiple arrays to spread disk IO
> As you can see it really depends on your SAN configuration and also your d
b
> usage. You have to analyze well in the beginning becouse it's hard to chan
ge
> to configuration later. And it really depends on your priorities
> (performance, isolation of env., availability etc..)
> And i also recomment you to upgrade Windows 2003 OS as well.
> Regards.
> "Enric" wrote:
>