Home
Tuesday, May 30, 2017
8:47:24 AM
Users online: 0   You are here >> Home > Programming

Forums | Programming Forums search
Forum FAQ
   
  1  
Access Splitting Table and Forms into 2 seperate Files that are linked
Demonic 
25/8/08 4:59:31 PM
Guru

I know this is possible but can it be done to an existing database?

I have a single Table database that i designed as a client database however i need to roll out updates and i now know its best to have a file for my tables and another for my front end

How can i split my existing file so it reflects this front and back end style?

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

kikz 
25/8/08 8:38:36 PM
Immortal

create another access mdb file. import the table in to that. delete table from original database. add as linked table. profit.

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 + 2 x 320 Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

pappes 
25/8/08 8:58:54 PM
Titan

create a new access mdb file.
import the existing table in to that.
delete table from original database(compact and repair).
add a linked table to the mdb that has the form, linking back to the table in the new MDB.
charge the customer penalty rates for making you work in such a shitty architecure.

-----
I am petitioning to be the first person to be awarded a Nobel prize for prescience. It doesn't exist yet but mark my words it will.

kikz 
25/8/08 9:24:09 PM
Immortal

Quote by pappes
create a new access mdb file.
import the existing table in to that.
delete table from original database(compact and repair).
add a linked table to the mdb that has the form, linking back to the table in the new MDB.
charge the customer penalty rates for making you work in such a shitty architecure.


That's Access for ya.

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 + 2 x 320 Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Demonic 
26/8/08 4:01:14 PM
Guru

Great guys just did it alot simplier than i thought this will make those pesky updates alot easier to roll out

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

Demonic 
26/8/08 4:06:17 PM
Guru

I've run into a issue nothing serious but will make rolling out this update easier i rolled out the first version as a Access stand alone using the runtime so its got an extension .accdr is it possible to directly link to a .accdr file (the link wizard won't let me only if i rename it t .accdb will it work fine)

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

kikz 
26/8/08 6:22:18 PM
Immortal

You could deploy the data half of the database as an accdb/mdb and release the front end as a runtime. I think. It's been 9 years since I've worked with Access... :)

If you're worried about data integrity, encrypt the data db and use a password to access it.

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 + 2 x 320 Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Demonic 
26/8/08 8:49:34 PM
Guru

Nah im worried about exisiting clients this database was made by someone else at our company im expanding it to do alot more and just want a fast easy way to deploy the new one for clients

-----
Mr Trademart

TTV4 17/6/04 to 20/1/06

)Sydney(

  1  
Forums | Programming