The New Boy
New Member
- Joined
- Oct 5, 2006
- Messages
- 6
I have created an Access front end on to an Excel spreadsheet.
I created a Primary key at a late stage of the build and cannot get Access to save the Primary key as an Auto Number.
I also have problems that certain field formats in Access don't work because of conflicts with Excel.
I have deleted the linked table from Access then changed the format in Excel. I then got External data and linked Access to the same updated Excel spreadsheet. This didn't work.
How can i change formatting in Access when it won't let me save the correct disciplines in Table Form (Access) because i can't save when the Access / Excel tables are linked?
I created a Primary key at a late stage of the build and cannot get Access to save the Primary key as an Auto Number.
I also have problems that certain field formats in Access don't work because of conflicts with Excel.
I have deleted the linked table from Access then changed the format in Excel. I then got External data and linked Access to the same updated Excel spreadsheet. This didn't work.
How can i change formatting in Access when it won't let me save the correct disciplines in Table Form (Access) because i can't save when the Access / Excel tables are linked?