Results 1 to 2 of 2
  1. #1
    plengeb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    20

    Copying Objects to a new database

    I am running a program in Access 2016. It creates a new database and copies objects into the new database.

    When it runs this command: DoCmd.CopyObject sampledbfile, , acTable, "tblk_AuditTypes"
    Access displays Run-time error 3049. "Cannot open database 'tblk_AuditTypes'. It may not be a database
    that your application recognizes, or the file may be corrupt."

    It is a small table that I can open the table manually. It has only three entries. The new database gets corrupt, which I think causes the error.

    I have not had the issue in previous versions of Access. Does anyone know why this is happening?

    Thanks for any help you can provide.

    Bill

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    did you give the full path to the target db? (if other side)
    is "tblk_AuditTypes" spelled correctly ("tbl_AuditTypes"?)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Copying VBA from one Database to another
    By John53T in forum Programming
    Replies: 5
    Last Post: 04-23-2017, 08:24 PM
  2. Copying table data to different database
    By m450n86 in forum Programming
    Replies: 1
    Last Post: 04-11-2017, 01:46 AM
  3. Replies: 9
    Last Post: 11-13-2016, 06:55 PM
  4. Replies: 43
    Last Post: 03-27-2014, 01:51 AM
  5. Keep From Copying Database
    By jmyersnc in forum Programming
    Replies: 2
    Last Post: 02-07-2010, 07:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums