SQL db Linking issues

[Guest]

I have two questions about my Access 2000 db and the tables are linked to an
SQL db.
1. Can I add a field to the SQL table then update the linked tables while
other people have it open with MS Runtime.
2. I tried to change the data type in the SLQ table and I get this error:

'tblTrackingData' table
- Unable to create index 'PK_tblTrackingData_1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for
database 'AGS_PROD' is full. Back up the transaction log for the database to
free up some log space.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table
'tblTrackingData' has been created but its maximum row size (24304) exceeds
the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this
table will fail if the resulting row length exceeds 8060 bytes.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[Guest]

That is not an option. I work for Blue Cross/Blue Shield and they have no
plans at this time to move from 2000 version, hundards of people thru out the
state use this database.
Are you telling me I can never add or change another field unless I upgrate
to 2004???

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

I have two questions about my Access 2000 db and the tables are linked to
an
SQL db.
1. Can I add a field to the SQL table then update the linked tables while
other people have it open with MS Runtime.
2. I tried to change the data type in the SLQ table and I get this error:

'tblTrackingData' table
- Unable to create index 'PK_tblTrackingData_1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file
for
database 'AGS_PROD' is full. Back up the transaction log for the database
to
free up some log space.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create
constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table
'tblTrackingData' has been created but its maximum row size (24304)
exceeds
the maximum number of bytes per row (8060). INSERT or UPDATE of a row in
this
table will fail if the resulting row length exceeds 8060 bytes.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.

 

[John Spencer]

Ignore the post from David Pawloski. It is spam.

You should probably post the problem you are having with changing a field
type in one of the MS SQL groups.

The errors you are getting indicate to me that you don't have a backup set
for your database on the MS SQL database server. That means the transaction
log will fill up and eventually you won't be able to use the database.

As for Item 1, I believe that you will need to have code in the Access front
ends (each user should have a copy of the front end) that will refresh the
linked tables. As far as I know, Access will not detect the change you have
made on the SQL server.

 

[Guest]

I waited until 9:00pm when noone would be using it.
I created my values in SQL table no problem.
Linked the tables, recreated the mde, and everything was groovy...
From now on I'm just not going to make any SQL db changes during working
hours..

Thanks

Ignore the post from David Pawloski. It is spam.

You should probably post the problem you are having with changing a field
type in one of the MS SQL groups.

The errors you are getting indicate to me that you don't have a backup set
for your database on the MS SQL database server. That means the transaction
log will fill up and eventually you won't be able to use the database.

As for Item 1, I believe that you will need to have code in the Access front
ends (each user should have a copy of the front end) that will refresh the
linked tables. As far as I know, Access will not detect the change you have
made on the SQL server.

I have two questions about my Access 2000 db and the tables are linked to
an
SQL db.
1. Can I add a field to the SQL table then update the linked tables while
other people have it open with MS Runtime.
2. I tried to change the data type in the SLQ table and I get this error:

'tblTrackingData' table
- Unable to create index 'PK_tblTrackingData_1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file
for
database 'AGS_PROD' is full. Back up the transaction log for the database
to
free up some log space.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create
constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table
'tblTrackingData' has been created but its maximum row size (24304)
exceeds
the maximum number of bytes per row (8060). INSERT or UPDATE of a row in
this
table will fail if the resulting row length exceeds 8060 bytes.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.