Moving Access Database To A Different Server / Share?

Jul 10, 2015

Currently I have an Access dB that was developed in A2003 but we are currently using A2010, it is accessed by multiple users that all have a frontend locally on there own networked PC's, with the backends etc on an old NT server, we are having problems with new technology accessing the NT server so it's well past time we got shut of it

We have a share on our network that has been made available to us to migrate all our NT server files to, Here's my problem, on testing the procedure I copied the database backend and .mdw file over to the share then tried to open the dB where upon i got the following error message

Cannot open microsoft Access database information file

On further investigation it seems that both the back end and the .mdw file have copied over with no content i.e filesize is 0kB, not only that the originals also seem to have had there content "deleted" a simple copy shouldn't have done this (I did have a backup btw)

View Replies


ADVERTISEMENT

Need Help Moving Linked Access Database To A MSSQL Server

Dec 19, 2006

Hi,
My access database's tables are currently linked to an excel document. My question is, how do I move my database to the network? Currently when I move the the database to the network no one can open my tables because the link goes to my documents on my computer which they can't access on the network.
So how do I move the database and maintain the link between the database and my tables?

Thanks in advance,

Ryan Smith

View 2 Replies View Related

Moving Database To Another Server

Dec 3, 2006

Howdy,

I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.

Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?

Thanks for any and all information you can pass along.

P

View 1 Replies View Related

Moving Split Database Back End To Sql Server

Jan 8, 2015

So the database I have right now is split, with the back end on our server. Everything has been going great, however there are several second time delays when loading large forms, queries, etc. I've heard that moving the back end to an sql server is the way to go for speed.All forms and queries are on front end of database. Tables are located on the back end which is sitting on the server.

View 7 Replies View Related

Share Problems With MS Access 2000 Database

May 16, 2007

I've been having some problems with sharing an MS Access 2000 database across a network.

The database is setup to open in shared mode and has been tried both with and without record locking, with the same issue occurring.

The main users are:
User 1 (Administrator) - MS Access 2000 Full Version (WinXP Professional)
User 2 - Access 2000 Runtime + Access 97 (Win XP Professional)
User 3 - Access 2000 Runtime + Access 97 (Win XP Professional)

The problem is occurring when User 3 opens the database. For some reason it opens in exclusive mode and locks out Users 1 & 2. This issue only happens with User 3, and does not happen with User 2 who has the same software setup.

The database was previously an Access 97 database (no problems) and has been converted to Access 2000, this share issue has been happening ever since the conversion.

Any ideas as to how this shared issue could be resolved? :confused:

