splitting database

  • Thread starter Godzom (UAG reprezent!)
  • Start date
G

Godzom (UAG reprezent!)

Hi , I'm using MS-ACCESS 2000 and I'm trying to split my database (120Mo)
because it would be to heavy for the network to share this big file.
I tried the classic method (with the menu) but I always get this error:
"Impossible to assign this field with this expression of validation"
(Note that it's a translation of the message because I'm not using an
English version of ACCESS)
(I've already been looking for answers on many forums but no answer)

P.S. I apologize for my English but this is not my native language, thanks
for your understanding
 
T

Tom

Try starting a new blank database and import all the tables from the
original file. Then go back to the original file and delete the tables
there. Finally, link the tables to the newly created back end.

"Godzom (UAG reprezent!)" <Godzom (UAG
reprezent!)@discussions.microsoft.com> wrote in message
news:[email protected]...
 
G

Godzom (UAG Reprezent!)

That's exactly what I'm trying to do, but there's a new problem with the
relations. All of them disappeared in the new database and I cannot import
the old MSysRelationships table because ACCESS tells me that this table is
locked or use by another user/process.
What can I do?
 
T

Tom

Everything are as they should be. Relations are not imported. Import user
tables and set relations again.

"Godzom (UAG Reprezent!)" <Godzom (UAG
Reprezent!)@discussions.microsoft.com> wrote in message
 
D

Douglas J Steele

You shouldn't be importing ANY of the system tables (the MSys* tables)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Godzom (UAG Reprezent!)" <Godzom (UAG
Reprezent!)@discussions.microsoft.com> wrote in message
 
Top