Database Splitter

B

Bessie

Hello everyone,

can a table be added to an already database splitter? if so, how do you go
about it and how do you link it to the table manager.

I appreciated this in advance
Bessie
 
R

Ricky Hicks MVP

Add your table to the BE file ...
Then from the FE .. use File/Get External Date/Link Tables to link to the
newly added table.

R. Hicks
 
G

Graham R Seach

Bessie,

1. Open the backend database (the one containing all the tables) for
exclusive access, and add the table as normal.
2. Open the frontend database (the one with all the code, forms, and so on).
3. On the Database Window, select the Tables tab.
4. Click New, then click Link Table.
5. Click OK.
6. Select the backend database.
7. Click Link.
8. Select the table you created in Step 1.
9. Click OK.

That's it!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
S

Sprinks

Bessie,

All the database splitter does is separate the data tables from everything
else, creating two .mdb files from the original one. Place the "data" file
on the server and separate copies of the "forms/reports" file locally on each
user's hard drive.

Add any new tables to the data, or "back-end" file (either by defining them
or linking them with File, Get External Data, Link Tables if they already
exist), and then link them into the "forms/report" file. Each user will need
to then replace his front-end file.

Sprinks
 
B

Bessie

Thanks you the best!

Bessie

Ricky Hicks MVP said:
Add your table to the BE file ...
Then from the FE .. use File/Get External Date/Link Tables to link to the
newly added table.

R. Hicks
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell Otpions in office environment 0
Database Splitter 6
Splitter error after making back end file. 1
connect database from internet 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Data Base Splitter Problem 2
Linked tables between FE and BE 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top