Database Copy Oddity

Sep 15, 2006

Alright...Our database was benchmarked by several other units. They're completely separate, i.e. independant data collection, no shared networks, different bosses.

At any rate, I made some changes to the db and created a "utility update (http://www.access-programmers.co.uk/forums/showthread.php?t=114008)" db for these other units to use to automatically get these updates. Before sending all of this out, I received copies of these other databases to make sure that everything works properly.

Well, everything works fine except for one db. I thought originally that they must've changed something in the db, so I made a copy of ours and imported their data and got the same error as in theirs. So...obviously, I thought there must be some problem in their data. I ran through it and double-checked the verification VBA in the form used to enter the data and there's no noticeable difference in the data and the VBA/form are identical.

This might tie into my previous post (http://www.access-programmers.co.uk/forums/showthread.php?t=114516) because there's something goofy in Access that I can't quite pin-point. As far as I know, there's no difference between any of the databases except for the data itself. Can the data be corrupted if it looks normal in the table? Would corrupt data cause an error in a query/report? (I've never run into corruption in a db before.)

Sometimes I don't like Access so much.:p

View Replies


ADVERTISEMENT

Database Copy

Jul 23, 2004

I need a clean copy of my database that includes everything except the data. I want to keep the keys and relationships etc. How do I do this? I am using Access 2003 Projects and SQL Server.

View 3 Replies View Related

Copy / Duplicate Database

Mar 11, 2015

I am new at Access. I have an excisting database but i would look to copy/duplicate it from on computer to another. Because i would like to start experimenting in the excisting database, but without changing things in the real one. How would you duplicate it, because if i just 'copy' it. I have to change some pathways, but i don't know how.

View 7 Replies View Related

Copy Query, Report, Etc. To Another Database

Aug 4, 2005

Is is possible to copy queries, reports, modules, etc. from one database to another, and if so, how? I have some queries and reports in an inventory database I'd like to copy and use in another database without having to set them up or re-code them again.

Thanks,
Rod

View 2 Replies View Related

Access Creating A Copy Of The Database

Dec 7, 2007

I have MSAccess 2003 running on WindowsXP. I have multiple users sharing a single database. When more than one user opens the same database, a copy of the database is being created?? I don't know if this is a standard trait of Acccess or something else. Any explinations would be helpfull.

Thanks
Bob

View 2 Replies View Related

General :: Copy Database With No Records

Aug 6, 2013

I'd like to be able to show recruiters the database as an example of my work (to get an interview, etc.). Of course, I can't just show them a copy of the database with all of the private information on it, so I'd like to be able to show them a copy of the database with no records. Is there a way to export/copy it so I can do this in Access 2007?

View 4 Replies View Related

Mail Merge Opening Another Copy Of Database

Dec 11, 2006

Hey Guys,

Hope you can help as this one's got me stumped!

I'm using Access 2000 and run a mailmerge function via a button on a form. (It opens Word, which then uses a query in the database to refer to and then 'automerges' into a new Word document).

It used to work absolutely fine but now it opens Word and then opens another copy of the database (so I have 2 running) and all hell breaks loose.

Any ideas what I can do to stop this? Has anyone come across this before?

Any help/suggestions would be gratefully recieved as I feel like I'm in a 'needle in a haystack of needles' situation here.

Cheers,

Rusty
:D

View 2 Replies View Related

Queries :: Creating Dynamic Copy Of Database

Jan 20, 2015

I have a relatively small data base.

There are a number of what I call reference tables. These are fairly static and in the main will not change.

There are a further half a dozen tables all linked together.

The system basically takes an enquiry which may lead to a repair taking place. The repair will have a number of jobs and each job may have parts replaced.

What I want to do is have an identical database which to begin with will have exact copies of all the reference tables. The remaining half a dozen tables initially will be empty but grow with time.

The user wants to be able to copy the completed repairs he selects over to the 2nd database (which is initially empty). As weeks go by he wants to select further completed jobs that have not already been copied over to the 2nd database. The 2nd database will be updated so I can't just copy over all completed repairs each time.

I had envisage him doing this by using a front end to the 2 databases and firstly selecting which of the completed jobs which haven't been copied over. This is a fairly straight forward query that will update a field on the repair table.

Once he has done this I was thinking that I could run a query that would pull all the rows from the 6 tables from database 1 and update the corresponding tables/rows on the 2nd database.

I don't actually know how to approach that. The process needs to be simple for the user. ie 1. select repairs to copy over 2. run something to copy them over.

View 11 Replies View Related

General :: Copy Saved Imports From One Database To Another

Apr 2, 2013

I pasted the tables, modules, macros, etc. from one database to another and the only thing left is the Saved Import. How can I get that into another database? It is quite a large import, otherwise i would just recreate it.

View 3 Replies View Related

General :: Copy New MDB File Over Existing Database

Feb 28, 2014

How can I overwrite the existing Access database with another Access database without the need for the end user to get involved in the process.

I want the code to copy a new mdb file over the database I am using (!) and then automatically start the new mdb file...

View 9 Replies View Related

Modules & VBA :: Copy Table To A Password Protected Database

Dec 11, 2013

I'm using the DoCmd.CopyObject method to copy a table from my front end db to my back end. My back end db is password protected and it keeps prompting me for the password. Can I somehow send the password in code so that the user is not prompted?

View 8 Replies View Related

Modules & VBA :: Backup / Zip And Email Copy Of Database Programmatically

Sep 11, 2013

I need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....

View 4 Replies View Related

Forms :: Button To Make A Copy Of Entire Database

May 28, 2015

Is there any way i can a button on a form which will make a copy of my entire database?

View 1 Replies View Related

General :: Access Automatically Saving A Copy Of The Database

Nov 6, 2013

I have created an MS Access 2007 for a user. When the user uses the database, it automatically saves a copy of the database. Why is this happening? I did create for the database to compact/repair each time to user closes the database. ... However, when I open/close the database, there are not new copies of the database.

View 1 Replies View Related

Creating A Database To Store Training Records That Saves A Scanned Copy

Jun 8, 2015

I'm a access novice who is looking to create a database to store training records for permanent and agency staff, and contractors staff. I need the database to be able to produce reports on how many courses were trained over each month, and the total duration of the course completed (in hours).

View 2 Replies View Related

General :: Access 2010 Split Database Hyperlinks Not Working / When Copy Of Front End Moved

Jul 14, 2014

I have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end?

View 3 Replies View Related

Modules & VBA :: Save As Dialog Box - Allow User To Save Copy Of Current Database At Desired Location

Feb 12, 2014

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

View 2 Replies View Related

Copy Button In A Form To Copy Fields To Other Fields In The Same Record

Sep 23, 2005

Hi there,

Can someone help me on this issue?

I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment.

I want to copy 4 fields to 4 other fields within the same Record.

This the current code I use for the Copy-button:

---

Private Sub cmdCopyFields_Click()

Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant


v1 = Me!Field_a.Value
v2 = Me!Field_b.Value
v3 = Me!Field_c.Value
v4 = Me!Field_d.Value


RunCommand acCmdRecordsGoToNew

Me!Field_e = v1
Me!Field_f = v2
Me!Field_g = v3
Me!Field_h = v4


End Sub


---

The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.

-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?

-Are there other options to achieve te same?

I have put in a attachment, to give you guys a visual example of what I mean.



Thanks in advance,

Quinten

View 3 Replies View Related

General :: Make A Copy Of BE File Rather Than To Make A Copy Via Code

Nov 26, 2012

Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.

View 4 Replies View Related

Copy A Mdb To Usb

Oct 16, 2006

I have created a database with a number of backends. Users have the database on their home PC. I want a simple visual way of copying one of the backends to a usb drive and then having the ability to transfer the mdb from the usb to their work machine.

View 1 Replies View Related

Copy Mdb

Jun 14, 2007

How can I copy an existing database complete with tables, queries, forms and reports but without the data to start a new database based on the original

View 1 Replies View Related

Copy DB

Jan 14, 2005

hoi,

I'm using 2 db one local (LocalDb) and one on a server (serverDb). If the localDB don't have a connection with the server it use a copy of serverDB that local is.
Now must it be possible by clicking a button (in localDB) to copy the database serverDB to its local location.

Is this possible? So yes how?

thanks

koen

View 6 Replies View Related

How To Copy A Form?

Apr 19, 2006

This is actually a rephrase of the scenario I posted in the other thread yesterday.

I have a form, titled "Danish", now i wan to make a copy of it, i.e, its textboxes, buttons and save the new form as "English". How can i perform ALL of the above in coding?

Thks..

FT :)

View 4 Replies View Related

Copy Function

Oct 28, 2005

Hey what does anyone know anything about a copy function? I think it is vb code but I am not sure. what i am trying to do is to. create a id number using the last 2 digits of the year from the date, and adding a "-" and adding the last record number plus 1... SO I think I have the date things but I am not sure how to do the last record id number plus 1?? I was told it could be done with a copy, I am not sure. what ideas do you have about it??

thanks

View 1 Replies View Related

Copy And Paste

Apr 5, 2006

Hi all,
I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same.
name *****
Date of birth **/*****
consultant ******
ward BLA ******

Is it possible to copy and paste all the information in one go from the email and paste everything into its correct places on a form with one action? This would save alot of time & effort on the users part.

Many Thanks

Samzie

View 14 Replies View Related

Copy Report

Dec 8, 2006

hi

i have a database x (x.mdb) and y (y.mdb)
i would like to copy some report from x to y

any idea?

thank

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved