dBase file

D

Darth

Hi
As with most people who pose questions here, I am new to Access and require
help to set up a new Database.

I currently have a Database running in Approach with 1300+ records. This is
perfectly serviceable but I wish to convert it to Access.

Good News... I have managed to open my data as a db file in Access and can
view it in a Form.

Bad news... I cannot modify the resultant Table and I get the following
Error Message: Table is a linked table with some properties that can't be
modified. Do you still want to open? When I open the table I find that NONE
of the properties can be modified.

Obviously I am missing something very simple... but what??

Thanks
 
T

Tom Lake

Darth said:
Hi
As with most people who pose questions here, I am new to Access and
require
help to set up a new Database.

I currently have a Database running in Approach with 1300+ records. This
is
perfectly serviceable but I wish to convert it to Access.

Good News... I have managed to open my data as a db file in Access and can
view it in a Form.

Bad news... I cannot modify the resultant Table and I get the following
Error Message: Table is a linked table with some properties that can't be
modified. Do you still want to open? When I open the table I find that
NONE
of the properties can be modified.

Obviously I am missing something very simple... but what??
Click to expand...

To modify a linked table, use the application that created it. If you want
to import
the data into Access, you can then modify the table as you wish. Of course,
the Access
table will no longer reflect any changes made to the data by the original
app.

Tom Lake
 
D

Darth

Thanks Tom for your very prompt response

Problem is...

Whilst I was able to convert my original data to a db file from which I was
able to open and read in Access, I am not able to use the Original
Application (Approach) to "unlink" or "modify" it... Do I have to save my
Original Data as something else before opening up in Access?

Is there a "Janet and John" version with pictures?

(Sorry, for those who are not aware, Janet and John Books were used many
years ago in England as first reading books)

Thanks again
 
A

Albert D. Kallal

what is being suggested is that you do a import, and NOT link the data.

Of course, if you do that, then the data is now located in ms-access. this
somewhat obvious "issue" was only being pointed out, since some readers are
wondering why you linked to that data...and did not use the import features
of ms-access.

Since you did not do what most people would do, then one reading this has to
conclude that you STILL NEED and STILL ARE using the old application and its
data.

If you don't need the old data and appcation, then don't link to the data in
that old application, but import the data into ms-access. Doing so will
allow you to modify the data in ms-access, but obviously then those changes
will not be reflected in the old application (which, we right, or wrong
assume you need, or not need to continue using).


Just use filt->get exteranl data. Improt the data...don't link to it....
 
D

Darth

Thank you...

A simple solution but, as with learning to read, not easy unless you know
the basics.

You have saved me days of struggle and I am very grateful.
 
Top