SQL Server 2005 Express - Access 2007 - Vista

M

Moff

Hi,
How could I make modifications in the database of my Access 2007 project
with Windows Vista ? Seems that I will lose my job if I don't find very fast
:-(
Everything was perfect with Windows XP but I can't go back with XP.
Thank
 
M

Maurice

Make sure you tackle the following:

1. have sufficient rights in the specified directory (where the db resides)
2. manage the UAC settings (user account control) from vista - user
settings...
3. from within Access make sure the path where the db resides is marked as a
'trusted' location. Look under Office button -> Access Options - Trustcenter
- trustcenter settings.

hth
 
M

Moff

Thanks Maurice,
But I have modified rights for the mdf and also for the directories. I have
marked as trusted location the directories of both the adp file and mdf file.
As for UAC settings, I have only 2 choices : administrator or user and I'm
logged as administrator. None of your suggestions have gaved me the right to
modify my database. I'm the only user with SQL server and Access on the same
Vista PC. It's is very frustrating. I need to work with my Access project and
soon...
 
R

Rick Brandt

Moff said:
There are 3 Microsoft Access MPV online and no one can answer my
urgent problem ?
Click to expand...

1) Not many people use ADPs

2) You've asked a poorly worded question

By "moidifications" do you mean design changes to database structures or do
you simply mean changes to the data?

By "doesn't work in Vista" what exactly do you mean? Are error messages
involved? If so what are they?
 
S

Sylvain Lafontaine

I agree with the fact that the OP is poorly worded: even after many reading,
I still don't know if the problem is with modifying the ADP file itself,
modifying the database structure of the database attached to the SQL-Server
Express or simply modifying the data on this database.

Of course, there also no info at all on the type of account or login used
(windows authenticated, windows domain account, sql login account, sa, dbo,
guest???) to connect to this SQL-Server database and if he's able or not to
modify it (database structure and/or data) using any other program like the
SQL-Server Management Studio.
 
M

Moff

Thanks Rick and Sylvain,
Sorry for my English but I'm French. I currently use the French Message
Board but the English one is far more crowded and better. The problem is that
I don't have the rights to modify the data in the database (mdf file), even
if I'm the only user on the Windows Vista PC. I don't use a domain. I use a
workgroup. To connect to the database in the SQL Server, I use as name
FRANKPC\SQLEXPRESS. I use the Windows NT integrated security. The error I got
is "Microsoft Data Link Error - Test connection failed because of an error in
initializing provider." I have also tried to use the SQL-Server Management
Studo without success. I have read that Vista don't give full administrator
rights to programs. For the SQL Server it needs SQL-Server sysadministrator
rights, not the Vista administrator rights. Maybe it will be better for me to
ask for my problem in the SQL Server Message Board.
Thanks for your time!
 
S

Sylvain Lafontaine

I'm french too, I'll check the french message board and answer you there.
 
P

Paul Shapiro

The error means you are not able to login. There are a few choices.

You need to have a SQL Server login and that login needs to have accesss as
a User of your database. In Management Studio create a Login for your
Windows account. If you're in a domain, and logging in as a domain user,
that would be a domain account. If you're in a workgroup, or standalone, it
would be your local machine account.

Access' default connection is probably over TCP, which I think is disabled
by default in SQL Server 2005. Go to the Server Connection menu in Access
and adjust your connection until you can connect successfully. I believe
shared memory is the only connection enabled by default. Or run the SQL
Server Configuration Manager and enable whatever connections you want to
use. Shared memory is the default because its the most secure- only local
connections are possible.
 
M

Michael Gramelspacher

Hi,
How could I make modifications in the database of my Access 2007 project
with Windows Vista ? Seems that I will lose my job if I don't find very fast
:-(
Everything was perfect with Windows XP but I can't go back with XP.
Thank
Click to expand...

Did you try going to SQL Configuration Manager and looking whether SQL Server is running?

Does SQL Server status say running or stopped?
 
M

Moff

Hi,
The authenticated mode for SQL-Server Express I used was not mixte (Windows
NT Integrated security + SQL Login Accounts) and I was not using "sa" for
connection. That why it could'nt work with Vista.
Many Thanks, you're doing a great job!
 
Top