Linking Tables To BE Using Server Name, Possible?

Jan 3, 2008

Hi,
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

View Replies


ADVERTISEMENT

Linking Tables On A Server

Nov 8, 2004

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

View 9 Replies View Related

General :: Linking SQL Server Tables

Aug 28, 2012

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 3 Replies View Related

Linking To SQL Server

Sep 20, 2006

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

View 2 Replies View Related

Linking To SQL Server 2000 Views?

Jun 8, 2006

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.

View 2 Replies View Related

General :: SQL Server Not In Dropdown When Linking

Sep 18, 2013

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 Related

Linking Pictures From A Separate Folder On Server In Access DB

Nov 27, 2013

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 Related

Linking A Table Using Server Name Instead Of Mapped Network Drive

May 20, 2013

I 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.

View 3 Replies View Related

Tables :: Two Identical Database - Importing Tables By Linking To Data Source

Dec 3, 2012

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?)

View 1 Replies View Related

Tables :: Linking Field Data Between Tables And Within Tables

Sep 26, 2012

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.

View 2 Replies View Related

Tables :: Linking Tables With No Common Data And Different Numbers Of Observations?

Apr 15, 2014

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 .

View 3 Replies View Related

Tables :: Linking 5 Tables As Unable To Exceed 255 Rows

Mar 18, 2013

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.

View 4 Replies View Related

SQL Server Tables

Mar 16, 2006

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 Related

Link Tables To SQL Server

Nov 27, 2007

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

View 1 Replies View Related

Tables :: OLE Server Is Not Registered?

Aug 19, 2014

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 Related

MDB Linked To SQL Server Tables W/MDW Security

Jan 12, 2008

I am in need of some assistance regarding SQL Server ODBC links and security. This is for a project at work...

1) I have an MDB that has linked tables through ODBC to a SQL Server 2000 database. This is how I chose to write this multi-user application (instead of the ADP method).

2) My IT department created a user ID that the application will use to connect to the database. They chose this method instead of having to create many user accounts with varying permissions. I have programmed permissions within the application.

3) After linking the tables through ODBC, it defaults to my Windows User ID for the connection. Because of this, I have used a connection string with the application's User ID/Password and perform a RefreshLink on all linked table definitions on startup to ensure valid connection.

This is successful, but my IT department is seeing that another user is attempting access to the SQL Server database--the username in the LDB/MDW file! This is what I don't understand. If I open the database without going through workgroup security, the word "Admin" is passed and the authentication fails. If my users would login through the MDW file, their user IDs would be passed and again, authentication will fail as they are not valid users (only the application ID would be valid).

What is really going on here? :confused: How can I prevent the "Microsoft Access User ID" from being passed through the ODBC link?

Here is a sample of the connection string I'm using:
Driver={SQL Server};Server=ServerName;PersistSecurityInfo=Yes; AnsiNPW=No;Database=DBName;Uid=Username;Pwd=Passwo rd;

View 2 Replies View Related

How To Export Tables From SQL Server To MS-Access

Mar 25, 2007

Hi all,

I have faced with one problem that is how to export Tables from SQL server to MS-Access.

could anyone plz help me

Thanks,
Bhaskar.

View 1 Replies View Related

Link To Sql Server Tables On Internet

Jun 14, 2007

I would like to use a local Access front end to edit tables linked to a SQL Server database located on my Internet host provider's server. I haven't been able to find any information about how to do this or whether it is even possible.

If I need to set up an ODBC source, how can I do that for a non-local (Internet) SQL Server database?

Can anyone help?

View 1 Replies View Related

Back Up Tables Inside A Server

May 12, 2006

Hi
I have 5 PC clients and a server.each user upon shutting down his PC,is prompted to send all the information inside a table "Patron" to a table inside the server.That way each user backs up his information to a table inside the server and at the end of the day,the table on the server side contains all the data from the 5 PCs.I am new to access,can anyone guide me through the steps I need to accomplish this project?
thanks in advance

View 1 Replies View Related

Is Pessimistic Locking For Linked SQL Server Tables Possible?

Feb 1, 2006

Hi you geniuses!

I just had to upsize my loved and complex Access database to SQL server 2000 and had to link all tables via ODBC into my client Access database.

I used to use pessimistic locking on all tables when the tables were in an Access database before - worked fine ...

but now my client Access database uses "No Locks" on these tables because they are controlled by SQL server 2000.

Does some genius know how to change this bad behaviour? :confused:

View 3 Replies View Related

Linked SQL Server Tables In Access 2003

Apr 16, 2007

We are sharing an Access 2003 database amongst two departments that contains twelve (12) tables that are SQL Server linked tables. Nine (9) of the tables work just fine for people in both departments. Three (3) of the tables cannot be opened until the user refreshes the link(s) using their ODBC DSN.

We do not understand why nine of the tables work without issue but three will not.

Has anyone ever run into this issue before? Does anyone have any ideas on how to resolve this issue?

Thanks

View 1 Replies View Related

Link To Tables On Server From Local Machine

Oct 10, 2004

Hi,

I'm trying to establish the link from my local mdb to an mdb on a commercial server I'm using.

The problem is there's no way to locate the remote access database when using the Link Table wizard.

Anyone knows how to establish that connection??

Thanks in advance!

View 2 Replies View Related

Modules & VBA :: How To Alter Tables In SQL Server From Access

Jul 7, 2015

I have an access front-end package that works just fine but if there is an update, I just want the program to run scripts to update the SQL Server tables that it is connected to. I just don't know how to do this. I know how to do this on SQL Server Management studio and all, I just was hoping I could do it straight from my access front end so that a user could just click a button and update the tables or something.

View 9 Replies View Related

Tables :: Alter SQL Server Table From Front End?

Aug 1, 2014

I have an Access 2010 front end with linked tables via ODBC to a SQL Server back end. Is it possible to add, delete, and otherwise alter the tables on the SQL server from the Access front end? I've tried the following but received an error "cannot execute data definition statements on linked data sources"

DoCmd.RunSQL "alter table [dbo_tblAccountsMvOld] add column [cnt] byte;"

Is there code that will let me do this?

View 1 Replies View Related

User-defined Datatype In A Sql Server Attached Tables

Dec 5, 2006

Hi all,I'm trying to attach some table from a Sql Server database, but when I take a look to the content, I see all the fields filled by the value "#CANCELLED".I supposed that the matter of such an issue could be the datatype used for some fields, a user-defined datatype. The only table content from the same Sql Server database I can see does not use that data type. I'm using a read-only account to access the Sql Server database. If I try to import the table, the data are imported correctly and the user-datatype is converted to text.Any suggestions for a solution / workaround ?Thanks Bye

View 4 Replies View Related

General :: Database Back End Keeps Hanging (Tables On Server)

Aug 10, 2012

I 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.

View 10 Replies View Related







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