473,385 Members | 1,873 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

I've done something and now nothing works HELP

489 256MB
I don't know what happened but let me see if I can explain.
I have a skydrive, I copied my access program and database to the skydrive. I was doing some work on the program and went to Make accde it created the accde program but when I run it the basic program comes up but there is no database connected. If I go back and open the accdb everything comes up fine. I've look at the link master and the database show up there like it's should. I've even relinked the database and that doesn't help with I run the make accde and run it.
I don't know if the skydrive has anything to do with this, but that's the only thing I can think of.
If anybody has any ideas I sure could use them.
Thanks
Mar 5 '13 #1
6 1414
zmbd
5,501 Expert Mod 4TB
I'd bet that it is because of the security issues.

Try the following:
Move your ACCDE to a folder on your local drive.
Move the back end files to that same folder on the local drive.
Now start your ACCDE file and re-link the tables to the local copy.
Tell us what happens.
Mar 6 '13 #2
CD Tom
489 256MB
The problem is that nothing works in the accde program I have a relink module in the program but when I bring it up and try to run it nothing happens. Is there another way to relink from the ACCDE program? My program has a feature that if it can't find the database it will ask for the location and then do a relink. When I rename the back end file to something else and start the program it doesn't even know the file is missing. I spent most of the day yesterday trying different things and found that if I start with a blank database and using the External Data and import all the data from the file ACCDB file that I was having problems with I was able to get the problem solved. I still have the problem ACCDB file so I can still try different things.
Thanks
Mar 6 '13 #3
zmbd
5,501 Expert Mod 4TB
1) Please do as I have asked. It is very importaint to know if the file is being blocked due to the inbuilt security or there is some other issue at work here.

2) To determine if there is an issue with your program: please go to the following thread: Can I connect my database(...) I have a database in post#7 that you should download and unpack to a LOCAL drive directory. Start the the ACCDE front end and report back any errors.

3) We'll need to see the code behind your relinker before we can help you; however, please read and follow this first: > Before Posting (VBA or SQL) Code

4)
(Post#1)(...) If I go back and open the accdb everything comes up fine. (...)
(Post#3)(...) External Data and import all the data from the file ACCDB file that I was having problems with I was able to get the problem solved. (...)
Here you have me confused.
Are you refering to the same files here?
In Post#1, I thought you were refering to the front end file that you created the ACCDE from; however, now it seems like you have switched up what it you're working on.
Is the new ACCDB on the local drive or the skydrive?
Mar 6 '13 #4
CD Tom
489 256MB
Ok, I moved the ACCDE and the Back end to a new folder when I run the program I get the same thing I don't know how to relink from the ACCDE I don't have any options to relink. Can you explain how I should do this?
Mar 6 '13 #5
zmbd
5,501 Expert Mod 4TB
Hmm, could still be a security thing; however, I doubt it at this point.
Please go ahead and work thru the remaining requests in my last post.
Mar 6 '13 #6
CD Tom
489 256MB
Let me see if I can explain this better. The original program ACCDB connected to the back end works fine I can make modifications and everything looks good. I then make the ACCDE and with I run it the main menu of my database comes up but none of the buttons I have on the main menu do anything, also the main menu comes up larger than the normal one on the screen. I do have a relink in the program but because none of the options I have on the main menu I can't select it.
So what I did was to create a blank database and using the external data on the new database I linked to the original DB and imported all tables forms reports macros and modules into the new DB. I add all the references that the original DB had. I then tested the new DB and it worked fine, so I created the ACCDE from the new DB and when I ran it the program worked as normal.
I hope this explains better what happened and how I corrected the problem.
I tried many different ways until I came up with this one. In the original program before creating the ACCDE I could relink the DB, I tried renaming the DB to something else and then relinking it but when I created the ACCDE and run it I would get the same problem.
Thanks for all your help I've looked and your other posts and will try some of those.
Mar 6 '13 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: AJ | last post by:
Have I just wasted money on buying VS.NET Beta 2? I can run the start page but as soon as I try to load a solution file, I get an error within the Microsoft Development Environment as the Common...
2
by: Adam Short | last post by:
Take a plastic fork and stick it in my eye... In the persuit of gaining knowlwdge I have inadvertantly dropped a right clanger! I have a Windows 2003 IIS Server. All was well and good this...
5
by: Jintty | last post by:
Hi, I'm trying to write a program that will read a txt file, copy it into another text file and display the number of words, lines and paragraphs. I was able to get the copying portion done, but...
2
by: Liza | last post by:
Hi, I've just setup postgreSQL on my Fedora Core1 box. I installed postgresql from rpm files. When I try to connect to the postgresql server in pgmanage, or through an ODBC from other windows...
6
by: comp.lang.php | last post by:
I'm involved in a rather nasty debate involving a strange issue (whereby the exasperated tell me to RTFM even after my having done so), where this is insanely possible: print_r(is_int('1'));...
1
by: lennyw | last post by:
Hi I'm trying to use XSLT to do an xml to xml transformation where the output xml contains summary data on the information in the input xml. I've succesfully done a Muenchian grouping of the...
3
by: Matthew Warren | last post by:
I have the following piece of code, taken from a bigger module, that even as I was writing I _knew_ there were better ways of doing it, using a parser or somesuch at least, but learning how wasn't...
3
by: Johnny J. | last post by:
I wanted to exchange all the ComboBoxes in my project with a special MyComboBox inherited from the Regular combobox but with a little extra code. Because I didn't want to remove all the normal...
0
by: Andy | last post by:
So I need some help with something very basic. I have a repeater and I'm binding it via the DataSourceId property to a DataSourceControl, which is bound to a business object (Rma) I have. The...
1
by: EPierre | last post by:
Please help I have serious problems. 1.-) Although the table looks correct, there is a warning I don't undrestand ("mysql_rows returned an empty result set (i.e. zero_rows)"). 2.-) 'dim' and...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.