Solved

to convert to Access 2003 file format or not to convert!

Posted on 2008-10-02
2
199 Views
Last Modified: 2013-11-29
hello,
I have a DB i just created and it says in brackets that it is an Access 2000 file format.

my DB works fine and will probly be used to eventually convert into an SQL DB so should i convert my access 2000 file format DB to 2003 file format or will i be able to do that later when/if i convert it to an SQL DB?
0
Comment
Question by:HudsonMarine
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 500 total points
ID: 22625433
If you convert it to a SQL db then there would be no need to convert to Access 2003 format, would there? As long as SQL Server Migration Assistant works with it there shouldn't be anything to worry about, and SSMA will work with format from 97 to 2007.

Jim
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22731396
Thanks for the points and grade.

Jim
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now