Database Copied

Jun 9, 2006

hi all i have a big prob!

i opened up my database this morning and it has been working fine all day, suddenly where it is located a copy of my database has been worked, and the original when opens shows nothing, anyone knows what happened?thanks

View Replies


ADVERTISEMENT

How To Run Copied Database

Oct 6, 2011

Long time ago some computerdude made a database for my dad so he had a place for his customerinformation. When I open the file on his computer the file sort of "start" or "run" - there appears a little window where you can click buttons like "find customer", "remind me in two days" etc. That's how it always has worked and how it should work.

We have bought a new computer. We want a new database for me, where I can type my customers in the exact same way as in my dads access file. I have managed to import all the tables etc. without any data, BUT

I CAN'T GET THE DATABASE TO "RUN" OR "START" WHEN I OPEN THE ACESSFILE! HOW DO I GET THE LITTLE WINDOW WITH THE BUTTONS TO APPEAR IN THE SAME WAY AS ON MY DADS COMPUTER?

I only get the tables and the kind of "edit mode" when I open the program.I have tried to change the securitysettings, so access dosn't block any macros.

View 5 Replies View Related

Stopping Database Being Copied

Nov 8, 2005

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards :confused:

View 3 Replies View Related

Copied MDW Doesn't Work

Jun 14, 2007

Hi! I'm relatively new to Access (2003) . I had to modify a shared network app so I copied it off and renamed it, made my mods and everything is fine. I then went to another app that connects to the original app to obtain data for display and synchronization, modified the call to open the new app including the new mdw. When it hits the new mdw, it can't open it because it says it's being used exclusively or the workgroup file is missing. It's not being used exclusively and it doesn't appear to be missing. The network path is correct. If I use the mdw from the original source app, it works fine. Please advise! :(

View 1 Replies View Related

Copied Db Won't Allow Edits Or Additions

Jul 2, 2007

I'm an Access idiot - please be kind :o

I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:

Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!

The dang thing persists in allowing everything except edits & additions :confused:

I can't find out how to convert it back from a Master to ... what, a slave? :p
Even so, that wouldn't be the answer coz I'd be back at square1.

I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:

View 1 Replies View Related

Report Info Copied To A Table...

Dec 25, 2005

I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?

Hope you can help!!

View 3 Replies View Related

Report Info Copied To A Table...

Dec 25, 2005

I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?

Hope you can help!!

View 1 Replies View Related

How To Copy A Report And Point It To Its Copied Query

Jul 16, 2015

So I have this killer report that took me hours to set up. I run it daily and it is great.

I now need to filter it slightly for 1 specific user. So what I did was I copied the query and renamed it. I added the filter I needed. But I don't want to have to re-create the report. Even though I know what I need it will take quite a bit of time to recreate it.

Is there a better way? Can I copy the report (using the same query) but add the filter on the report side?

View 4 Replies View Related

One Db Works, A Copied Version Doesn't. Driving Me Nuts.

Nov 13, 2006

hi,

i made an attendance db for work and got it to work. i then copied it and made two more for years 2 and 3. Years 1 and 3 work perefectly but for some reason the year 2 db won't allow me to write the data.

this is driving me nuts as i have already spent a few hours putting the students in and their course selections. i've tried making the forms again and as soon as i use a joint sub form to get the students first name the problem occurs. i've looked at the properties of the forms and they allow edits etc..

if anyone is feeling kind and has a spare moment, could you let me know why it doesn't work.

cheers

View 6 Replies View Related

Forms :: Duplicate Record Button To Allow Records To Be Copied

Feb 12, 2015

I have a form with a duplicate record button to allow records to be copied. I used this code (I think from Allen Browne), but it only copies the last record in the recordset?

If Me.Dirty Then 'Save any changes
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record.
MsgBox "Select a record to duplicate"

[Code] .....

View 2 Replies View Related

Reports :: Union Query - One Page Report Copied 3k Times

Sep 16, 2013

So i have a union query pulling together about 3,000 records from other queries.

I arranged all the counts and data I need to fit onto one page, but the report is copying that page (minus the header) for each record in the union query. I'd much prefer a one page report rather than a 3,000 page report.

Why does it do that? All I want is a one page report, how can I make that happen?

View 3 Replies View Related

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Forms Count Of Other Database Without Opening That Database Physically

Oct 7, 2005

Hello All...

Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..

Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject

Set frm1 = AcProj.AllForms

intCount = frm1.Count

But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..

Thanks in advance..!!

View 4 Replies View Related

Modules & VBA :: Open Database / Run A Query / Close Database

Aug 22, 2014

i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.

View 4 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

General :: Database For Metal Market Prices To Be Used In Another Database

Jun 24, 2015

I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.

There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?

View 14 Replies View Related

Jet Database Engine Error On Non-shared Database

Jul 7, 2005

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

View 3 Replies View Related

Best Way To Import SQL Database To Local Access Database?

Dec 25, 2005

I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.

Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.

View 3 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related

Accessing A Table In Database A From Database B

Aug 29, 2005

Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.

View 2 Replies View Related

Create EXE From Database And Have Several Project Using Same Database

Oct 24, 2013

I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.

the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.

Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?

I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.

Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.

This way we can have several txt file for several project and use always the same exe database.

View 4 Replies View Related

Linking To Another Database From On Database

Nov 20, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch :eek:

View 4 Replies View Related

How Can I Save My Database As A MDE Database.

Oct 2, 2007

The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp

Jabez

View 6 Replies View Related

Launching Another Database From Within A Database?

Dec 21, 2013

I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.

View 3 Replies View Related

Car Database Help!

May 24, 2005

I have a car dealership database and have a servicing section.

I want to create a form to service these vehicles.

The only vehicles which will be displayed on the from are the sold ones (because you cannot service a vehcile which hasnt been sold) which i have a query for.

I also want the form to display the customer who owns the car the service details (eg what they need), the parts availiable and the parts required for the service.

The calculations i need to make in this form are as follows

quantity needed (parts required table) - quantity in stock (purchasing customer parts table)

quantity needed (parts required table) * price (Parts Table) + labour (servicing table) = part/labour costs (servicing table)

http://pic18.picturetrail.com/VOL885/3178839/6480291/97832270.jpg

any suggestions on how to do this would be fantastic

View 2 Replies View Related

I Really Need Help With My Database

Jan 4, 2006

i havent been able to figure out how to get my subform to work properly....
i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 )

it is really important that i figure this out so that i can keep my job..

how else can i obtain help? even if i have to pay for it?

what do you guys suggest?

View 4 Replies View Related







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