Access Projects

[GaelicFatboy]

I'm looking at creating a project database for the first time and I'm looking for a little background if anyone can help.

If I install the MSDE on my standalone laptop can I write and develop the database on the laptop without being connected to a server and then transfer the files once I'm happy with the database?

If I'm able to use my laptop do I need to configure a dummy server on it first?

Cheers for your help, I'm new to this side of things.

D

 

[Steven Deetz]

You can install an MSDE server running on your laptop and create a SQL Server database on your laptop. You can use Access 2003 to walk you through the setup of the SQL Server database and the security portion of accessing the database.

Once you are happy with the database you shut down your MSDE server and copy the database MDF files to the network location of your SQL Server and run the Attach program.

You can also copy over your Access Project or Database and reconnect to the new location.

I have used an ADO connection through an Access 2003 Database instead of using an Access Project because there are more tools available. But I also have an Access Project connect to the same database because there are some neat table management features you can use through the Access Project.

SQL Server has a big learning curve and I still feel I am at the bottom of the curve after one intensive project! Good Luck