Ms access

Basically I am a Oracle guy. Now I am developping some form in SQL server. I wana use SQL DB as back end and access as front end. I wanna all the tables in SQL server not as the Access DB. Is it possible.
I do not have knowledge of VB or VB script
What should I do? Please helpIn Access, select File, New, from the menu and choose to create a Project with either a new or existing database. A wizard will guide you through establishing a connetion with your SQL database, and you can even perform some administrative functions from Access ala Enterprise Manager. This means you will need to be carefull that you don't unintentionally alter your SQL database, and that you will need to lock down your final Access file so that users don't mess with your database.
The Access file will have a .adp extenstion (Access Data Project).|||[thanks mate it works|||No worries. G'day!
;)

Moving SQL Express data to SQL Server 2005 Dev?

Hi gang,
Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
guy who's been tasked with moving an web app developed with SQL
Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
having literally NO working experience with the Microsoft products, am
wondering how one would migrate data from SQL Express to SQL Server
proper...
Any help or advice in this matter is most appreciated, I've trolled
this group but found no concrete info. Reading the documentation is
says it can be done at time of install, but, given my apprehension of
MS products reliability, is this a safe way to move a mission critical
DB?
Thanks a million,
Cheers
- Randall"MSSQL-n00b" <spliffhuxtable@.gmail.com> wrote in message
news:1174576289.977944.137500@.b75g2000hsg.googlegroups.com...
> Hi gang,
> Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
> guy who's been tasked with moving an web app developed with SQL
> Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
> having literally NO working experience with the Microsoft products, am
> wondering how one would migrate data from SQL Express to SQL Server
> proper...
> Any help or advice in this matter is most appreciated, I've trolled
> this group but found no concrete info. Reading the documentation is
> says it can be done at time of install, but, given my apprehension of
> MS products reliability, is this a safe way to move a mission critical
> DB?
> Thanks a million,
>
SQL Server Express uses the same engine and has the same file format as the
other editions of SQL Server. So you can take a backup of the database from
Express and restore it on another edition, you can detach the database and
attach it on another edition, or you can upgrade the Express edition to a
higher edition.
David