Recent content by Dave31

Hi, I have two backends on two different servers overseas. I have a button which synchings up the data. The only problem now is, it seems to corrupt the backends (without actually corrupting any of the data) So, now when i go into the backend (to synch up) it produces 73 (ish) messages about...

Hi there, I have a list box used as a table for the user to select a particular work meeting to view. Now, is it possible for the user to manually change the size of the columns rather than having to define them in the properties section? Many thanks

also, when i export a table ("workProductTable"), a new table appears in my table list called workProductTable_ExportErrors. Any ideas on how to prevent this table appearing if there are errors?

I have looked through the forum, and cant seem to find the answer. What i want to do is export all my tables to 1 excel spreadsheet. Im using the code DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "workProductTable", "C:\Documents and Settings\My Documents\My...

actually, i managed to link them another way (as the only way i knew was to split it again) so it was kinda my own mistake, many thanks for your help :)

thanks, a second question, on my backend, i want have set a password so only i can gain access to the backend data. But when i try and relink the tables (and ive read that i should be prompted with the password screen so i can enter in the password and it stores it for future use) but currently...

This may seem like a silly question, but I can’t find the answer to it on this forum. People only say 'Remove the table links' but never how. I can’t seem to be able to remove the table links completely, so I only have one database file (no backend or frontend). I can’t seem to do it though the...

unfortunatly, if i try and relink the tables, it comes up with invalid password (again, its trying to access the data on the tables (backend) but cant as there is no place to enter the password) and no area to enter a new password. Any ideas?

I managed to password protect my backend (as the backend is on a server and anybody could access it) so i have it password protected so only i can gain access to the data. Now, when i try and access the backend from the front end, the frontend prompts me that the password is invalid (indicating...

Thanks Bob for that. I shall try this out and see if it works, if not, then i might take you up on that offer namliam.

i know this is probally a silly question, but how do i delete all the links from the front end to the back end? and how do i add new links in?

Ah ok cool, but where can I change this to the full UNC path? As when I split the database using the database splitter under 'Database Utilities' I don’t get the option to change it, but only save it to the server (where it picks up the letter drive) many thanks

I have a database that is split with a backend of a server, and a front end on each PC using the database. Normally, the server the backend is on is mapped to drive ('W'). Although, some people have mapped this server to another Drive (say 'X'). If the people who have it as mapped 'X' try and...

lol, true, but as the backend of the database is going to be on a server, so i was hoping that it could automaticly synch up through some sort of method :(

you can put that code in the Onload event so everytime you open up the form, it will check that the data is present or not and disable/enable the button as approprate. Although, as soon as you press the import button (if the import is enabled), the button should disable aswell. so add this to...