Do I need to set..

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

ChoonBoy

I am exploring ADP, please bare with me if my questions appear to be too
simple or off-line.

I have converted my Access03 to an ADP project and another similar copy to
SQL tables only (just to see the different).

Questions:
1) For mdb I need to manually compact or do this automatically on close. I
understand that for SQLexpress, I do not need to do this. Any setting
required.
2) For mdb I can easily copy the backend to the assigned directory. How do I
do this for sqlexpress if my database name is ProjectA.

Thanks
 
ChoonBoy said:
I am exploring ADP, please bare with me if my questions appear to be too
simple or off-line.

I have converted my Access03 to an ADP project and another similar copy to
SQL tables only (just to see the different).

Questions:
1) For mdb I need to manually compact or do this automatically on close. I
understand that for SQLexpress, I do not need to do this. Any setting
required.
Click to expand...

The SQL-Express can be shrinked; however, the advantage of doing so are much
less advantageous than with an Access' MDB file.

For the ADP project, you must still shrink it at regular interval but less
often than with a MDB database file.
2) For mdb I can easily copy the backend to the assigned directory. How do
I
do this for sqlexpress if my database name is ProjectA.
Click to expand...

You do this from the SSMS-Express Studio: you first detach the database, you
move the two associated files (MDF et LDF) and reattach it after that.
 
Thanks Sylvain for the reply, but how do I detach and reattach it.

Can I just copy the mdf and ldf, than create a directory/folder and place
the mdf and ldf in it.

After the above, open my front end Access03 and link it to the mdf / ldf (in
the same way when linking MDB) ? I am sure it is not as simple as this.

This is really difficult.

Thanks
 
ChoonBoy said:
Thanks Sylvain for the reply, but how do I detach and reattach it.
Click to expand...

Right-click on the database | Tasks | Detach...

To Reattach, right-click on the Databases node and choose Reattach...
Can I just copy the mdf and ldf, than create a directory/folder and place
the mdf and ldf in it.
Click to expand...

Why would you want to do that? Your problem if that you are trying to see
the databases on SQL-Server in the same way that you are seeing your MDB
database files.
After the above, open my front end Access03 and link it to the mdf / ldf
(in
the same way when linking MDB) ? I am sure it is not as simple as this.
Click to expand...

See above. While there is an option in the connection string for
SQL-Express to automatically attach the mdf / ldf files as a new database,
this option is beeing deprecated and give you no advantage excerpt a much
reduced performance. With SQL-Server, you talk to a server; you don't talk
to individual database files.
 
Thanks Sylvian for your reply.

I hope I will not be testing your patients with my next question. Also
appreciate if you or any other readers can recommand me a good book in simple
english on the subject below.

What I really want to do is.

1) To distribute my completed ADP project to another PC.
a) front end (Access 2003)
b) back end (SqlExpress2005)

For MDB it is very easy, but ADP, what should I copy to my Pen (flash)
drive, plug into the USB of another PC and what to do to make it run in the
target PC.

Thanks in advance
 
For ADP and MDB files, your Pen flash drive will work is there is already a
copy of Access installed on the target machine. In the same way, for ADP, a
version of SQL-Server must exist and you must attach the files as a database
before using them.

You can copy the installation file for SQL-Express 2005 if you want to but
this would be a bad practice because maybe there are already an instance of
SQL-Server (Express or Not, 2005 or 2008 or other) running on this machine
that could be used to attache the database files.

As I said earlier, you don't work with a SQL-Server database the same way as
with an MDB database file. You can start trying to install an instance of
SQL-Express everywhere but I don't think that this will be seen as a good
practice.
 
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
 
Back
Top