Results 1 to 8 of 8
  1. #1
    Lowell is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Location
    Manitoba, Canada
    Posts
    54

    Deploy same split database to different companies

    I have just finished reading forums for the last two hours.



    I cant find the info I need

    I once got a little complicated developed access program from someone that was split but came all in one install package.

    I have not figured out anywhere how to do that

    I deployed my split database with the backend in the same folder and tested it on a stand alone computer. It said my linked tables were not accessible because the file path was incorrect. So, I guess I don't know how to assign path names.

    I used Microsoft Developer Extensions to deploy

    Somehow I have to get the FE to know where the BE is. I think it needs to be in the linked tables manager. But I don't know. Should it look like this? C:\%Username%\Program_Files\

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    I don't have 2007 so I can't give precise instructions.

    But what you are looking for is the "Linked Table Manager"

    Just search Access Help for instructions on where to find it.

  3. #3
    Lowell is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Location
    Manitoba, Canada
    Posts
    54
    Well I actually do know where the linked table manager is.

    I have tried different things with it.

    So whatI do is set up the link. Then I package the program. I do an install. The linked tables in the Access Runtime version of my program still are linked to the file path on my developer computer. I cant edit the linked table path in runtime. So when the program is installed in one clients computer it finds the BE and permanently connects. 99% of the users will be single users on a single computer. Then when Isendan update the FE needs to stay linked or relearn.

    I am not one for code so I would like it pasted here if thats what the only wau to get it done is.

    Thanks for the reply anyway, rainlover

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    What are you saying here.

    Your Tables become unlinked when you create a Runtime.

    Is that your problem.?

  5. #5
    Lowell is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Location
    Manitoba, Canada
    Posts
    54
    No the tables are linked to the BE that is installed with the FE but the path name is incorrect or I guess you could say it is trying to get to my developer computer and it cant becaus obviously its not connected.

    This is what it looks like:

    C:\Myusername\programfiles\recordkeeping\Recordkee ping.accdb_be

    Instead it should be more down their line:

    C:\Theirusername\programfiles\recordkeeping\record keeping.accdb_be

    These are just typed in paths not actual. But I dont have any idea what their file path is going to be to get to where I place the BE, so how can I predestine the file path so itfinds the BE without the users input?

    Does this make sense now?

  6. #6
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Understood now.

    I can only think of a form with a search facility to find the Back End file.

    Place that in a control on the form.

    Then using VBA code Link to the new Location.

    I am not a Runtime expert and do not know if this woud be allowed.

  7. #7
    Lowell is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Location
    Manitoba, Canada
    Posts
    54
    Ya, I need to do something like that, but I don't know how.

    I have a program that does that, but it is in runtime mode, so I of course can't see how its programmed.

    I need someone here to tell me how to get the results I want.

  8. #8
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    You need to Google "Access Relink Front End"

    This or something similar should give you a starting point.

    When you find something and run into problems, Post back and we will see if we can help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple Companies Same Invoice
    By mikajake in forum Database Design
    Replies: 3
    Last Post: 02-28-2013, 01:39 AM
  2. How to deploy a database to be used on 2 different pcs
    By brownsugar7210 in forum Access
    Replies: 3
    Last Post: 01-14-2013, 06:02 PM
  3. show companies with null values
    By jamo in forum Programming
    Replies: 11
    Last Post: 11-06-2012, 08:11 AM
  4. How to best deploy a database?
    By robertdbuckley in forum Access
    Replies: 3
    Last Post: 05-23-2012, 12:28 PM
  5. Replies: 17
    Last Post: 01-15-2012, 11:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums