convert to SQL?

M

Matt

Hi Folks,
Is there a way to take my Access database and convert it to a SQL one? Thanks!
Matt
 
A

Albert D.Kallal

Matt said:
Hi Folks,
Is there a way to take my Access database and convert it to a SQL one?
Thanks!
Matt
Click to expand...

Not sure what you mean by "sql one". Ms-access is complete based on, and
built around sql. Forms can be based on sql, combo boxes are based on sql,
listboxes are based on sql, reprots are based on sql.

Perhaps you are talking about sql server, or a database "server" product.
You can most certainly move the data from a mdb file to sql server, but
continue to use ms-access as your development tool (after all, Oracle,
sql-server etc do NOT have the ability to build reports, or build forms).
So, you want to keep in mind that ms-access is a developers tool that lets
you *connect* to a database system of your choice. The default engine is
called "JET" and that is a file share system. However, for the last 3
versions of ms-access there has been included a server based 100% compatible
with sql server engine on the office cd also.

You don't mention what database server product you are planning to use with
ms-access, but those that support odbc as a general rule will work with
ms-access.
 
M

Matt

Thanks for the response! What I am doing is using InfoPath and Access
together, but after I develop the InfoPath forms with Access I want to use
SQL Server with the form instead of Access. Is there a way to change over to
SQL Server from Access in this sense? I am using Access 2003 and SQL Server
2000. Thanks again!
 
A

Albert D.Kallal

Matt said:
Thanks for the response! What I am doing is using InfoPath and Access
together, but after I develop the InfoPath forms with Access I want to use
SQL Server with the form instead of Access. Is there a way to change over
to
SQL Server from Access in this sense? I am using Access 2003 and SQL
Server
2000. Thanks again!
Click to expand...

Yes, you can either

1) create a adp project, as this is 100% designed for sql server.

2) if you got a existing mdb application, then you can move the tables
to sql server, and then "link" the tables from the mdb to sql server.
 
C

Cruiser

Albert, Not sure if you will look at this post, but please help if you can.
I am trying to do the same thing as Matt, Move Access tables to SQL Server.
The problem is I am NOT a programmer. When working with Access, I rely on
the wizards and can do a little fixing, but don't know enough about it. You
are suggesting that Matt link the tables from MDB to Access, but I wouldn't
have the first idea how to do it. Could I follow the help screens on SQL
Server? We project that our Access file will grow to exceed the 2GB max for
MSDE, so we need to use SQL 2005 from what I can determine.

Do you even recommend that I attempt it? I know this is an Access forum,
but would you recommend another database with larger storage capabilities, so
I don't have to use SQL server.
 
L

luciane

Cruiser said:
Albert, Not sure if you will look at this post, but please help if you can.
I am trying to do the same thing as Matt, Move Access tables to SQL Server.
The problem is I am NOT a programmer. When working with Access, I rely on
the wizards and can do a little fixing, but don't know enough about it. You
are suggesting that Matt link the tables from MDB to Access, but I wouldn't
have the first idea how to do it. Could I follow the help screens on SQL
Server? We project that our Access file will grow to exceed the 2GB max for
MSDE, so we need to use SQL 2005 from what I can determine.

Do you even recommend that I attempt it? I know this is an Access forum,
but would you recommend another database with larger storage capabilities, so
I don't have to use SQL server.
Click to expand...
 
Top