Split Database (1 Viewer)

[vagelisr]

Hi to all

I have an access 2003 database where the tables is in mySql and i have import the tables thru ODBC

Is there any way to split the database?

(When i'm try to split my database they said that there is no table in this database)

Thanks

 

[Mihail]

Maybe, if you clarify why you wish to split the database maybe we'll have more ideas.
For now, you can't split because you have nothing to split.

 

[vagelisr]

First of all thanks for the answer.

The reason is because we will used the same database more than 1 person.
I want to check if it is better than change it to MDE. (If a change the database in MDE in the locked record take much longer than usually)

 

[CJ_London]

Have you actually imported the data or are you simply linked to it?

 

[vagelisr]

Can you please explain this to me a little more because i do not understand you

Thank you.

 

[CJ_London]

you say you have imported the data - which I interpret as having copied the data into your db.

But you also say when you try to split the db it says there is no table - which implies that your table is linked (via odbc to the mySQL db)

If your data is linked, then to all intents and purposes, your db is already split.

 

[Mihail]

@CJ, this quotes are from the first post.

When i'm try to split my database they said that there is no table in this database

From that I understand that vagelisr use a FE with linked tables.
I post that only because he (vagelisr) don't understand your question.

 

[vagelisr]

First of all thank you all for your time

absolutely correct Mihail.
Yes CJ London the tables is in MySql and in Access is only the links.

 

[Mihail]

Ups. No. Can't be linked tables in both.
Only in the FEs (Access) you have linked tables.
The BE contain really (physical) tables.

FE = Front End database (the interface)
BE = Back End database (contain, or should contain, only the tables)

 

[vagelisr]

I have already split my database and i am asking for splitting

Anyway thank you all again.

 

[Mihail]

I think that is some misunderstanding here.
Usually, to split a database means what I say (post #9): to create 2 parts FE and BE.
Then the FE can be multiplied either using Save As, either with copy/Paste under Windows.

What mean "to split" for you ? What you wish to achieve ?