Splitting A database

[ghodges]

I have an unusual problem again,

I need to split a database that has cascading tables.

The problem is when i split the database, everything still works except I loose he "+" signs in the beginning of the table

I have tracked that down to the table properties being set to [auto]

my real problem comes when i change these table properties before splitting the data base....whatever changes i type in it, it automatically fills half of the fields in, it ignores and after 10 seconds or so it goes back to [auto]......very strange behaviour

Does anybody have any idea
1) how to do this?
2) why this is happening
3) any idea how i can split the database and still have cascaded tables

The database is in 2000 format, being run on 2003 ( if this makes a difference)
Any Ideas greatefully acceepted and appreciated


ps. I know this data access should be done using forms to access the data,and it is for most users. Some others users, who can be trusted use this feature as it is so quick and easy to use this. it is irresistable to look at high volumes of data

 

[ghodges]

I have solved the problem

I simply upgraded it from access 2000 to access 2003 and the problem went away


obviously an implementation problem in access2000

 

[HiTechCoach]

While it is possible to do, I never do it.

The first his I do it set allt he tables to haev the property set to [None.]

See:
Slow performance on linked tables in Access 2002, in Office Access 2003, and in Office 2007

Hope this help...