Ok, we have two SQL servers running for the past year or
two. I dont make changes often but today we opened up our
access program to connect to the SQL server. Whenever I
add a new table it's blank. It allows me to add the
category but when I click on the table to add info, the
column names are there but no while boxes. It's almost
like it's read only, excelt I'm using the sa account when
logging in. So, For kicks I set up another server (from
scratch (all are 2003) and am getting the same thing with
that also. I don't understand it.
With enterprise manager I can add info to the database,
but not from any computer trying to access it from
Microsoft Access. If I copy an exisiting table, I can add
items to that, just not creating a new one. Has anyone
else seen this problem?
I've been at this now for about 8 hours and I'm going
nuts. I've even created a new account called "test" gave
it ever permission available (admin, and all) and when I
try to open a table I create a I get a message that the
database has been disconnected. But whatever it is, all
the servers are doing the same thing. Could it be a patch
for WIN 2003 that might have caused it? I'm reaching here
but nothing seems to work. So here I am with 3 servers
now and I can't add a table to any of them unless it's
from enterprise manager. And even though I can add the
table (and data) from there, it's still read only like
when I open it in Access. There's no final row to add
more information into...
Help?Is this a shared Access database on a network drive?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> Ok, we have two SQL servers running for the past year or
> two. I dont make changes often but today we opened up our
> access program to connect to the SQL server. Whenever I
> add a new table it's blank. It allows me to add the
> category but when I click on the table to add info, the
> column names are there but no while boxes. It's almost
> like it's read only, excelt I'm using the sa account when
> logging in. So, For kicks I set up another server (from
> scratch (all are 2003) and am getting the same thing with
> that also. I don't understand it.
> With enterprise manager I can add info to the database,
> but not from any computer trying to access it from
> Microsoft Access. If I copy an exisiting table, I can add
> items to that, just not creating a new one. Has anyone
> else seen this problem?
> I've been at this now for about 8 hours and I'm going
> nuts. I've even created a new account called "test" gave
> it ever permission available (admin, and all) and when I
> try to open a table I create a I get a message that the
> database has been disconnected. But whatever it is, all
> the servers are doing the same thing. Could it be a patch
> for WIN 2003 that might have caused it? I'm reaching here
> but nothing seems to work. So here I am with 3 servers
> now and I can't add a table to any of them unless it's
> from enterprise manager. And even though I can add the
> table (and data) from there, it's still read only like
> when I open it in Access. There's no final row to add
> more information into...
> Help?|||Are you saying you cannot add data to an SQL Server table from MS Access?
If so, you'll need to define at least one column with a unique index.
Steve
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> Ok, we have two SQL servers running for the past year or
> two. I dont make changes often but today we opened up our
> access program to connect to the SQL server. Whenever I
> add a new table it's blank. It allows me to add the
> category but when I click on the table to add info, the
> column names are there but no while boxes. It's almost
> like it's read only, excelt I'm using the sa account when
> logging in. So, For kicks I set up another server (from
> scratch (all are 2003) and am getting the same thing with
> that also. I don't understand it.
> With enterprise manager I can add info to the database,
> but not from any computer trying to access it from
> Microsoft Access. If I copy an exisiting table, I can add
> items to that, just not creating a new one. Has anyone
> else seen this problem?
> I've been at this now for about 8 hours and I'm going
> nuts. I've even created a new account called "test" gave
> it ever permission available (admin, and all) and when I
> try to open a table I create a I get a message that the
> database has been disconnected. But whatever it is, all
> the servers are doing the same thing. Could it be a patch
> for WIN 2003 that might have caused it? I'm reaching here
> but nothing seems to work. So here I am with 3 servers
> now and I can't add a table to any of them unless it's
> from enterprise manager. And even though I can add the
> table (and data) from there, it's still read only like
> when I open it in Access. There's no final row to add
> more information into...
> Help?|||Yea exactly... I have an .adp file that opens the
database on the SQL server using sa as the ID. When I
create a new table using "design view" I:
1. Enter a few columns, for example right now I just put
one with Name, Address. Name is set to nvarchar with 50
as the length and Address is the same
(even made name an indexed field for kicks)
2. Clicked on the X box at the top right to close of that
window
3. Access says "DO you want to save changes to the design
of table2?
4. Selected Yes and then prompted with what name I want
to call it, put in test for this example
5. Get the standard message that no primary key is
defined. Told it Yes to create one.
6. Now, normally that design view goes away but it's
still here so clicked on the X again to close it out.
I now see "test" as a table. Click on test and I get the
standard view to enter data. However, I see Name and
Address as column headers but no box under it to enter
information. And at the bottom of that screen the only
box that is not grayed out is the one to set the max
record count being displayed.
Yes, nothing seems to work. On all three of the SQL
servers I get the same exact thing. Thought maybe by
chance it was my computer, went to another one and
created a bring new adp file on that system... same
thing...
I don't understand it... You can enter items into
anything that is already created, but nothing you create
new. And, the three server are *not* connected except for
all being in the same domain. No data is replicated
between them so it's something recent that caused it and
I honestly don't know where to begin...
I'm stumped.
>--Original Message--
>Are you saying you cannot add data to an SQL Server
table from MS Access?
>If so, you'll need to define at least one column with a
unique index.
>Steve
>"Steven C" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
>> Ok, we have two SQL servers running for the past year
or
>> two. I dont make changes often but today we opened up
our
>> access program to connect to the SQL server. Whenever I
>> add a new table it's blank. It allows me to add the
>> category but when I click on the table to add info, the
>> column names are there but no while boxes. It's almost
>> like it's read only, excelt I'm using the sa account
when
>> logging in. So, For kicks I set up another server (from
>> scratch (all are 2003) and am getting the same thing
with
>> that also. I don't understand it.
>> With enterprise manager I can add info to the database,
>> but not from any computer trying to access it from
>> Microsoft Access. If I copy an exisiting table, I can
add
>> items to that, just not creating a new one. Has anyone
>> else seen this problem?
>> I've been at this now for about 8 hours and I'm going
>> nuts. I've even created a new account called "test"
gave
>> it ever permission available (admin, and all) and when
I
>> try to open a table I create a I get a message that the
>> database has been disconnected. But whatever it is, all
>> the servers are doing the same thing. Could it be a
patch
>> for WIN 2003 that might have caused it? I'm reaching
here
>> but nothing seems to work. So here I am with 3 servers
>> now and I can't add a table to any of them unless it's
>> from enterprise manager. And even though I can add the
>> table (and data) from there, it's still read only like
>> when I open it in Access. There's no final row to add
>> more information into...
>> Help?
>
>.
>|||Did you declare a primary key for the table?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven C" <anonymous@.discussions.microsoft.com> wrote in message
news:1f6a301c457d2$47504c90$a101280a@.phx.gbl...
> Yea exactly... I have an .adp file that opens the
> database on the SQL server using sa as the ID. When I
> create a new table using "design view" I:
> 1. Enter a few columns, for example right now I just put
> one with Name, Address. Name is set to nvarchar with 50
> as the length and Address is the same
> (even made name an indexed field for kicks)
> 2. Clicked on the X box at the top right to close of that
> window
> 3. Access says "DO you want to save changes to the design
> of table2?
> 4. Selected Yes and then prompted with what name I want
> to call it, put in test for this example
> 5. Get the standard message that no primary key is
> defined. Told it Yes to create one.
> 6. Now, normally that design view goes away but it's
> still here so clicked on the X again to close it out.
> I now see "test" as a table. Click on test and I get the
> standard view to enter data. However, I see Name and
> Address as column headers but no box under it to enter
> information. And at the bottom of that screen the only
> box that is not grayed out is the one to set the max
> record count being displayed.
> Yes, nothing seems to work. On all three of the SQL
> servers I get the same exact thing. Thought maybe by
> chance it was my computer, went to another one and
> created a bring new adp file on that system... same
> thing...
> I don't understand it... You can enter items into
> anything that is already created, but nothing you create
> new. And, the three server are *not* connected except for
> all being in the same domain. No data is replicated
> between them so it's something recent that caused it and
> I honestly don't know where to begin...
> I'm stumped.
>
> >--Original Message--
> >Are you saying you cannot add data to an SQL Server
> table from MS Access?
> >
> >If so, you'll need to define at least one column with a
> unique index.
> >
> >Steve
> >
> >"Steven C" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:1f75f01c457c4$c7572480$a401280a@.phx.gbl...
> >> Ok, we have two SQL servers running for the past year
> or
> >> two. I dont make changes often but today we opened up
> our
> >> access program to connect to the SQL server. Whenever I
> >> add a new table it's blank. It allows me to add the
> >> category but when I click on the table to add info, the
> >> column names are there but no while boxes. It's almost
> >> like it's read only, excelt I'm using the sa account
> when
> >> logging in. So, For kicks I set up another server (from
> >> scratch (all are 2003) and am getting the same thing
> with
> >> that also. I don't understand it.
> >>
> >> With enterprise manager I can add info to the database,
> >> but not from any computer trying to access it from
> >> Microsoft Access. If I copy an exisiting table, I can
> add
> >> items to that, just not creating a new one. Has anyone
> >> else seen this problem?
> >>
> >> I've been at this now for about 8 hours and I'm going
> >> nuts. I've even created a new account called "test"
> gave
> >> it ever permission available (admin, and all) and when
> I
> >> try to open a table I create a I get a message that the
> >> database has been disconnected. But whatever it is, all
> >> the servers are doing the same thing. Could it be a
> patch
> >> for WIN 2003 that might have caused it? I'm reaching
> here
> >> but nothing seems to work. So here I am with 3 servers
> >> now and I can't add a table to any of them unless it's
> >> from enterprise manager. And even though I can add the
> >> table (and data) from there, it's still read only like
> >> when I open it in Access. There's no final row to add
> >> more information into...
> >>
> >> Help?
> >
> >
> >.
> >
sql
Udit Ghai wrote: