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:
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.
I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.
Thanks
Shane
I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob
Hi - I have a front end database that is linked to 2 backend databases. I'd like to add code so that after the splashscreen pops up it checks to see if the front end is linked. If not then asks the user to enter the path for the two backend databases. I need your HELP!!1
Bukaw
first time poster, please be kind.
I am currently updating our supply stores database in work. When an item becomes unserviceable we need to attach a form to the item before sending it away. i would like the data entered into the 'unserviceable' table within my database to be transposed onto an excel spreadsheet (see attachment) and then automatically printed out with the data in the relevant boxes. Can anyone tell me how this is done please? My knowledge of access is rather limited and I am teaching myself as I go along.
I have recently updated my version of Access.
Within a tbl i have a series of hyperlinks.
All of these hyperlinks are linked to an object within the database, a macro as an example.
When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?
Hi i am working with a database that contains customer information
and sometimes files and attachments will need to be saved into the
database. I presume i will have to save the attachments somewhere
and then link to them, but i really haven't a clue where to start. Does
anybody have any information about this or even know where i can
look for information!
Thanks in advance!
Treasa
I am trying to do some different things and want to experiment at this time. You may think this is a C# question, but I have searched everything I can and can't find an answer. Everybody seems to understand it differently and do not give good answers. I have found that Access people are more creative, are willing to take a chance, and will understand the question.
I created a C# project. I created a database with a table in C#. Now, I would like to dump my data from Access into that table. The database is an .sdf file. If I can do this, I may use this as an Access FE BE later on.
Connect an existing Access project to a different SQL Server database and the instructions are so simple however when I get to On the file tab click SERVER to open the Data Link Properties Dialogue, there isn't a SERVER option to click on.
My SQL server was on my local machine because I use Goldmine PE 9.2. I moved the SQL server to a different machine, I can connect to it, I can use it with Goldmine, all is well from my local machine except when ever I use my .accdb file, since the SQL server has been moved, I have to login with each request by the access file. This is sometimes six and seven times per session, waiting, error message, logging in, waiting, error message, logging in until it has all it needs to produce my required lists. It's mind numbing and I can't for the life of me find where I can reconnect to the SQL database so I don't have to do this so many times per session.
In Access 2010 32bit running windows 7 64bit. How do I find the datalink properties to connect my .accdb to a different sql database?
I have a Back end (with password) which resides in a netdrive while the front end is installed in each individual users desktop, the problem is, some of the users netdrive was mapped in a different way (different letters..some are J others are G). I'm looking for code that I can relink the database to the front end in runtime, I did try to look in the net but I can't find anything that I can put the password as parameter.
this sample code from Dev is good, but i got an error because the database requires a password.where i can put the password?
Code:
Function fRefreshLinks(NewDbName As String) As Boolean
Dim strMsg As String, collTbls As Collection
Dim i As Integer, strDBPath As String, strTbl As String
Dim dbCurr As Database, dbLink As Database
Dim tdfLocal As TableDef
[code].....
I have Access 2007 and I use to be able to Hyperlink to an object in my database 9no upgrade0 But suddenly this option is not available. What can I do?
View 4 Replies View RelatedI have built a Database links to multiple back end databases. The whole database is completed, and I have to share it across the company, so I have placed the Database and all of the Back End databases on a "public" shared drive. I have the "public" drive stored as my Q drive. So when I link to the back end databases, the path it stores is Q:DatabasesDatabase.accdb
However, the problem is that not everyone will have the "public" drive mapped to Q. It's possible they could have it mapped to P or A or whatever. So if someone has their "public" drive mapped to P, this database will not work (since Q:DatabasesDatabase.accdb would not exist for them - it's really P:DatabasesDatabase.accdb).
Is there a way around this? So that instead of it mapping to the relative letter (Q or P), can it just refer to "public"?
Hi there,
I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?
In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.
\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt
In general how can you work in access with network path strings?
best regards,
Paul.
Hi there,
I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?
In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.
\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt
In general how can you work in access with network path strings?
best regards,
Paul.
Hello all,
I have a back end database that i cannot access at the moment. Is it possible to set the link of the tables for the front end application based on the location that the database will be even though i can't see that location now?
Thank you in advance.
I was wondering if it was possible to link random external tables to the Active Database through VBA. I would like to run the code that would open up a dialog box that would let the user select the database as well as the tables within that database that the user can select to link to. I am able to select the database and but not able to select the actual tables. The tables will be random so I can't make a constant statement for a specific database.
View 1 Replies View RelatedI am looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless there's an easier way to do it?) - some sample code - if this is possible at all?
View 2 Replies View RelatedI have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.
As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?
I have an Access DB with a form that allows the user to select a new backend database. I can connect to the backend and then .refreshlinks but nothing on the form is updated. I have tried requiring the form but that doesn't do anything. I've tried loads of other things, refresh, recalc etc., but nothing updates the open form.
The only way I have managed to get it to work is to close the form and reopen it, then it shows the data from the newly linked backend database.
While it works, it doesn't look good but also there seems to be some problem with it because eventually it reports an error saying "cannot open any more databases" and when clicking OK comes back with "An error occurred while sending data to the OLE server (the application used to create the object" and a whole bunch of other messages.
I think it might have something to do with the fact that the form has a number of MS graphs open on it, but I'm not sure. Also, I can't track down a particular line of VBA code which causes this error.
how to update a form after changing the backend database.
On a webserver certian files are stored above the root directory. Therefor the user of the website can never access those files directly. But he is utlizing that file.
For example:
We use Hotmail to see our mails. but we never download the complete database.
So is there a method that we can secure the backend using roaming profiles or something else so the user has a link to the backend but cant directly access the backend.
I have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies View RelatedHello 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..!!
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 RelatedDatabase: 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?