Error Message - Beginner's question

[BobC]

I am trying to get started with an Access project and want to import my
files from Paradox databases.
I am getting an error message: "Access was not able to perform this
operation because the project is not connected to a SQL Server database."

Can anyone help get me started here?

Bob

 

[Howard Brody]

It looks like you started an Access Project when you
wanted an Access Database.

In a Database, you can import data from all sorts of other
applications - including Paradox.

An Access Project is a front end for a SQL Server database.

I'd start a new Database. You should be able to import
your Paradox tables as well as any objects your created in
the Project.

Hope this helps!

Howard Brody

 

[jmonty]

One possibility is that your Paradox DB(s) may reside on a
server and you dont have the correct type of ODBC-DSN
(Open Database Connectivity - Data Source Name) created.
There may or may not be several issues depending on the
location of the Paradox DB, ODBC, etc., etc.
Without knowing the exact location of your Dbs, your
Servers, or how your ODBC DSN was setup, it's hard to be
more specific.
With that being said:
Although this may not be the most efficient way, this
should work and makes things simpler for you. Basically
break it down to a simple common denominator for the two
applications. They both can import and export text files.
Open your Paradox DB and export the tables as Text; Either
Tab delimited, or CSV (Comma Separated Values) files seem
to work best. Then one by one import them into your new
Access DB(s).

It's just one suggestion.

 

[BobC]

You were correct! THANKS!

It looks like you started an Access Project when you
wanted an Access Database.

In a Database, you can import data from all sorts of other
applications - including Paradox.

An Access Project is a front end for a SQL Server database.

I'd start a new Database. You should be able to import
your Paradox tables as well as any objects your created in
the Project.

Hope this helps!

Howard Brody



want to import my


perform this


Server database."