[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Access 2003 Forms and Reports read data from SQL Server 2008

How I can do Access 2003 Forms and Reports read data from SQL Server 2008 Express Edition ? This Forms and Reports reading data from Access 2003 therefore any way to change the source of data without big changes or modify.
0
egovernment
Asked:
egovernment
  • 5
  • 4
1 Solution
 
peter57rCommented:
You can use the built-in Upsizing wizard tool to transfer the data into SQL Server.  Alternatively you can use SQL Server DTS feature to transfer the data.
It is likely that you will have to make changes to your forms  in order to use the data.

Here is a good article- there are others by the same author at the same site..
http://www.databasejournal.com/features/msaccess/article.php/3697256
0
 
egovernmentAuthor Commented:
Hi Mr. peter57r

I'm already migration the data from Access to SQL Server but I need to connect Access Forms/Reports to SQL Server on other meaning the Access Forms and Reports read the data directly from SQL Server.Express Edition
0
 
peter57rCommented:
Are you using a mdb or an adp front-end?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
peter57rCommented:
Assuming you are using an mdb then you need to link the tables to the Access front-end.

You will need to create a dsn if you don't already have one.

Use File>GetExternalData>Link Tables and choose the ODBC option.
If you haven't got a dsn you can create one at this point.

Once you have a dsn then you can link the tables.
0
 
egovernmentAuthor Commented:
Hi peter57r

I'm using mdb as front-end

But !!!

I'm using ODBC to create a link to the SQL Server tables.

But !!!

I can't add new or delete records from the table.

Can you solve this problem or tell me another solution.
0
 
peter57rCommented:
Are you getting any error messages omessages on the status bar?

DO your SQL Server tables have a primary key defined?

0
 
egovernmentAuthor Commented:
I've requested that this question be deleted for the following reason:

No correct answer
0
 
egovernmentAuthor Commented:
The correct answer using classic ADO
0
 
egovernmentAuthor Commented:
This is correct answer
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now