Question reguarding Access Project

[Jon123]

I was doing some reading and found some information on using Access Project in office 2007. Can you take an existing 2007 access database and convert it over to access project? Is this really better than converting to SQL? They make it sound easy but I fear weeks of headaches and in the end it would run well or is still to slow.

 

[HiTechCoach]

Is this really better than converting to SQL?

I am not sure what you mean by this. SQL is a query lanaguage. Do you mean to an SQL server? An SQL server is just a back end with no UI. You will still need Access, ASP, VB/VB.net, or some other platform for the front end.

I use an SQL server back end and never ise an ADP. I find that using an MDB or ACCDB works just fine. This also allows me to use the same Access front end with an Access back end (.MDB/.ACCDB) or an SQL Server (MS SQL or mySQL) back end by just relinking the tables.

 

[Jon123]

sorry - So I have a database currently written in access 07. It is split into a front and backend but It can not really be accessed remotely because its very slow running. So my options were or are to upgrade the backend to MSSQL server or maybe upgrade it to Access Project whick I believe uses
an SQL server but this option sounded alittle easier to do. So I was wondering is there an easy way to convert an access dbase to a access project? Will this run or will it be painfully slow?
jon

 

[HiTechCoach]

Ah .... remote Access to the data. That really changes everything.

If it were me I would use a Use Thin Client Technology. I like to use Terminal Services. I find this has the best performance/stability

See:
Using a wan with ms-access? How fast, how far?


Since you database is already split, all you have to do is upsize the back end to an SQL server and relink your tables. Provided your Access tables are properly designed, this is very quick and easy to do.

See:
Migrating to SQL Server
Under "Step 4: Migration" there is a link to the SSMA to upsize your Access databases with a few clicks!

... maybe upgrade it to Access Project whick I believe uses an SQL server ...

There really is not need to do this to if you want to use an SQL server back end. I have ever seen where Microsoft recommend not using the ADP. There are things I need to do that I can't do in a ADP that I can easily do with a MDB/ACCDB.

 

[HiTechCoach]

You may also fidn this helpful:

Beginning SQL Server Development

The development of ADP’s isn't set to advance in future versions of Access but they can still be a useful, expedient and powerful tool for those that choose to use them.
However MDBs (now ACCDBs since Access 2007) still offer almost everything you could need from a data perspective – with the extra flexibility of the local database engine for ad-hoc processing needs.