Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-18-2012, 09:28 PM   #1
jmilki
Newly Registered User
 
Join Date: Oct 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
jmilki is on a distinguished road
splited database

Hello everyone
I hope this is the right place to ask this question

I have a database I created in office 2010 64bit I split the database and put the back end in shared folder on the server
I have a few questions:
1. I have to remove from my computer office 2010 64bit and install in its place the 32 bit version. after the installation of the 32 bit version will the split database will work as usual even though it was created in a 64 bit version?
2. Is it possible to publish a split database to sql server?
Thank you

jmilki is offline   Reply With Quote
Old 10-19-2012, 03:36 AM   #2
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: splited database

Access 2010 64 bit and 32 bit function the same. You will not have any problems downgrading to 32 bit.

As for the 2nd question, yes you can publish a split DB to SQL server. If you have a server available already then I highly recomend it if you will have multiple people using your database at the same time since SQL handles that much better than Access does.
Tango is offline   Reply With Quote
Old 10-19-2012, 05:39 AM   #3
jmilki
Newly Registered User
 
Join Date: Oct 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
jmilki is on a distinguished road
Re: splited database

thank you!

jmilki is offline   Reply With Quote
Old 10-19-2012, 05:44 AM   #4
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: splited database

You are most welcome.
__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Database connection in excel to get data from password protected Access database AccessToAcess General 2 08-06-2012 06:40 AM
Copy table from one database to another(current) database with data, indexes and keys ramindya Modules & VBA 1 05-17-2012 12:09 AM
Code connect to database and query select data from database in Ms Access 2007 veasna Queries 2 11-29-2010 12:25 PM
Cannot find the database or some database objects the page refers to. Update the.... raggajunglist ASP and ASP.NET 1 06-04-2010 06:38 PM
splited bases and table-type Recordset pirena Modules & VBA 0 01-21-2010 02:30 AM




All times are GMT -8. The time now is 12:40 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World