cant copy a database?

  • Thread starter Thread starter lofty
  • Start date Start date
L

lofty

I want to copy a data base.
I have an access project which is connected to an 'all
departments' db.
The boss wants the cakemaking sections' part of the
intranet up and running.
I want to split out the cakemakers objects from the main
db, change the dsn in my asp and then continue trialing
the rest of the departments db objects and asp.This way
the cakemakers data entry can begin and be left to
flourish.
You see i do most of my work (and learning) in the wee
small hours at home. I want to make a copy of the 'all
departments' db, then get rid of the stuff that isnt to
do with cakemaking and call this db 'cakemaking'.But at
every twist and turn, access will not let me copy,restore
or transfer the main db.
In the db utilities menu in access, when i try to
transfer the db i get the error:
"invalid object name 'dbo.WSCaplSWBase'."
When i try to copy the db i get the error:
"Cannot use empty object or column names.
use single spaces if necessary."
I dont get any errors when i run the objects in the db, i
only get them while im trying to copy or transfer.
The access messages are really annoying because they
assume you are interned at microsoft or dating mr gates
to be able to understand them (would he understand them?-
my boss would'nt).
getting vvvvery frustrated wasting time on this simple
desire to just copy my iddy biddy db.
 
Lofty,

Is the "All Departments" DB in Access or SQL Server? If it's in Access (not
linked/Global tables, but actually in Access), you should be able to open an
blank Access database, right-click in the empty tables field, and choose
"Import", providing you have Admin access to the objects desired. Then,
simply find your database, and import only the required objects.

If it's in SQL Server, I'm not sure if there's a way to "downsize" to MS
Access. Maybe someone more knowledgeable than I could address this, if it's
your situation.

Good luck,
-Anthony
 
Assuming you have and ADP connected to SQL server.
Open a new mdb file.
then import from the ADP.
of course if you have a SQL server then the best is to use Stored procedures
to do the separation.
You can also open a second SQL Database and reference table in the.
You can even do this with two SQL servers as long as they can connect. It
does create a lot of network traffic, though.
 
lofty said:
I want to copy a data base.
I have an access project which is connected to an 'all
departments' db.
The boss wants the cakemaking sections' part of the
intranet up and running.
I want to split out the cakemakers objects from the main
db, change the dsn in my asp and then continue trialing
the rest of the departments db objects and asp.This way
the cakemakers data entry can begin and be left to
flourish.
You see i do most of my work (and learning) in the wee
small hours at home. I want to make a copy of the 'all
departments' db, then get rid of the stuff that isnt to
do with cakemaking and call this db 'cakemaking'.But at
every twist and turn, access will not let me copy,restore
or transfer the main db.
In the db utilities menu in access, when i try to
transfer the db i get the error:
"invalid object name 'dbo.WSCaplSWBase'."
When i try to copy the db i get the error:
"Cannot use empty object or column names.
use single spaces if necessary."
I dont get any errors when i run the objects in the db, i
only get them while im trying to copy or transfer.
The access messages are really annoying because they
assume you are interned at microsoft or dating mr gates
to be able to understand them (would he understand them?-
my boss would'nt).
getting vvvvery frustrated wasting time on this simple
desire to just copy my iddy biddy db.

Access (97 anyway) doesn't support the "dbo.WSCaplSWBase" syntax. Replace it
with "dbo_WSCaplSWBase" if you are using linked tables from Access. A better
method if you are trying to copy part of an Access db to SQL server, use
DTS. It allows you to select the source and destination as *any* database
with an installed ODBC driver.
 
lofty said:
I want to copy a data base.
I have an access project which is connected to an 'all
departments' db.
The boss wants the cakemaking sections' part of the
intranet up and running.
I want to split out the cakemakers objects from the main
db, change the dsn in my asp and then continue trialing
the rest of the departments db objects and asp.This way
the cakemakers data entry can begin and be left to
flourish.
You see i do most of my work (and learning) in the wee
small hours at home. I want to make a copy of the 'all
departments' db, then get rid of the stuff that isnt to
do with cakemaking and call this db 'cakemaking'.But at
every twist and turn, access will not let me copy,restore
or transfer the main db.
In the db utilities menu in access, when i try to
transfer the db i get the error:
"invalid object name 'dbo.WSCaplSWBase'."
When i try to copy the db i get the error:
"Cannot use empty object or column names.
use single spaces if necessary."
I dont get any errors when i run the objects in the db, i
only get them while im trying to copy or transfer.
The access messages are really annoying because they
assume you are interned at microsoft or dating mr gates
to be able to understand them (would he understand them?-
my boss would'nt).
getting vvvvery frustrated wasting time on this simple
desire to just copy my iddy biddy db.
 
Back
Top