I want to work on SQL Server tables located at my work place at home using Access. My question is; is it possible to link SQL Server tables on a server to my lap top computer using "Remote Desktop" or will I need to install Access onto the server and if tables can be linked using Remote Desktop how do I link them? I am using Access 2010 and have Windows 7 professional installed on my lap top.
View RepliesHi,
Current situation:
We have various departments using a Db and some of the users have drive mappings to different to others (company reasons). So far we have had to create different front-ends for each section, not very useful for updates etc.
What I'd like:
To be able to link to the tables on the server using the server name and not a specific drive letter.
My question:
Is this possible some how?
Would using SQL server for the back end be a way of getting round this issue?
Thanks for any assistance as usual
Matt
Hi Guys,
I am new to this forum and I am hoping you can help. I have produced an Access 97 database on a PC on the hard drive (C I have sent this to a client but he cannot run it as the backend data files are in C: and he is running the whole access programme on the R: drive. As the front end is an MDE file is there anyway I could write the path to the linked files so that access can find them automatically. The same problem applies with the help files, how can you define the location of the help files when you don't know the end users server location?
Any advice would be most welcome.
Regards
Chris
I have a windows 7 machine with Access 2000 installed. I need to link to some tables on an SQL server and "SQL Server" does not appear in the dropdown of available link types. I think a driver is missing. I did a clean install of Office 2000 and only selected MS Access. Maybe that prevented everything needed from being installed. I would like to add just the missing driver if possible.
View 1 Replies View RelatedI have a database with a front end and back end (tables on the server) that was recently converted from Access 2003 to Access 2010.
For some reason the back end keeps hanging and I have to constantly compact and repair and there has been major data loss on a regular basis.
Why is it when I click on the TblCarerdetails and try to open a record with the plus sign I am present with the following error message Enter Parameter value CarerID///The frmCarerRota seems to be working ok, the relationships seem to be ok i.e TblCarers can have many rotas i.e. a different TblRota each week (1 - M)
TblClients can have different TblRotas each week (1 - M).why the tables are not linking correctly, if I click on the TblCarer plus sign.I should see the Rota details and a plus sign. If click on the plus sign, I should see the clients details.Therefore I am assuming that my relationships are not correct, I think I need to add an association table, but where and what fields do I need to add/create.
Im in the process of developing my first database for my bonsai (small trees) collection. So far, ive developed a table of each of the trees I have, with fields such as Species, Where Bought, Cost etc and ultimately a link to a recent photograph (my next challenge). Ill be adding to this as my collection grows (in number and size). To avoid information duplication I have a separate table of care instructions for each species of tree with type, position they favour (eg Hardy/Delicate), watering requirements, wiring advice etc.
I now want to have a field in each of the records in the first table to its particular species care instructions as simple as that, or so I thought. ie for each different pine I want a link to the care guide for pines, and only pines. And preferably in a table format.
I need a one (second table) to many (first table) relationship and have linked them appropriately through primary field (species) and foreign field (care details). I have tried various Controls in the Design View but cannot get the field to show just one care record (ie the one for that particular species of tree). I realize this is possible, as its a common feature of a good database, and have found it being used in the various templates available - but not how they were created. The best Ive got to is using a Combo Box but this shows all of the care details records and in a column view.
I have two tables that I'm struggling with how to relate to each other. One is tblHardware which contains all the items that we sell. There are no duplicates in this table. The only columns are a part #, description, long description, and cost.
Then I have another table with is tblPackages. These are the packages we sell which pull from tblHardware. This one just has an autonumber, description, and image (image I'll add later and not worried about now).
What I'm struggling with is how to tie these two together because one Package will contain multiple items from Hardware however there are multiple Packages that have the same Hardware items (17" monitor for example).
Strewth didn't think I was ever going to work with Access again, but I am, so here comes a table link question for you.
Got an access xp FE linking to SQL server via a DSN file. All linked up fine, however the tables in access have been given a 'dbo_' prefix to the original table name in SQL server. :rolleyes:
How to get rid off?
A setting in the DSN file?
Some VBA to loop through each table and rename?
Linked table manager which I haven't got round to installing yet?
Thanks
Dan
I've been using a series of 5 tables to export an XML file using Access's native XML export. In order to keep the XML intact, there are relationships setup to link each sets of elements together via an ID number(link) field in each table.
Access does a great job at exporting, but then we need to rely on another program to delete these link fields that links the tables together so our XML validates. Additionally, we use this program to reorganize some of the XML, as one of our tables puts itself at the end of the XML element and not in the middle where it should be. This is not a problem when I'm dealing with a few hundred records, as the 3rd part program does the trick. The problem is when I have enough data to generate a 30+MB file that my other program chokes on when trying to manipulate the XML.
So my question is...how can I export these 5 tables to XML while omitting the linking member fields and organizing it how it should be? I have examples of code below. How Access Exports it
Code:
<MASTER-RECORDS>
<RECORD-ID-NUMBER>5648743524654</RECORD-ID-NUMBER>
<RECORD-ID-NAME>JOHN SMITH</RECORD-ID-NAME>
<link-for-pseudonyms>123456</<link-for-pseudonyms>
<PLACE>USA</PLACE>
<DAY>MONDAY</DAY>
[Code] .....
In Access can I link to a SQL Server view? I am currently linking to the
SQL Server tables in my database and don't have any views. But if I can link to views I could give the workgroup permissions in Access to the views, not to the primary tables. This would provide some added security from the user who bypasses my switchboard forms and goes to modify the Access tables directly.
I have a access DB for my employees with pictures. The main form displays their info and a picture as I scroll page to page. But I also have contact report that will show all info and picture. I am having difficulties linking the pictures from a seperate folder on my server.
View 4 Replies View RelatedI am attempting to link a table in one database to another database using the server name designation (ie.//2sxfprinff01Group) instead of the mapped network name (ie. G:). I tried relinking using the Access Link Manager. Right click on the linked table. But it does not let you edit the link.
Access 2007 does not allow this and reverts links to the G: drive. There are situations where the the IT department have set the mappings to this shared location as an H: for some of the employees. In those cases, the employee gets an error message telling them that Access cannot locate the G: drive.
An obvious solution is to get the employees remapped to the G: drive. However, one would think that MS would have allowed for mapping to the designated location and not an alias.
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?)
Currently trying to build a database for customer management and order placement/tracking. Want to set a couple of rules so that if I for instance click yes of billing and shipping address the same that the database will automatically fill the shipping address with the data I inputted for the billing address in the same table.
The other issue I can see I'll run into is, I want to be able to select one of the company ID's (made up of a three letter abbreviation of the full company name) in the product ordering table and it will automatically fill in the rest of the customer data (phone, email, address etc) data into that form.
I am doing a project where we are collecting home owner data and information on all the dogs in the household. The data for homeowner has an autonumber primary key because no field is unique or has been consistently collected. I am struggling to link the data for the dogs to the owners because an autonumber primary key will not work since not all homes have dogs. I need to have this set up so that people who are not tech savvy can look up each homeowner (or dog) and get the dog (or home owner) information. And to make things even more fun we need up to 15 potential dogs per household each of whom will have 18 different pieces of data collected.
It looks a little like this (and you can see my not matching ID issue):
Homeowner table
ID First Name Last Name...........Total Dogs
1 Max Maximus 5
2 Min Minimus 0
3 Mus Musculus 1
Dogs 1-5 table
ID Date Dog 1 Name Dog 2 Name .......Dog 5 Name
1 (Max's) 4/11/14 Bobby Billy Betty
2 (Mus's) 4/11/14 Jojo
Min will have no dog records at all, just home information.how to link the dog's to the homeowners .
I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.
I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.
Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.
My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?
I will be splitting the database once completed and then making a ACCDE file for my techs to use.
I have A db that links to a SQL Server table via an odbc connection. The problem is that I have to set up the odbc datasource on each machine that needs to run the db. Can I set up an ADO connection to the table and use that connection as a record source through out the app to drive forms , reports, etc? (And this would eliminate the need to set up and odbc connection to the table on each machine...) :confused: :confused:
View 6 Replies View RelatedWe have offices in other states that need to be able to open our data base. Due to the line speed it is extremely slow linking to our backend. Is it possible to have duplicate backends that can be merged, lets say over night or at the push of a button.
View 5 Replies View RelatedI have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every 10 days it's increasing upto 2gb but the strange thing is when I am doing cut / pasting same database to my desktop from the server shared folder it will become 80 mb only and I am again placing that db (80mb db) into the server and it will work. What is a reason behind it? why my 80mb db is showing 2gb db on server?
View 1 Replies View RelatedMy DB is split into BE and FE into about 5 Laptops. The DB is for entering personal information of pensioners.
sometimes it becomes necessary to take a computer away from the office to capture data of sick and aged pensioners. Now if you take the server (BE) out all the other clients (FE) will not work, and if you take a client out it wont work.
To solve the issue I decided to install a standalone version of the db in all the clients. If out of the network, the standalone DB is used and later captured data to betransfered to the server.
My question: Is there a code that I can use to check if my server is available to start the FE or if unavailable to start the standalone?
I need deleting a file from a ftp server. I have the code for uploading but I can't seem to figure out how to delete a file. This is the FTP module I'm using
Code:
Public Sub UploadFileToFTPServer()
On Error GoTo ErrHandler
Dim lngRet As Long
Dim abytData() As Long
Dim lngBytesWritten As Long
[Code] ....
And this is the code for uploading i use in the form when i click a button
Code:
Dim objFTP As FTP
Const conTARGET = "ftpserver"
Set objFTP = New FTP
With objFTP
[Code] ....
All that works like a charm.
Code to delete a file from the ftp server, i'm kind of stuck.
Hi,
I have build system DSN for SQL Server.I want to link table to the DSN.
But I can not select the DSN when I start the 'lined table Manager",I only can select files.why?
Please let me know how to link table to system DSN.
Thanks
Mark
I try to insert object (jpg file) to an (OLE datatype) field but it gives error message (OLE server) is not registered>
View 3 Replies View RelatedI am new in database design . I did a database by access 2010 which contain form and tables and i want to split it to backend and frontend and then make then in website
I need step in detalis to do that
How to split
How to put the backend on my site
How to make frontend in site
Any good program which will act as a B2B type gateway for MS access.
We currently have an access database which collects data and photographs of audits. This database is currently local and sends/receives data only whilst in the office. Ideally we'd like to do this over the internet by sending/receiving XML messages and somehow also photographs.