Search results

Hi, Thanks again, I've tried typing the database name in but it just creates a new table called 'Databasename_dbo_tablename' on the import instead of putting it into the correct table. It happens on any table, even if I create a new one. The adp is pointing to the correct database as every...

Database Permissions Thank you for your response, The new username and password does have ownership permissions.

if its an adp project, each version can only be opened by one person, each user needs their own copy of the front end (the adp file) for the system to be multi user.

Dear All, I'm trying to import a quite large text file (25mb) I had this working fine by using the transfertext command and having a schema.ini file, however having changed the username and password for my connection to SQL server all my tables and queries come with dbo attatched, which is...

Condition Formatting Hi in Access datasheets this is the same as Excel In design view for the datasheet (subform or main one) select the field you want to change colour (to change the whole record you'l have to repeat it for each field) then go to Format menu then condition formating. Then...

Dear All, I have written an adp project for Clocking in times. However I have come across a problem in my effort to speed up the project. I import data with all the clock in and out times in one record per day per person and when calculating when someone goes out for lunch this isn't a...