BTW - I am familiar with FE/BE setups. This database is accessed by all from a network drive and not setup as FE/BE. This was never an issue, as shared access worked fine when the database was in Access 97 - the problem has only been since converting to Access 2000. I do not have access to the PC of User 2, and User 2 does not have any PC knowledge to install a FE, which means I would need to create an install package (which I'd rather not do). Are there any ways to resolve the shared access issue without changing to FE/BE?

View 2 Replies View Related

General :: How To Share Access Database On Company Intranet

Jan 14, 2015

I want to consider ways of sharing an Access database within our company. This could be web-based via our intranet or done some other way.

I understand that Microsoft's preferred way of sharing via an Intranet is to use SharePoint. However, as we don't use SharePoint (we use Atlassian Confluence) the cost of that route would be prohibitive.

Any methods of sharing an Access database across, say, 20 people? Simultaneous read/write access would be required but in reality the usage will be low, so performance is not really an issue. I would like to consider web-based or other methods.

I have chosen Access 2013 simply because we use Office Professional 2013 and Access will be familiar to some developers. We could use a different product. But I would certainly prefer a tool that supports RAD design of forms.

View 1 Replies View Related

How To Share Access Database Including Forms / Queries

Jun 9, 2015

I have an Acess database (2013). This will be used by several people within one company, they don't have their own server. I would use SharePoint Online, but it seems to me, that you only can "export" the tables. The database I have is quite a complicated system, and it is neccessary to use all the Access tools - forms, reports, queries. Not tables only.

Another idea is to split the database and "store" the backend part (the tables) on Sharepoint (Office 365 online version). And all the users would have their own frontend (forms, queries...) on their own PC, linked to this backend. Would this work? Can everyone add some entries into the database this way? How does it "synchronize" then?

View 1 Replies View Related

Access 2007 / Moving Database To Another Computer?

Nov 18, 2011

I'm using Access 2007 which I built a database that runs queries off of tables using ODBC. The database is all done in ms access, I've used no visual basic programing on it. I'm now trying to move a copy of the database to another computer's local drive in the office. When we try to open it on the other computer it gives me an error that says "There was a problem sending the command to the program" and Access hangs, which I then have to run task manager to end the program.

Specs Are: Windows 7 64bit (the db was created on Windows 7 32bit)

Microsoft Access Version 2007

View 4 Replies View Related

Moving Database To New Computer (Win XP Pro / Access 2003) - Data Has Become Read Only

Feb 20, 2013

Moving to new computer, both under Win XP pro, Access 2003. New computer is MacBook Air running Parallels. Transferred Access database via an external hard drive. Now the data shows up as Read Only. Is there a procedure to run down the cause and make the data accessible?

View 3 Replies View Related

Can't Share Database Between PCs.

Mar 28, 2008

I have this database that's been on a server for awhile. I thought I could ditch the server because there are only two computers networked here at the office.

I have the database shared from one computer, but when I try to access it from the other computer, it's giving me a path name error. It seems that the database is linked to and uses several other databases, so, when I try to open the main one, it's trying to look for the other databases on the wrong computer.

Anyone know how I can fix this?

View 5 Replies View Related

Remote Access To Database On Server

Sep 23, 2005

I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.

View 3 Replies View Related

Placing An Access Database On The Web/server

Jul 17, 2006

I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it interactive by means of searching. Thanks


Riley

View 1 Replies View Related

Using Access On A Server With Database On Local PC

Jun 29, 2014

I'll try to explain what I'm trying to do. I want to use the MS Access (2010) application residing on the remote server on a Access database(accdb) that is located on my local (home) PC. I copied the database from the server. How do I get Access (running on the server) to work on my copy of the database?

I tried using my local (on my PC) copy of MS Access (2007) to work on the database, but but I get file errors (file paths look like server paths).

View 14 Replies View Related

Access Front End Linked To SQL Server Database

May 24, 2006

Hi,

I created a database in Microsoft Access and then upsized it to SQL Server afterwards.

I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another table which contains a description of the column.
e.g.
Main_Table
Case_ID Foreign_Key_Field_ID
1234 78

New_Foreign_Key_Table
Foreign_Key_Field_ID Foreign_Key_Field_Desc
78 Describes the ID 78


I also setup a CONSTRAINTREFERENCE between the fields in these 2 tables.

I then relinked my tables using the Linked Table Manager to pick up the change to the table I altered (Main_Table). I also linked to the new table I created (New_Foreign_Key_Table).

My problem:
In Access if I create a new table I can select the lookup value for a field in the Table Design view Lookup tab. However, I altered my table in SQL Server and then linked to it again to pick up the change. Now when I view the linked table in Access it does not have any lookup value AND it's not possible to change this for a linked table.

Is there some piece of SQL I can use in SQL Server to change the lookup value for the field in my table OR have I approached this the wrong way. Should I have modified the local table in Access and upsized it again?

Otherwise if I select all values from my Main_Table in a form it displays the Foreign_Key_Field_ID instead of the Foreign_Key_Field_Desc because the lookup value has not been set to Foreign_Key_Field_Desc

This posting is a bit long - I hope it makes sense.

Any ideas or suggestions would be greatly appreciated.

Many Thanks

View 1 Replies View Related

How To Import MS Access Database Into SQL Server 2005

May 23, 2007

Hello,

I have a database MS access: test.mdb.

Is it possible to attach to SQL SERVER 2005, or any other solution ?

I need to transfer all the application:

structure and data.

How to do it?

Thank

View 2 Replies View Related

General :: Split Database Access FE And SQL Server BE

Mar 4, 2014

I am currently working on an application where I am using MS access as my FE and working with linked tables to SQL server BE. I also have a few temp tables within Access that are not linked but needed.

1. What are my steps into making this into a SPLIT DB? I am assume the BE will have my linked tables from SQL and the FE will have my temp tables and forms. Is this correct?
2. Once I split it, then I can make an .ACCDE file for a Mulit User environment, is this correct?

What other steps should I be made aware of?

View 8 Replies View Related

Good Place To Share Database.

Dec 3, 2004

Can anyone recommend a good place to upload a database so others can access it.

View 1 Replies View Related

Connect An Access Project With A Remote MDB Or SQL Server Database

Jan 28, 2007

Hi,

I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website?

If so can you give me some quick steps to do so or a good article on it?

Thanks.

View 6 Replies View Related

Queries :: Converted Desktop Access Database To SQL Server

Dec 5, 2014

I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.

Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?

View 10 Replies View Related

General :: Upsizing Access Database To SQL Server Error

Nov 4, 2013

I am trying to upsize the access database to sql server ,i have an odbc connection and when I try to move the tables,all the data is moving except one table "tblproductinfo" . I have attached the table data and error.

View 1 Replies View Related

Hosting Access 2010 Database On Windows Server?

Jun 17, 2012

I have a database which is now reasonably finished and am looking slightly ahead at how it can be accessed by the staff. The first clinic has two stations that need constant access to it, namely the clinic area and the reception area.The second clinic is about 3 kilometers distance away from the main clinic and will also need constant access which, I presume,would be by hosting the database on a Windows based Server, to which all three locations would connect and then be able to use the database directly. When I say Windows Server I mean as could be used to host a web site on the Internet rather than use of an internal Intranet system.

Should I split the database and only host the backend part on the server (i.e. the tables)?Does the whole database need to be uploaded to the Windows Server?Is any other software required to make this work?I presume that I would need to introduce record locking? Is this easily done and, if so, how?

View 3 Replies View Related

General :: Database In Read Only Mode On Server In Access 2010

Jul 18, 2012

I'm working in Access 2010. I created a database that I want to post in a server on the read-only mode, so that users can not change forms or querys. How can I do this in Access 2010?

View 11 Replies View Related

General :: One Button To Close All (Opening Access Database) On Server

Oct 14, 2014

Everytime i want to make some changes to my "Testing" Database , always got somebody using it / opening it...

I am trying to create a button , the function of the button is close "Testing" access database who using it or opening it , Example : 5 users included me in a company , when I click a button , 4 of them will received a notification with close "Testing" database message , can do that ?

View 1 Replies View Related

General :: Cannot Share Back End Database Under Multi User Environment

Apr 2, 2015

I have a Access data base (2007) which i splitted and store the back end database in a file server where all users have full control and the individual copies of front end put in the users computers. Unfortunately when one user is using the programme, others can not use. Following error msg appears. Both back end and front end are running under shared mode ( not exclusive ).

"Could not use xxxxxx_Be.accdb; file already in use."

View 5 Replies View Related

How To Share Access

Jan 14, 2008

I have created database and i would like to share it with multiple users and also i want them to make changes and update it as they go. My questions is:
how do i do that?
Can this be done?
Can several users be on the database at the sametime and make changes?

Pls. help..and also if you can tell me a link where i can find more info about this.. i would really appreciate. Thanks.

View 2 Replies View Related

General :: Share Access File

May 2, 2013

I'm using access 2010. how should I share the access file I created that will be the best way?there are 20 users that need to add/edit/view the data.I read in some places that I need to do share on options and some said that I need to split the file to data and front file.

View 3 Replies View Related







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