Tyt nakopilos' za noch' eche para gemmoroev - speshy podelitstya:
vo pervyx , skazhy srazy, chto server y hostinga, a y menya prava dostypa tol'ko na mou database.
tak vot, kogda ya stal kachat' svou glavnyu (t.e. samyu bol'shyu tablitsy) iz MS Access v SQL
to cherez pol chasa t.e. kogda vce perekachalos' - to mne vidali soobshenie:
'camps' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'camps' is full. Back up the transaction log for the database to free up some log space.

pri etom account mne sozdali tol'ko vchera, i nikakogo loga tam byt' ne dolzhno.
ta-zhe oshibka voznikla iz-pod SQL server Enterpr. Manager.
koroche ya cmog skachat' tol'ko razbiv svou tablitsy na tri files , sozdav tri sql tablitsy i potom ob'edenil ix v odny, ( po idee transaction log dolzhen-to byt' eche bol'she ot etogo)

Nikakix optsyi po steraniu ili disable transaction log ya ne nashel, a mozhet oni mne ne dostypny.
edinstvennoe chto ya nashel eto "truncate Log" - neznau yzh tozhe eto samoe ili net no ono ne pomoglo.
vo vtoryx - Identity field - pochemy-to samo iz Autonumbera ne polychaetsta. i update ya ego tozhe ne mogy - iz za etogo gemmora s log file for database 'camps' is full.

ya pytalsya cherez SQL Query Analyzer sdelat' chto-to tipa
Alter table camps alter column [ID] [int] not Null Identity (1,1)
on vce vremya govorit Error near IDentity
tazhe oshibka na
Alter table camps Add column [ID2] [int] not Null Identity (1,1)

polychaetsya opyat' nado razbit' table na kyski , v pervom kyske sdelat' ID Identity i potom ostal'nye insert into ?


samoe obidnoe MS Access database zanimala 12 MB a Database Usage na SQL Yzhe 33 mb (pochemy?)
( a package my kypili na 35 mb) eto polychaetsya s ytra users nachnyt ee uzat' i vce ryxnet ;(

po etomy please - skazhite - kak mozhno sdelat' chto-to tipa " database compact & repare" s ne "su" pravami
i kak mozhno , esli mozhno , disable transaction log.

i poslednee, vot eto perestalo rabotat':

For each f in rst.Fields
if CBool(f.Attributes And adFldUpdatable) then
znachit eto normal'noe pole
else
identity i prochee, t.e. izmenyat' ego nel'zya.
end if

kakoi bit ( esli on est') v SQL yavlyaetsya ekvivalentom
Const adFldUpdatable = &H00000004 ???

Spasibo Bcem

DRY_GIN

P.S.
Tem y kogo xvatilo sil dochitat' do kontsa:
ya popytaus' tipa tolknyt' mysl' :
Ochen' mnogie SQL programmery zabyvaut pro ' symbol kogda delaut raznye search tipa
Select companyname, phonenumber from copmanyes where company like '%slovo_kotoroe_prishlo_iz_web_formy%'
eto ochen' opasno t.k.
luboi chelovek mozhet vmecto ozhidaemogo "cool company " v slovo_kotoroe_prishlo_iz_web_formy
napisat' chto-to podobnoe:
a' or 1=1) Union All select Table_Name as companyname chto-nit'_eche as phonenumber from table_schema where 'a'='a
vobshem ya syntax ne pomnu - no ideya ponyatna.
koroche nado vcegda, po krainei mere picat' chto-to tipa
like '%replace(slovo_kotoroe_prishlo_iz_web_formy,"'","''")%'
togda vce bydet nishtyak

Ydachi