Copying Access Projects and the SQL Database

B

Beringer

Hello,

I want to copy my Access project and the SQL Database it references to
another PC.

I thought it would be as simple as using the Copy Database option under
Database Utilities.
However, when I do this I get messages saying there are 'x' connections and
they need to be closed first; I click OK and then get a message saying only
"user processes can be closed" and the process stops.

What is the proper way to get a copy of an Acess project and the database to
another PC with its own SQL server?

Thanks,
Eric
 
B

Beringer

OK I now know what my problem is. Out of ignorance, I used the master db
for my data.
Is there a way to get the data out of master and into another database? I
suppose I could create a new one and simply import data into it from master.
But is tha the only way?

Eric
 
A

Arvin Meyer

Beringer said:
OK I now know what my problem is. Out of ignorance, I used the master db
for my data.
Is there a way to get the data out of master and into another database? I
suppose I could create a new one and simply import data into it from master.
But is tha the only way?
Click to expand...

Probably the best way. It offers the safest way to get the data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top